Hi, I think it might be beneficial to add to the cron, the option of an automatic optimise query, to help keep the SQL in good shape. Many forum admins neglect this wonderful feature to essentially "defragment" the overhead on the SQL table.
Optimize should only be run if you delete a lot of information from your database. It is doubtful that running it on a regular basis will provide any benefit and you should definitely not run it during page loads.
Agreed. But it might be nice to provide an *option* for it (as the OP mentioned) in the Maintenance section, but it would certainly have to be carefully labeled regarding the potential issues. Not a critical first release issue as it's an easy add later, but time permitting it's potentially useful for some.
Personally I'd just use Navicat to go in and work with the DB directly .