Sites suddenly slow - WP 3.5 to blame?

wordpress

#1

Hi, several of the WordPress sites I have hosted on Dreamhost slowed down today to the point of almost timing out completely. I noticed this tends to be effecting the sites I updated to WordPress 3.5 recently. Is there any known issue there?

The slow speed is most noticeable on the backend (/wp-admin/) which is taking forever to load when just 24 hours ago it was lightning fast. Please let me know what could be going on here.

Here are the sites I am having the most issues with. Both are in development and the only major change I made to them in the past few days was upgrade to WP 3.5:

http://www.thegreekbellydancer.com/

http://www.rockfarm.com/ - this site in particular I haven’t even done anything to for several days but all of the sudden it went to a snail’s pace in the past 24 hours!


#2

It’s possible, but WP 3.5 should have actually sped a couple things up.

Try putting this in your wp-config.php file, above the ‘stop editing here’ line:

define('CONCATENATE_SCRIPTS', false); 

#3

I tried that, but it didn’t seem to affect anything.

I have upgraded the following sites to WP3.5 and am running almost identical plugins on them, but am experiencing absolutely no loading problems whatsoever:


http://www.fonzettilaw.com/
http://www.amandamusumeci.com/
http://www.optimiskeptic.com/

However, with these two websites, clicking on ANYTHING - just loading the admin login takes about 3-5 minutes for the page to load. Could it be the database? I am getting no error log. I’m at a total loss here.
[hr]
What is even weirder is that even though it takes about 3-5 minutes for anything to load on the backend, ever once and a while, clicking links will load pages normally - instantly almost - for about 15 seconds. Then it goes back to taking forever.
[hr]
I thought I figured out what the problem may be. I deactivated plugins and re-activated them one at a time. It seemed like the plugin that was supposed to SPEED UP the site was actually slowing it down somehow:

DB Cache Reloaded Fix

HOWEVER… as it turns out both sites are slow again after deactivating that (and all other) plugins. It was only temporarily working at a normal speed for a several minutes there, but now it is back to slower-than-snail speed… This is extremely frustrating! :frowning:


#4

Try using WP Super Cache, or W3 Total Cache. They’re much better caching plugins.

DB caching is … well I don’t advocate it in general. A busy site is making too many DB calls for it to be super effective.


#5

I agree. I am experimenting with W3 Total Cache right now and been pleased with WP Super Cache as well.

However, that still doesn’t fix my problem with these 2 sites - which isn’t running any caching programs. There has has to be something wrong with the databases… which is a real bummer because I have done so much work on the rockfarm.com site I am not entirely sure that backing up the site files and doing a fresh WP install / database setup isn’t going to force me to set everything up again from scratch. Help! :frowning:
[hr]
Okay, so I tried logging into the phpMyAdmin for several of my databases… those two particular databases are NOT working at all which makes me think this is a MySQL problem for sure. Which leaves me somewhat up a creek since that is my weakest area.

Could this be related to the MySQL server problems Dreamhost was experiencing earlier? These sites both started acting up at almost the exact same time Dreamhost announced the server issues.


#6

Nice detective work! I think you’re right.

Can you get in to phpMyAdmin at all? IF so, you can try running a repair on the tables on your own (though make a backup first, for safety and cookies’ sake).


#7

Have I told you how GRATEFUL I am for your feeback/help up to this point?? THANK YOU. =o)

I got into phpMyAdmin and already ran a table repair as a precaution. I don’t think the tables are the problem though for two reasons: (1) the table repair didn’t change anything - still getting up to several minutes of lag on the site and in the phpMyAdmin… and (2) why would messed up tables cause phpMyAdmin to be slowing down?

I pinged the mysql.thegreekbellydancer.com server and had no troubles, but when I ran a tracert the results were mixed. Some of the packets came back instantly while a few others got held up and timed out…

Which makes absolutely no sense because the MySQL servers for both of those sites are the exact same IP address as all my other sites! [173.236.207.200]. Something is rotten in Denmark…

Tracing route to mysql.thegreekbellydancer.com [173.236.207.200]
over a maximum of 30 hops:

1 1 ms 1 ms 1 ms home [192.168.1.254]
2 11 ms 11 ms 11 ms adsl-76-223-255-254.dsl.emhril.sbcglobal.net [76.223.255.254]
3 10 ms 11 ms 10 ms 68.250.251.66
4 11 ms 11 ms 10 ms dist1-g2-4.emhril.sbcglobal.net [151.164.53.130]
5 12 ms 11 ms 11 ms bb1-g9-0.emhril.sbcglobal.net [151.164.94.162]
6 68 ms 68 ms 68 ms 12.122.104.69
7 * * * Request timed out.
8 70 ms 70 ms 70 ms border3.po2-20g-bbnet2.lax010.pnap.net [216.52.255.101]
9 70 ms 70 ms 70 ms dreamhost-1.border3.lax010.pnap.net [64.7.192.250]
10 69 ms * * 66.33.203.4
11 * 119 ms * rampart-0.hq.newdream.net [66.33.201.2]
12 69 ms 70 ms 70 ms escandon.snap.dreamhost.com [173.236.207.200]

