Scheduled server maintenance complete
Our current server has been up non-stop for exactly a year. Over the last few weeks we had some slow loads and site errors, especially in blog comments. We did some scheduled maintenance a few hours ago, and the site was offline for a few minutes here and there.
The WordPress backend is up to full speed again. Comments seem to be faster, but we’re still not satisfied. We’re going to disable the Akismet spam filter and try some alternatives.
Today’s updates:
- System is updated from Debian 6.0.3 to latest stable release 6.0.6 and rebooted
- New version of eaccelerator is compiled for updated PHP 5.3.3-7+squeeze14
- Changed value ;suhosin.get.max_value_length = 1024 under /etc/php5/conf.d/suhosin.ini to solve errors related to piwik (traffic statistics software)
Please let us know how it’s working for you!
Sjaak:
December 26th, 2012 at 10:34 am
comments are working :)
alexlwa:
December 26th, 2012 at 10:39 am
test1
alexlwa:
December 26th, 2012 at 10:44 am
test2
Mats Engstrom (@matseng):
December 26th, 2012 at 10:46 am
Test to see if comments are faster now….
Mats Engstrom (@matseng):
December 26th, 2012 at 10:47 am
Well…. Faster then before where I got a timeout 90% of the time, but it still takes a good 20 seconds to post a comment,
Filip:
December 26th, 2012 at 10:48 am
Timed test
alexlwa:
December 26th, 2012 at 10:48 am
test3
Filip:
December 26th, 2012 at 10:48 am
14s exacly
Ian:
December 26th, 2012 at 10:51 am
I have a feeling the remaining speed issue is related to the spam filter that contacts a 3rd party server. I’m going to try a few different services to see if there is a faster one, or we can just not allow links in comments by unknown users.
Ian:
December 26th, 2012 at 10:52 am
Comment with Akismet disabled :)
Ian:
December 26th, 2012 at 10:53 am
Slightly faster, but still 5-10 seconds. A forum post is almost instant with more info and database stuff to deal with. Hum.
alexlwa:
December 26th, 2012 at 11:00 am
test4
Ian:
December 26th, 2012 at 11:01 am
Test without STC enabled…
Ian:
December 26th, 2012 at 11:02 am
reenabled
Ian:
December 26th, 2012 at 11:04 am
GRC disabled
Ian:
December 26th, 2012 at 11:18 am
some hacks to comment.php
Ian:
December 26th, 2012 at 11:19 am
removed comment.php hack…
wordpress.org/support/topic/comments-are-very-slow-to-post
Filip:
December 26th, 2012 at 11:20 am
test
alexlwa:
December 26th, 2012 at 11:48 am
test5
alexlwa:
December 26th, 2012 at 12:01 pm
test6
bearmos:
December 26th, 2012 at 1:00 pm
I was having slow load times in the forum – that’s speedy again now.
Grapsus:
December 26th, 2012 at 3:16 pm
You can have a full timing report with the PHP extension Xdebug, although I wouldn’t enable it in production, you’d need to clone your setup somewhere to be totally safe for testing.
Asm:
December 26th, 2012 at 3:34 pm
If the line says “;suhosin.get.max_value_length = 1024″ it’s commented out… changing it won’t do anything unless you uncomment it.
alexlwa:
December 26th, 2012 at 11:12 pm
test7
Sleepwalker3:
December 27th, 2012 at 8:44 am
@Ian, I sent an email about 5 minutes ago advising blog was fast (was very fast), but since then posted twice and noticed it was ‘ok’, but was taking maybe 15 seconds as a guess.
Sleepwalker3:
December 27th, 2012 at 8:45 am
Yep, that last post took about 15 seconds also
Ian:
December 27th, 2012 at 9:54 am
Posting with a debug plugin enabled.
Ian:
December 27th, 2012 at 9:56 am
Posting with a debug plugin enabled…. just takes me to a white screen, so there must be some horrible issue between wordpress and the plugin,..
Ian:
December 27th, 2012 at 9:59 am
test comment
Ian:
December 27th, 2012 at 10:08 am
test with debugger enabled.
Ian:
December 27th, 2012 at 10:10 am
wp-content/plugins/get-recent-comments/get-recent-comments.php:1321 – get_settings is deprecated since version 2.1! Use get_option() instead.
But I have tried without it before. Disabled anyways and testing now.
Ian:
December 27th, 2012 at 10:30 am
Not it… Now timing all MYSQL queries
Ian:
December 27th, 2012 at 10:32 am
Total query time: 87.3ms for 52 queries (0.087296009063721s)
Total num_query time: 0.438 for 58 num_queries.
ยป Different values in num_query and query? – please set the constant define(‘SAVEQUERIES’, true);in your wp-config.php
Page generated in 422.9ms; (0.4228839874267578125000s); 79.36% PHP; 20.64% MySQL
Ian:
December 27th, 2012 at 10:39 am
Curious that the page generates in half a second, but still takes 10 seconds or more to display.
My best guess is there is a missing file or bad permissions somewhere and it tried to do something until a timeout or error limit is reached. I don’t see anything in the logs to point to it though.
Worst case is a problem up in the multiple layers of acceleration and caching.
Ian:
December 27th, 2012 at 10:41 am
Memory & Load Time
Load Time: 266.999 ms
Max Execution Time: 60
Memory Used: 48.57MB
Memery Total: 512M
Included Files
Total Files: 181
Total Size: 4.12MB
Largest: 180.08kB
Ian:
December 27th, 2012 at 10:45 am
Time to finish off the workshop video, enough PHP debugging for now.
Ian:
December 27th, 2012 at 10:46 am
For real this time :)
Grapsus:
December 27th, 2012 at 1:43 pm
test with firebug enabled
Ian:
December 28th, 2012 at 5:18 pm
Test compared to alternate site
Ian:
December 28th, 2012 at 5:21 pm
and another with updated group permissions.