Optimize a WordPress Database

Make sure you have a backup before ever doing anything with your database (In phpMyAdmin, use the "Export" tab and export whole database sql). ## MySQL "Optimize" is a Free Speed Boost MySQL has a built-in optimize function to clean up wasted space in your tables. It’s particularly effective when you’ve deleted a lot of data (With blogs, that mostly means comments). The best part though is that it’s simple to do. In phpMyAdmin, just select the table, go to the "Operations" tab, and then click "Optimize Table." Or if you’d rather run it manually, the syntax is: [sourcecode language="plain"] OPTIMIZE TABLE 'wp_comments' [/sourcecode] ## Delete All Post Revisions Post revisions (Where WordPress automatically keeps a history of all changes to your posts) are considered a nuisance by many people,…
Read More