Tracing route to mysql.thegreekbellydancer.com [173.236.207.200]
over a maximum of 30 hops:

1 <1 ms 1 ms 1 ms home [192.168.1.254]
2 9 ms 13 ms 13 ms adsl-76-223-255-254.dsl.emhril.sbcglobal.net [76.223.255.254]
3 12 ms 11 ms 11 ms 68.250.251.66
4 11 ms 10 ms 13 ms dist1-g2-4.emhril.sbcglobal.net [151.164.53.130]
5 11 ms 11 ms 11 ms bb1-g9-0.emhril.sbcglobal.net [151.164.94.162]
6 68 ms 68 ms 75 ms 12.122.104.69
7 * * * Request timed out.
8 85 ms 79 ms 78 ms border3.po2-20g-bbnet2.lax010.pnap.net [216.52.255.101]
9 70 ms 71 ms 70 ms dreamhost-1.border3.lax010.pnap.net [64.7.192.250]
10 * 69 ms 72 ms gar-border-1.dreamhost.com [66.33.203.4]
11 * * * Request timed out.
12 79 ms 80 ms 80 ms escandon.snap.dreamhost.com [173.236.207.200]
[hr]
MAGIC! I submitted a trouble ticket about an hour ago Matt S reset my Apache server instances and now everything is working again A-okay! :slight_smile:

I wish I understood this stuff better.


#8

Huzzah for Matt S! :slight_smile:

Messed up tables are impressive in the number of ways they bog down the site. It’s kind of a snowball effect. Once the table is broken, that site runs slow, and slows down everyone around it. I’ve had cases where I had to turn off http in order to repair the table, because as soon as it was on, everyone hit the site.

If this happens again, though, please remind us that it’s a repeat event! Sometimes weird server stuff just happens, but when they keep on happening, we know it’s time to look into everything even closer :slight_smile:

Thank you for being so cool about all this! Customers like you make me happy I work here :slight_smile:


#9

Hello,

I seem to be having the same problem. Already tried repairing the mysql database with no change. I submitted help tickets to DreamHost about 12 hours ago and about one hour ago, but I’m very anxious about this, as today is the launch day of our software, and a slow site is the last thing we want. Is there anything else we should check to try to fix this? I tried traceroute, with the following output:

traceroute to hexraystudios.com (64.111.127.137), 64 hops max, 52 byte packets
1 router-129-186-192-0-subnet.iastate.edu (129.186.192.254) 1.672 ms 0.976 ms 1.676 ms
2 b31dmz1-vlan254.tele.iastate.edu (129.186.254.131) 2.360 ms 1.694 ms 1.478 ms
3 b31gb2-438.tele.iastate.edu (192.245.179.52) 1.149 ms 2.883 ms 2.007 ms
4 164.113.232.225 (164.113.232.225) 5.446 ms 5.842 ms 5.355 ms
5 xe-0-0-0.493.dlls0.tr-cps.internet2.edu (64.57.29.201) 15.061 ms 15.065 ms 15.192 ms
6 64.57.20.46 (64.57.20.46) 15.882 ms 15.206 ms 36.180 ms
7 xe-3-1-0.cr1.dfw2.us.above.net (64.125.30.82) 15.506 ms 15.334 ms 15.437 ms
8 xe-1-2-0.cr1.iah1.us.above.net (64.125.26.130) 20.515 ms 20.554 ms 20.763 ms
9 xe-5-0-0.cr1.dca2.us.above.net (64.125.31.214) 46.698 ms 41.780 ms 41.765 ms
10 xe-0-0-1.er1.iad10.us.above.net (64.125.31.206) 41.742 ms 41.722 ms 41.730 ms
11 xe-1-0-0.er5.iad10.us.above.net (64.125.24.133) 95.059 ms 56.832 ms 41.602 ms
12 208.185.23.134.t00867-03.above.net (208.185.23.134) 43.977 ms 41.701 ms 44.479 ms
13 ip-208-113-156-6.dreamhost.com (208.113.156.6) 43.778 ms 43.766 ms 43.532 ms
14 ip-208-113-156-14.dreamhost.com (208.113.156.14) 43.613 ms 51.968 ms 45.097 ms
15 * * *
16 * * *
(the stars repeat indefinitely)

Thanks for your help!

Ken
Co-Founder, Hex-Ray Studios
http://hexraystudios.com


#10

FWIW, Dreamhost answers most tickets within 24 hours unless you have paid for premium support or have a premium product. You didn’t say if you were using shared hosting, VPS or Dedicated, but checking hexraystudios.com it looks like it’s on shared to me.

The good news is that your site seems to be loading fine for me, at this time anyway.


#11

Thanks for the reply. I got a little worried when I saw another thread from someone saying he’d gone ten days with no reply. The site isn’t nearly as bad as it was earlier, but it’s still not loading nearly as fast as our non-WordPress site, www.hexels.com. Hopefully there’s a quick and easy fix.


#12

Hey Ken!

We do strive to answer our support tickets within our 24-hour guarantee, though usually much sooner! I’m actually digging into hexraystudios.com, and it looks like you might be hitting your memory limits. Investigating now though, so I’ll email you back as soon as I have more info for you. Thanks so much for your patience!