What the hell does that mean? Googling “speeding up WordPress”, I see people saying things like “Well, if you’ve already optimized your tables, then try this…” After a bit more searching I finally figured it out. Here is a step by step procedure to optimize your WordPress installation through your website control panel. If your control panel is different, or you don’t have one, then you are S.O.L. until someone comments an easier way to do this. BTW, I take no responsibility for you messing up your blog either. As every how-to article says, back up your WordPress installation before trying this. (Like you’d even know how to reinstall WordPress from that backup.)
1. In your website control panel, probably in the database section, you should see an icon for phpMyAdmin. Click it.- 2. Once it opens, in the left sidebar you will see a list of databases, one for each WordPress installation. Click on the one you want to optimize.
- The database will open showing all the tables included under WordPress. Don’t worry, it scares me too. Under all those tables there should be a single link saying ” Check All / Uncheck All / Check tables having overhead”. Click on “Check tables having overhead”.
- If no check boxes get checked, you are finished; close your browser. More likely, you do have one or two boxes above now checked. Next to where you just clicked, there will be a drop down menu that says “With selected:”. Choose “Optimize tables”.
- That’s it, you are done. On the following screen you should see a little box saying your table name, status OK.
My website seemed to load faster considering I had never done this before. For good measure, I tried the above procedure on 3 more blogs. Everything went fine. It seems pretty safe as long as you don’t play around with anything else.
Like to live dangerously? Then I recommend the following plugin. Clean Options, which claims to find orphaned options and allow for their removal from the wp_options table. Translated, that means it goes through your plugins, and deletes any crap left over from stuff you removed long ago. Use it before optimizing so you don’t have to do that twice. Be careful with this plugin. Do not delete everything it finds. Only delete what you recognize as something you deleted from the plugins folder. Just deactivating a plugin and leaving it in the folder doesn’t get rid of it. If you mess up and a plugin stops working properly, you will have to deactivate that plugin, and then reactivate it.
|
|
|
|
|
|







11 users commented in " Optimize Your Tables "
Follow-up comment rss or Leave a Trackback **********And one another tip I put on my to-do list. It just scares me that list gets incredibly long whenever I visited your blog… LOL
~Marcus
Now I also know how to optimize tables. I followed your steps to the letter (experience has taught me not to play around in the database) and it worked without any problems. Everyone says table optimization speeds up WordPress but I will still have to see, my blog is still so new the database is not really big yet.
Thanks for this Turnip. I always forget about doing the small things that can do wonders.
I did it as soon as i read your post. Thanks Turnip.
I’m happy to see no disaster reports. Let’s see if Mike (saphrym) ruins the streak.
Thanks for the IZEA comment. The widget is not working for me either it seems… works fine on the site, though.
I’m probably a bit too gullible and ready to jump on anything that looks interesting, but I would really like to see another ranking system than PR out there. Maybe PPP is the culprit, I don’t know, but to slap every little guy who makes 200 per month doing reviews seems unnecessary and slightly ridiculous.
Anyway - down comes the widget - can’t have something that’s not working - and a slight rewrite of the post might be in order too…
[...] and cleaning his tables. At least that’s what I think his post was about. Actually, Optimize Your Tables was an article about using phpMyAdmin to optimize your WordPress installaion through your website [...]
You have been added to the “Big Bang” master list at #468. When I went to your “Big Bang” post there was no content. Can you see what happened and re-post. Please let me know when you have re-posted. Don’t forget to copy/paste the complete list back to your site frequently. Doing this assures maximum link benefit for everyone who joins.
http://mondaymorningpower.blogspot.com/2008/01/big-bang-master-list.html
Thanks for playing. If possible, try to get others to play also. It will benefit everyone.
@Turnip:
I always wanted to optimize my site so it loads faster and better.
So basically I only need to first “Check tables having overhead” to locate any tables with overhead, then optimize those tables?
Sounds easy and risk free enough to me!
Should I try this out now, or wait until I get back to the city when I have a better internet connection?
I am connected to the Cyberspace via a dial up connection at the moment. -_-
Deimos, I’d be more afraid of my password being stolen than messing up my blog. I only use my passwords from home.
Thanks for that. THe clean options plugin seems pretty cool.
Leave A Reply