Slow mySQL queries on a brand-new WP blog that won't display!
I just recently installed WordPress 3.2.1 via Fantastico/cPanel on my domain a few days ago. I intend to use it for a webcomic, but I only edited the first post, installed some plug-ins and one theme, and made one About page.
Earlier today, I tried to access the site and it just kept waiting…and waiting…and stayed blank. I tried this in different browsers, on different OSes, with no luck.
I contacted my host’s support, and after a while, they told me that there were “slow mySQL queries” causing the problems, but did not go into more detail than that.
I have seen other folks here on the forums refer to this issue, but they seem to either a) have access to their site still (I do not; I can’t even get to the wp-admin area) or b) have some sort of log that can help diagnose which queries need tweaking.
I have already gone into PHPMyAdmin and optimized the table and also tried to repair it–everything is “fine.” My host’s support now says I need to contact a “PHP Developer,” but even if I do, I have no idea what to tell them as far as what’s going on.
I have other WordPress blogs (also 3.2.1) that I’ve installed myself, rather than through Fantastico, and they’re not experiencing any issues. Granted, they’re in a different database, but that’s the only difference I can think of outside of things like the plug-ins/themes, which all worked fine yesterday.
Can anyone help me figure out what’s going on, so I can at least get started in trying to fix this issue? How do I access logs for WordPress via PHPMyAdmin, or otherwise see what these slow queries are?
Have you tried:
– deactivating all plugins to see if this resolves the problem. If this works, re-activate the plugins one by one until you find the problematic plugin(s).
– switching to the Twenty Eleven theme to rule out any theme-specific problems.
– resetting the plugins folder by FTP or PhpMyAdmin. Sometimes, an apparently inactive plugin can still cause problems.
How do I deactivate or reset the plug-ins folder without access to the admin area? I’ve never had this issue with any of my other WP blogs before, so I’m not sure of how to do it.
I did get one more useful tidbit from my host: they said it was a plug-in that was causing “temporary table creation,” and that was the problem. However, I guess it’s not something I can watch in action by going to PHPMyAdmin while I try to access the site from another tab. So I don’t know what these tables are called or anything.
- The topic ‘Slow mySQL queries on a brand-new WP blog that won't display!’ is closed to new replies.