All the MySQL tables have the be optimized once in a while. Ideally, once a week perhaps. You can do that by either going to your phpMyAdmin or, if you’re a badass command line user, run the following command…
If your MySQL databases uses MyISAM instead of InnoDB you should turn the last one Off. It should free memory and optimize your MySQL performance.
Select random rows from a database base with MySQL
Following yesterday’s post about Turning Off Post Revisions today I’m going to show you how to delete those revisions from the data base.