Link to home
Start Free TrialLog in
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

Wordpress Blog Andysworld! broke and very slow

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
SOLUTION
Avatar of COBOLdinosaur
COBOLdinosaur
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Jason C. Levine
Jason C. Levine
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

ASKER

@COBOLdinosaur

Thanks for your reply. If I knew how to, I'm just a user of Wordpress, I know some php functions, like backup and restore. But queries, sorry you have to teach me on that.

@jason1178

Thanks also for reply.

Just tested the Admin Panel, I would say it comes up normally. Snappily. Everything seems to be in order, Posts and Pages, everything seems normal in the admin panel. The Wordpress Blog, should have mentioned, (but a littled jaded, been on this since 12.00 midnight, and need to rest soon), if I set to Settings, Reading to Static Page, seems ok-ish, but then it's not fetching from the db. If you then browse around your stuck again.

I'll turn on Debug mode.
@Ray_Paseur

Thanks Ray, yes PHP 5.2, has been preventing me from upgrading to latest Wordpress 3.3.x. They are currently looking at the server, I'm on, and have stated no issues with CPU/MEM/Bandwidth usages on the server.

They did state it was a WP issue, which is odd, again no changes, I've completed.

They have since restart MySQL, but if they had it's not made any difference.
I'm going to agree with my more illustrious colleagues and point the finger squarely at the mysql server and exonerate Wordpress.  "Normal" functionality appears to be fine, but the Loop is struggling.  I can't pull up any of your categories.

Is this Wordpress 3.31 or still in the twos?

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

There is a little-known feature of EE.  Every time the EOY posts a real question, it deducts a million points per Expert helping you :)
Hmm,

Now it seems to be snapping right along again...
Just a little update, been clicking an being patient....

I've left the website up, and if I click for instance

http://andysworld.org.uk/category/allotment/

eventually the site responds correctly, but takes a very long time to respond.

and I've left the query time at the bottom of the footer, never turn them off to give me an idea, and states 100 queries and 295 seconds, which seems very long.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
@jason1178 Thanks for reply.

Wordpress 2.7.1

Pop into my Zone anytime!

Virtualisation Expert, but MySQL, PHP eh - I hack at it! (but that makes me no Expert!).

This is what makes me think it's a poor MySQL DB Server.
Jason You're Wordpress guy, is there a way in wordpress to just run the queries without generating the pages just so we can see if the sql server is slow or if there is a problem in individual queries?

Cd&
I started disabling Widgets and was getting no where. I could start at the top again. That was my first course of action.

and then noticed, if I set to Single Page, the website would at least load, and of course, once the page is in the cache, it's okay, but if I turn off cache it's horrible.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Dump the cache and let it rebuild, too.
okay, I've got the database restored to local Linux server, just need to install Wordpress 2.7.1, and try here, I'll get all the plugins and code off the site and run local and see if it works okay.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Ah, yes that cache, yes, tried dumping many times, No effect, other than causing more issues and slower.

I'll try switching themes, i'm only using basic default. and download plugin.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Interesting selecting WordPress Classic.......Just sits there with the Flash Scroll Bars....

I only have Wordpress Classic and Wordpress Default which is what I'm using.
I never get the Activate option for the Theme. (back in 60 mins)
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
@kdebugs Thanks, yes that's slow.

@jason1178 okay, best course of action, is the website in it's current state, likely to hammer the server and increase CPU, becuase otherwise JustHost.com will disable my account.

and same question if I enable debug mode?
I've removed the Archives and Categories Widgets, and they are still appearing, and no change to speed.
>> Archives and Categories Widgets, and they are still appearing

That's the cache in action....
http://wordpress.org/extend/plugins/debug-objects/

no this does not function, Activates, and then screws everything up, and Admin Panel not available, had to remove debug-objects directory via ftp.
>> Archives and Categories Widgets, and they are still appearing

That's the cache in action....

Cache is Cleared!!!
okay, it's weird it's just laggy, okay, Archives and Categories are gone, not appearing...

http://andysworld.org.uk/category/computing/software-computing/

102 queries took 252 seconds

which seems very high
just clicked a recent item to see if it appears.....
okay, a recent item took 57 queries and 127 seconds,

i'm sure I seem to recall in the past a number of 8 queries, a 3 seconds came up. (maybe it's from memory)
Were you able to get debug objects installed?
NO.

http://wordpress.org/extend/plugins/debug-objects/

no this does not function, Activates, and then screws everything up, and Admin Panel not available, had to remove debug-objects directory via ftp.

Okay, I've got wordpress and the database running on a Linux Server in the office. Bloody Hell it's fast!

Now this is vanilla 2.7.1 just with my database, and no plugins or the code up on live.

so I could transfer all the code, plugins, images, and get a Dev Site up, and see what breaks.

if this is going to help, or I'll turn OFF all the plugins on live.
Okay.  You can try that.

Do you have the ability to work at the mysql command line with this hosting?
Unfortunately, no console access, only phpmyadmin.
Okay, I'm going to have a rest. been on this for 20 hours straight. I'll wait and start again on Monday, just in case Just Host, find something or change something back!

Monday, disable all plugins. Catch you then, thanks for your assitance.
Okay, guys, I got bored on a Sunday, I'm sure all you peeps, away from the keyboard, get the jitters!

Seem to be getting somewhere, diabled a bunch of plugins in batches, and we seem to be back to normal.

17 Queries 0.25 seconds to display homepage and 10 last posts.

So just need to find the offending plugin, that's gone bad!

So it's always the simple things, rather than me looking for something more difficult!
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You should be able to get to 3.0 on PHP 5.2...
Yes, I've been thinking about upgrading for while, but did not want to break anything. otherwise could be left on 3.0 for ever!

So now might be the time for a fresh upgrade to 3.0, I also may speak to Just Host about their old php version of 5.2.
the issue in the end, was check your plugins, have not gone bad! Which in this case revealed Tweet This 1.5.1 had gone bad, which could have been trigged by passing 950 posts.

Probably could have got to this quicker, if was not too obsessed with MySQL database performance, which I thought was the issue, coupled with broadband slowness issues, a busy weekend. But hat's off to you guys, for being around, and giving up your weekend. Tried to split the points up evenly, but I'm sure you guys know it's not about points! Pop into the VMware/Virtualisation zone sometime, I'll be glad to help you.

Credts and Thanks here....

http://andysworld.org.uk/2012/02/05/andysworld-is-back-and-fixed/

All the Best

Andy

PS until next time!
It's nice to know that even the super stars need help once in a while.  ;^)


Cd&
Thanks, Only Human, and always learning........!