Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Wordpress Blog Andysworld! broke and very slow

Posted on 2012-02-04
44
Medium Priority
?
1,168 Views
Last Modified: 2012-02-17
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
0
Comment
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 27
  • 12
  • 3
  • +2
44 Comments
 
LVL 53

Assisted Solution

by:COBOLdinosaur
COBOLdinosaur earned 300 total points
ID: 37549382
Try running some of your queries directly against the db using phpmyadmin.  It may be that there is only one or two bottlenecks that need to be optimized and you avoid having to do a complete re-org of the db.


Cd&
0
 
LVL 70

Assisted Solution

by:Jason C. Levine
Jason C. Levine earned 1400 total points
ID: 37549404
A couple things to try:

1.  Turn debug mode on by following the instructions here:

http://codex.wordpress.org/Editing_wp-config.php#Debug

2.  Absolutely set up a local test site using Wamp or similar and see if things work locally

You say you can access ten admin panel.  Does it come up snappily or does it also take a long time?

900 posts is nothing for Wordpress.  You shouldn't be having issues with the db at this level.  The db could be corrupted, which is a whole different ball of wax
0
 
LVL 111

Assisted Solution

by:Ray Paseur
Ray Paseur earned 200 total points
ID: 37549406
Your host may have made "no changes" but that answer might not extend to "added workload."  Other sites hosted on the same machine or sharing the same data pipes may be slowing things down.  It's worth asking them about this.  On another note, their PHP installation is dangerously backlevel.  PHP 5.2 is no longer supported, not even for security fixes.
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
LVL 123
ID: 37549411
@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.
0
 
LVL 123
ID: 37549426
@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.
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 37549429
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 :)
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 37549433
Hmm,

Now it seems to be snapping right along again...
0
 
LVL 123
ID: 37549434
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.
0
 
LVL 70

Assisted Solution

by:Jason C. Levine
Jason C. Levine earned 1400 total points
ID: 37549442
It's also very high.  100 queries is a LOT

What happens if you disable some of the sidebar widgets like the category listing, archives and tag cloud?
0
 
LVL 123
ID: 37549443
@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.
0
 
LVL 53

Expert Comment

by:COBOLdinosaur
ID: 37549444
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&
0
 
LVL 123
ID: 37549449
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.
0
 
LVL 123
ID: 37549454
Flash based tag Widget code off.
0
 
LVL 70

Assisted Solution

by:Jason C. Levine
Jason C. Levine earned 1400 total points
ID: 37549459
Technically that's what Debug mode sort of does.  It will return some basic query information but at this point it sounds like you need this instead:

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

It will add info the footer about all the queries run and a bajillion other things that wordpress devs need.  Best used on a local testing site and not a live site though.

The other way to do it is to tell MySQL to log slow queries...but someone will have to talk Andy through that :)
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 37549463
Dump the cache and let it rebuild, too.
0
 
LVL 123
ID: 37549467
Will this plugin work on 2.7.1?
0
 
LVL 123
ID: 37549468
Dump the cache?
0
 
LVL 123
ID: 37549472
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.
0
 
LVL 70

Assisted Solution

by:Jason C. Levine
Jason C. Levine earned 1400 total points
ID: 37549480
>> Dump the cache?

Yes, if you are using a caching plugin you should have an option to force it to delete the cache and rebuild on the spot.

>> Will this plugin work on 2.7.1?

No clue.  2.7.1 is rather old.  You won't lose anything by trying.

Final test, and a simple one: switch to a new theme and see what happens.  Sometime the Loop is written inefficiently and causes multiple queries.
0
 
LVL 123
ID: 37549485
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.
0
 
LVL 70

Assisted Solution

by:Jason C. Levine
Jason C. Levine earned 1400 total points
ID: 37549493
Yeah, it's starting to sound like we'll need the info from Debug Objects to figure out which query has gone rogue.  IIRC, it has an "auto-explain" option in it somewhere which runs the queries with the EXPLAIN command.  That will be the most useful.
0
 
LVL 123
ID: 37549495
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.
0
 
LVL 123
ID: 37549500
I never get the Activate option for the Theme. (back in 60 mins)
0
 
LVL 4

Assisted Solution

by:kdebugs
kdebugs earned 100 total points
ID: 37549526
Hi hanc,

If it's of any help, I'm connecting to the blog (the title looks beautiful with all the bright colors, btw, but it does seem familiar) ;-) and response time is about 3 minutes to get something to show up after I click on one of the links on the right side to see a post.

I'm connected through verizon's fios from the NYC area.

Alex
0
 
LVL 123
ID: 37549531
@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?
0
 
LVL 123
ID: 37549539
I've removed the Archives and Categories Widgets, and they are still appearing, and no change to speed.
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 37549549
>> Archives and Categories Widgets, and they are still appearing

That's the cache in action....
0
 
LVL 123
ID: 37549550
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.
0
 
LVL 123
ID: 37549552
>> Archives and Categories Widgets, and they are still appearing

That's the cache in action....

Cache is Cleared!!!
0
 
LVL 123
ID: 37549557
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
0
 
LVL 123
ID: 37549562
just clicked a recent item to see if it appears.....
0
 
LVL 123
ID: 37549569
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)
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 37549627
Were you able to get debug objects installed?
0
 
LVL 123
ID: 37549636
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.
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 37549647
Okay.  You can try that.

Do you have the ability to work at the mysql command line with this hosting?
0
 
LVL 123
ID: 37549660
Unfortunately, no console access, only phpmyadmin.
0
 
LVL 123
ID: 37549665
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.
0
 
LVL 123
ID: 37551357
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!
0
 
LVL 123

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 0 total points
ID: 37551461
and the answer is or was:-

The Plugin "Tweet This"! I''m running version 1.5.1


Adds a “Tweet This Post” link to every post and page. Shortens URLs in advance through Th8.us (19 characters). Customize under Settings > Tweet This. By Richard X. Thripp.

there is new version 1.8, but I do not like upgrading for the sake of upgrading, and not being able to upgrade to 3.3.1 of Wordpress because if the php on the host, and most plugins are now designed for 3.3.1...

Stange how a plugin went bad. I'm going to leave for a few days....

I got an email back from the host with Standard WP Tips!

5. keep your wordpress install up to date.
and see if there is a way to make them faster. Any way in which you can make them stop creating database queries and use flat files, or even better, cache things will help out greatly. If you find that a particular plugin is slowing down your wordpress install you should uninstall the plugin and consult the author. Most plugin developers love to hear feedback and would greatly appreciate your help.


Difficult when their PHP is on 5.2!

So many thanks for your help guys, and using you all as a sounding board! Pop into my Zone anytime!!!
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 37551640
You should be able to get to 3.0 on PHP 5.2...
0
 
LVL 123
ID: 37551650
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.
0
 
LVL 123

Author Closing Comment

by:Andrew Hancock (VMware vExpert / EE MVE^2)
ID: 37589099
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!
0
 
LVL 53

Expert Comment

by:COBOLdinosaur
ID: 37591197
It's nice to know that even the super stars need help once in a while.  ;^)


Cd&
0
 
LVL 123
ID: 37608903
Thanks, Only Human, and always learning........!
0

Featured Post

Simplify Your Workload with One Tool

How do you combat today’s intelligent hacker while managing multiple domains and platforms? By simplifying your workload with one tool. With Lunarpages hosting through Plesk Onyx, you can:

Automate SSL generation and installation with two clicks
Experience total server control

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article discusses how to implement server side field validation and display customized error messages to the client.
Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
The viewer will learn how to dynamically set the form action using jQuery.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question