MySQL Archives

Query all WordPress posts in MySQL not having a Yoast SEO meta description

WordPress / By Jan Reilink / 02/12/2022

If you just started using Yoast SEO it’s sometimes nice to know which posts don’t have a meta description yet. Knowing this, you can add the description which is good for your SEO results. Here is a query you can use to query all posts in WordPress not having a Yoast SEO meta description yet. You can run this on your MySQL prompt or in phpMyAdmin.

…

Query all WordPress posts in MySQL not having a Yoast SEO meta descriptionRead More »

Disable Joomla Contacts component (com_contact) in MySQL / phpMyAdmin

Web applications / By Jan Reilink / 05/01/2021

Often the built-in Joomla contact forms component (com_contact) is abused by spammers. These contact forms allow the sender to receive a copy of the form contents. All spammers need to do is enter the email address of the target as sender/from. This way, anyone can use the Joomla contact form for spamming anyone. This short article explains how to disable and combat this.

…

Disable Joomla Contacts component (com_contact) in MySQL / phpMyAdminRead More »

Disable WordPress XCloner Plugin logger in MySQL / phpMyAdmin

WordPress / By Jan Reilink / 05/01/2021

If XCloner Logger option is enabled, it will store a log file inside the xcloner-XXXXX folder inside the backup archive. The file is named xcloner-xxxxx.log. This can generate a huge amount of temporary files and log files on your file system. This short article provides you one SQL statement to disable XCloner log directly in your WordPress MySQL database, using phpMyAdmin.

…

Disable WordPress XCloner Plugin logger in MySQL / phpMyAdminRead More »

How to Fix Yoast SEO for WordPress DeleteDuplicateIndexables MySQL error

WordPress / By Jan Reilink / 28/05/2020

In recent days, there are a number of reports about broken Yoast SEO database operations, related to the DeleteDuplicateIndexables function. The PHP function is located in the file wordpress-seo\src\config\migrations\20200507054848_DeleteDuplicateIndexables.php, and in this post I’ll provide you with a possible fix for this statement. Read on.

…

How to Fix Yoast SEO for WordPress DeleteDuplicateIndexables MySQL errorRead More »

Reduce Wordfence CPU usage, disable Wordfence “Live Traffic View”

WordPress / By Jan Reilink / 23/09/2019

Whenever WordPress is using a lot of CPU and you have Wordfence Security plugin enabled, it is recommended to double check some settings. Unfortunately the Wordfence “Live Traffic Options” (“Traffic logging mode”) feature can cause high CPU usage and load issues for WordPress websites. Therefore, I recommend you disable this feature to improve the performance of your WordPress website.

…

Reduce Wordfence CPU usage, disable Wordfence “Live Traffic View”Read More »

ASP and ASP.NET connectionstring examples for Microsoft SQL Server and MySQL

Code base / By Jan Reilink / 17/10/2018

A connectionstring is sometimes a bit obscure. Do I need ODBC or OLE DB? When you need one and Google for it, you often find old ones that either don’t work at all anymore, or are not optimal. This article provides you with a couple of ASP.NET to SQL Server connectionstring examples, and as a bonus for ASP to MySQL too.

…

ASP and ASP.NET connectionstring examples for Microsoft SQL Server and MySQLRead More »

MySQL Connector/ODBC C# test script

Code base / By Jan Reilink / 03/10/2018

Whenever you need to test your ASP.NET connection to your MySQL database, using ODBC, you can use the following C# test script. Currently it uses MySQL ODBC 8.0 Unicode Driver, but you can easily change the version used. As a bonus it prints some connection information and it requires an SSL connection to your MySQL database (SslMode=REQUIRED).

…

MySQL Connector/ODBC C# test scriptRead More »

How to use SSL in PHP Data Objects (PDO) mysql

Code base / By Jan Reilink / 07/08/2018

If you want to connect securely to your MySQL database using PHP Data Objects (PDO), here is how to connect to MySQL with PHP PDO using an SSL encrypted connection.

…

How to use SSL in PHP Data Objects (PDO) mysqlRead More »

Restore single MySQL table from a full mysqldump backup file

MySQL / By Jan Reilink / 21/08/2017

MySQL fix. Image via Flickr by Luis M. Gallardo D

If you need to restore a single table from a full MySQL backup, you may find yourself wondering “how do I do that?”. There are a few steps required, I outline them here for you to restore the contents of just one table back into the database from the mysqldump using Bash.

…

Restore single MySQL table from a full mysqldump backup fileRead More »

Optimized WordPress hosting (9+ practical tips)

WordPress / By Jan Reilink / 31/08/2016

Your WordPress hosting at Warp Speed - img. credits: Christian Daryanto Limas @ flickr

Optimized WordPress hosting is a subject on which a lot is written about. And therefore, this post is not about where to host your WordPress blog, or who offers the best WordPress hosting. This post is for you developers, what you can do to optimize your WordPress hosting. Or for any other PHP web application for that matter. This post is not about setting up high-availability, fail-over, clustering, IIS versus Nginx versus Apache, RAID 1, 5, 6, 10, different types of storage, and so on. It’s about solving performance issues.

…

Optimized WordPress hosting (9+ practical tips)Read More »

MySQL InnoDB performance improvement: InnoDB buffer pool instances – Updated!

MySQL / By Jan Reilink / 10/06/2016

Are you running into MySQL load problems? Learn how to tune MySQL servers for a heavy InnoDB workload, by configuring innodb_buffer_pool_instances and increasing read/write I/O threads. Dividing the InnoDB buffer pool into multiple instances can improve Disk I/O. By doing so, you run your database more efficiently and faster. Here is a little help for you.

…

MySQL InnoDB performance improvement: InnoDB buffer pool instances – Updated!Read More »

MySQL DoS in the Procedure Analyse Function – CVE-2015-4870

MySQL / By Jan Reilink / 30/05/2016

Sri Lankan Security researcher Osanda Malith discovered a DoS -or crash- vulnerability in MySQL’s Procedure Analyse Function. The vulnerability crashes MySQL versions up to 5.5.45.

…

MySQL DoS in the Procedure Analyse Function – CVE-2015-4870Read More »

Optimize WordPress MySQL tables through Cron, behind the scenes

WordPress / By Jan Reilink / 04/03/2016

To regularly optimize my WordPress database tables, I created a small plugin that utilizes the WordPress Cron feature. This comes in handy to perform database optimization for WordPress on a regular basis, without forgetting about it. Just activate and enjoy. And here is the plugin code.

…

Optimize WordPress MySQL tables through Cron, behind the scenesRead More »

Convert PHP ext/mysql to MySQLi

Code base / By Jan Reilink / 04/02/2015

This post will show you how to convert PHP mysql extension functions to PHP MySQLi extension. Migrating away from ext/mysql to MySQLi (or PHP Data Object (PDO)) is important, because the ext/mysql functions are deprecated as of PHP 5.5.0. If you do not update your PHP code, your website will fail soon!

…

Convert PHP ext/mysql to MySQLiRead More »

How to restore a deleted Open-Xchange context?

GNU Linux / By Jan Reilink / 21/01/2015

How to restore, or recover, an accidentally deleted OX context. If you’ve accidentally deleted an Open-Xchange context (contextid), then that is bad… Here is how to recover a deleted OX context and filestore… Assuming you make backups of course.

…

How to restore a deleted Open-Xchange context?Read More »