Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Wordpress Blog Andysworld! broke and very slow

Avatar of Andrew Hancock (VMware vExpert PRO / EE Fellow)
Andrew Hancock (VMware vExpert PRO / EE Fellow)Flag for United Kingdom of Great Britain and Northern Ireland asked on
PHPMySQL ServerWordPress
44 Comments1 Solution1508 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! - http://andysworld.org.uk), 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.

http://www.cyrus-consultants.co.uk
http://magclip.co.uk
http://gravelpitallotments.org.uk

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 JustHost.com

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

Andy