Optimize Your Tables
A system level plugin for Joomla v1.7, v2.5 and now v3.x that once a day optimizes your database's tables so as to keep your site running at its peek performance by getting rid of the MySQL database overhead.
This has only been tested on Joomla v1.7 and up.
v1.0: Initial Release.
v1.1: Bug fix - thanks to Ebo Eppenga
v1.2: tested on Joomla 3.0, 3.1 and 3.2
Optimize Your Tables is only guaranteed to work on PHP up to v5.4.x, there have been a few reports and confirmed tests on my hosting environment that it will not work in PHP 5.5.x due to MYSQL_QUERY extension having been deprecated in PHP 5.5.x.
I'm looking for a way to update that to work for PHP 5.5.x - 7.0.
P.S.: If you are going to rate the plugin, please comment or contact me [email@example.com] if you're having issues with it. [Someone rated it 1 out of 5 without any comments/review and without getting in contact with me so I couldn't help them :( ].
Credit: This is based on work by Joomlaportal.ru and their Joomla v1.5 plugin which they no longer maintain.