Optimise MySQL Database

Like any other database, over time the MySQL database that powers your blog can get a bit rough around the edges and would benefit from a spring clean. The graph below shows the improvement WeblogToolsCollection obtained from optimising their databases:

Optimising MySQL database’s is a doddle if you have access to PHPMyAdmin (it’s a good idea to backup your databases before you do this!):

• Click on the database your blog uses
• Click the ‘check all’ box at the bottom to select all tables
• Then click on the ‘Optimize table’ option in the drop-down box also at the bottom

If you have any more speed tips then please share them below. An obvious one is to uninstall plugins, but I’m not keen on this as I think it defeats the whole point of using an opensource blogging tool like WordPress. Agreed, some plugins may be written badly and end up being resource hogs, but I think that’s where WordPress is great as the community works together to make the overall product better. There’s nothing better than having 100K or so active and passionate users helping with product development!

Hope you found this tips useful. If you did, don’t forget to share them with other users using the icons below.

Continue Reading This Post:12

Subscribe To RSS Feed Updates (What is RSS??)

Bookmark & Share

Related Posts

• Ultimate Wordpress Site Speed - Install WP-Cache2 AND APC At The Same Time
• How To Fix WP-Cache And Spam Karma 2 (SK2) Issues
• WordPress Plugin Overload!
• I Need Wordpress MySQL Help, And I’m Willing To Pay
• WordPress Optimisation: Control When Plugins Are Loaded
• Wordpress Plugins NOT To Install
• My First Week With WordPress: 10 Plugins That I Can’t Live Without