Marion Dorsett

The WordPress Database Table Optimizer plugin will automatically make sure that your WordPress MySQL database tables are always optimized.
I’ve also included an admin page located at Manage > Optimize Database. This page will allow you to confirm your WordPress MySQL database tables are optimized, show you the number of rows per table, and the size of the table.
<h3>Arbitrary section</h3>
This plugin uses Aidan Lister size_readable PHP function to show the file sizes of the MySQL tables. I’ve changed the name of the function to avoid naming conflicts with other plugins that may be using this function as well.
http://aidanlister.com/repos/v/function.size_readable.php
Special thanks to David Potter (http://dpotter.net/Technical/) for catching my oversight.
http://www.figmentthinking.com/wordpress-database-table-optimizer/#comment-74

Figment Thinking WordPress Database Table Optimizer

The WordPress Database Table Optimizer plugin will automatically make sure that your WordPress MySQL database…

mohamad wael

Kt-cleanpress is a plugin designed to clean and optimize WordPress. It will give you the following options:
<ol>
<li>
Clean Posts: which will let you remove all posts marked as Trash / Pending / Draft with all their related contents from the database, and then it will defragment it.
</li>
<li>
Clean Pages: will do the same things described in Clean Posts, but it will process the pages.
</li>
<li>
Clean Comments: will do the same things described in Clean Posts, but it will process the Spam / Unapproved / Trash Comments.
</li>
<li>
Clean Post Revisions: Whenever a post is edited and saved WordPress automatically creates a backup to which one can revert. This option will remove all posts backups.
</li>
<li>
Clean Auto Draft: This is a left over from the process of creating a new WordPress page or post and not saving it as a draft of publishing it.
</li>
<li>
Clean Other Left Overs: Will remove navigation menus that are created but not saved, and all their related data, and will also remove unneeded lock and last entries in the database.
</li>
<li>
Clean Empty Categories / Tags: Will delete all categories/Tags that do not have any post or link associated with them but will not remove the default WordPress categories.
</li>
<li>
Optimize The Tables: Reclaim unused space and defragment the data file.
</li>
</ol>

Figment Thinking WordPress Database Table Optimizer vs KT-CleanPress