This plugin allows for automated scheduled database optimization. The user can specify (in days) how long in between automated optimizations.
Ever wished that you could take some measure to speed up your WordPress site? Have you created and deleted a lot of posts as well as experimented with plugins? All these deleted entries leave overhead on the database that should be routinely cleared out. This plugin allows you to have your WordPress tables to be optimized on a schedule. It uses the WordPress Database Class to do the work, and you can set the number of days in between optimizations.