Hi all,
I've recently upgraded my site from 4.65 to 5.1 with the necessary 4.7 upgrade in between. Since the upgrade, my site has become ridiculously slow. Pages take anywhere from 10 to 20 seconds to render. I'm running the same number of modules as before the upgrade and even if I strip them out the speediest a page will load is in about 7 seconds which is not really acceptable.
I'm no MySQL expert, but I have the feeling that something has gone awry with my database. I checked out the MySQL status report at /admin/logs/status/sql and see these values which I am hoping someone can help me decipher. My logs are set to clear out every 2 days so I'm not sure if these values are for the lifetime of my site or just the past 2 days. These values are supposed to be zero, but several of them are in the millions. That can't be good.
Select_full_join 1519808 The number of joins without an index; should be zero.
Select_range_check 1750 The number of joins without an index; should be zero.
Sort_scan 14349818 The number of sorts done without using an index; should be zero.
Qcache_lowmem_prunes 77871955 The number of times that MySQL had to remove queries from the cache because it ran out of memory. Ideally should be zero.
My cron is running and the database has been optimized, but that doesn't make much of a difference. I've tried selectively removing modules to see if that does anything, but there's no one module that is making everything hang.
I've tried running the eval module, but the output is pretty much meaningless to me. The bottleneck seems to be the first two processes when the page loads. They typically eat up about six or seven seconds no matter what they are.
Some people have suggested it's the webhost, but things were fine the hour before I upgraded so I find that highly unlikely.
Have any of you experienced similar problems and figured out a fix?
Any help is appreciated.
Thanks,
/MS
Comments
I was running into a similar
I was running into a similar problem after a 4.6 to 4.7 to 5.1 upgrade, but it fixed itself after I reinstalled from a backup onto a clean server...could have been something acting wacky in the mysql cache. If you're able to, backing up your database and home directory and wiping the server and then reinstalling from there might correct it. Might be overkill, but it's worth a shot if nothing else works.
Starting with a new DB is marginally faster
I tried your advice and created a new database from a backup and the site seems to be a bit faster. Pages are rendering in the 6 to 10 second range which is still pretty slow, but it's certainly an improvement. I'll fool around some more to see if I can come up with any tweaks, but I've tried just about everything. Thanks for your suggestion.
/MS