A number of WordPress plugins are notorious for not removing data after the plugin has been uninstalled – MonsterInsights is no exception. This can bloat the options database table. If you installed a couple of plugins to test on a site, then removed them, this can all lead to the options table growing or custom … Learn more…
Anybody who has had to export large WordPress databases will tell you it can often be an arduous task. If the database server crashes while exporting, you have to start over. If phpMyAdmin times out because the PHP handler has a low time out, you have to start over. If you are using the command … Learn more…
I get to do a lot of fun projects with my awesome clients on Codeable. This post was inspired by a client that wanted to delete a lot of WordPress posts with an empty title and content. I have no idea how they got there and neither did the site owner – it could have … Learn more…
I regularly troubleshoot slow MySQL queries for my awesome clients on Codeable. Luckily hosts like Kinsta and Cloudways provide New Relic integration which can help me pin down these slow queries and improve them. Hosts will be able to enable the raw MySQL query data for you if you share this guide with them as … Learn more…
In this post I will show you how to easily convert your WordPress database tables from the MyISAM engine to the InnoDB engine with WP-CLI. In case you are wondering why you would want to do this database conversion, this StackOverflow post highlights the improvements of InnoDB over MySIAM (taking advantage of multiple cores is … Learn more…