Latest articles
Disable WordPress XCloner Plugin logger in MySQL / phpMyAdmin
If XCloner Logger option is enabled, it will store a log file inside the … Read More
How to Fix Yoast SEO for WordPress DeleteDuplicateIndexables MySQL error
In recent days, there are a number of reports about broken Yoast SEO database … Read More
Reduce Wordfence CPU usage, disable Wordfence “Live Traffic View”
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.
ASP and ASP.NET connection string examples for Microsoft SQL Server and MySQL
This article provides you with a couple of ASP.NET to SQL Server connection string examples for ODBC and OLE DB. And as a bonus for ASP to SQL Server, MySQL, and SSL encrypted connections too.
MySQL Connector/ODBC C# test script
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).
How to use SSL in PHP Data Objects (PDO) mysql
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.
Restore single MySQL table from a full mysqldump backup file
Here are the steps required to restore a single MySQL table from a full mysqldump database backup file on the command-line. 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.
How to optimize your WordPress hosting – 9+ practical tips
9+ Practical tips to optimize WordPress hosting, or any other PHP web application for that matter. Discover how this very blog has optimized its WordPress hosting environment and how you can too by optimizing MySQL, PHP and server configuration.
MySQL InnoDB performance improvement: InnoDB buffer pool instances – Updated!
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 DoS in the Procedure Analyse Function – CVE-2015-4870
Sri Lankan Security researcher Osanda Malith discovered a DoS -or crash- vulnerability in MySQL’s … Read More
Optimize WordPress MySQL tables through Cron, behind the scenes
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.
Convert PHP ext/mysql to MySQLi
This post will show you how to convert PHP mysql extension functions to PHP … Read More
How to restore a deleted Open-Xchange context?
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 Open-Xchange backups of course.
Disable WordPress comments (how-to)
When the WordPress comment option is abused by spammers, it becomes a real pain in the “@ss”. With thousands spam reactions, disabling -and removing- WordPress comments is the only way to go. Here is how to disable WordPress comments in both the WordPress Dashboard interface and in your MySQL database. As a bonus, I show you how to re-enable comments too!