WordPress and my slow MySQL database issue is solved!
Posted By RichC on November 20, 2011
Finally, after about a month of trial and error fiddling with WordPress and MySQL since moving to a new server, 
I’ve figured out why MyDesultoryBlog has been so slow. Initially I blamed the new server since everything was fine at the old host, and even started to wonder if 6 years or so of daily blogging had finally hit a limit for “my” particular install or memory allocation. The experts that I talked with were all over the board and really not of much help – the same for searching, reading and posting on the WordPress support forums.
Finally after clearing out a few log files I looked at the plugin for handling 301 redirection and keeping track of 404 errors … “hmm, I was building up a pretty good sized log record.” The plug-in responsible for managing this is called Redirection and has a manual log deletion button. After who knows how many months … years probably … of building a substantial sized log, I finally deleted it (I could have emptied directly from MySQL, but the plug in button make it easy).
So my advice, if you are noticing database query slowness, and have already “repaired” and “optimized” your database, is to clear out any unneeded log files … especially the one being created by the Redirection plug-in … if you have it installed. Also under the “Options” link be sure to set the “Expire Logs” for something other than zero.
Comments