' Alrighty sparky! ' ...My favorite wordpress line of all time. But trust me, nothing is sparky at the moment cause my blog at www.nokiasymbianthemes.com is eating up insane amount of Cpu resource, making me get suspended with hosts after hosts. The latest host www.marvservices.com is someone from Dp who's username is Everythinghost here. Right now, my cpu resource is ticking over 8% to 10% and I'm confused exactly why. Yes, I do use a lotta plugins but really that shouldn't be the case of the extremity. The mysql file is only 565Kb (2.7mb when unzipped) when zipped and I find it extremely odd that so much resource can be needed for such a small database. I want to use the wp-cache plugin but for some reason that shows error. I tried to google the error but nothing fruitful came out. So my dear friends and foes of D with a slick little p.... Tell me, should I click optimize database, or repair database? Will that solve it? What exactly can I do to solve my issue of wp cache (considering that decreases load)? I usually receive around 2500 uniques a day if that matters. I feel helpless at the moment cause vps wont solve my issue (at least with my budget). Though with my last host everything was going smooth but because of a stupid copyright issue from my part made me change host. What exactly can I do with this database issue... Anyone.. Anywhere.. Mayday.. Mayday.. *sighs*
Are you sure this is a database issue? To find out the issue, first disable all the plugins and check the cpu status. If it is normal then start enabling plugins one by one, this might help you to find the culprit plugin
Thats a good idea.. However, the plugins I'm using are almost all lightweight it should be a database issue. I think something with the tables not working right. But then again, I'm not a sql techie by any means. I.ll do that.. I might bug ya with a pm or two tomorrow. Don't whack me lol.
Do you use wp-cache on your blog? You can decrease cpu use with this mod. I advise... If you already use, then you may fix your you sql by cpanel or by hosting etc...
I dont use a wpcache plugin yet, but I am planning to use one... once I installed it and the whole mysql usage jumped UP rather than coming down...
How many actual page views do you get per day? Optimize is used generally when you delete a huge block of data from a table. It probably won't have much effect unless you have a table that auto increments but often has records deleted from it. Use the Analyze Table query to see if a table needs repair. It should show you any errors and warnings with a specific table. I would definitely be suspect of the plugins. It's possible that they are coded in a way that eats up server resources.
I get around and at least 12,000 page views everyday... how do you use the analyze table thingy? Newbie in phpsql stuff
In a sql prompt phpmyadmin, shell, etc. run: ANALYZE TABLE your_table_name; This should tell you if there are any issues with a particular table.