troubleshooting Question

Wordpress Blog Andysworld! broke and very slow

Avatar of Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)Flag for United Kingdom of Great Britain and Northern Ireland asked on
PHPMySQL ServerWordPress
44 Comments9 Solutions1508 ViewsLast Modified:
I'm going to kick this off now the Hosting Provider assues me they've not made any changes.

I have a blog in Wordpress - 2.7.1 (Andysworld! -, that I've not made any changes to, e.g. added plugins, changed code, upgraded and has been stable and working correclly for many years, until Feb 4th 2010.

I currently have about 950 posts, and regularly just add another post, day by day on occasion.

Having broadband issues, but that's another issue, so posted a blog yesterday evening, and I was surprised that the Admin Panel is functioning normally, but then on checking the blog, post after viewing the website did not appear. I suspected it could be because of the heavy content on the first page, which has not caused issues before but with slow, failing broadband a possibility.

This has now been confirmed by other friends with faster broadband, there is an issue.

I'm certain this is db mysql related, maybe I need to "clean optimize the database", it would appear, that it the website fetches a page from cache (I use Supercache always have), there are no issues, as you would expect being fetched from cache, if I turn cache off, website almost crawls to a halt.

I have other websites hosted in Wordpress on the same host, in my "hosting area" which have no issues currently, although total content (958 posts) is much less.

any thoughts? places to start looking?

I did think about upgrading to at least 2.9.1 and using WP Clean Fix, but if I've got database access issues, slowness, WP Clean Fix, may take days or not work.

other weird issues, post set as Draft appear, and vice versa, which seems db related to me.

I've got backups of the databases, and was thinking of porting local to Linux Distro, with LAMP and testing locally.

or could switch to a new blank db and test with single post?

or something to check db, or check db performance to confirm if it's the Database, or database server.

I'm using

Apache version       2.2.19
PHP version               5.2.17
MySQL version       5.1.56

Okay, not normally,  in these zones, and this side of the fence, so treat me nicely!

thanks for reading

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 9 Answers and 44 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 9 Answers and 44 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros