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