What to do to keep MySQL databases running in peak performance?
I have a MySQL database that is continually growing. 

Every once in a while I OPTIMIZE all the tables. Would this be the sort of thing I should put a on a cron job daily or weekly? 

Are there any specific tasks I could set to run automatically that keeps the database in top performance?

Thanks

Ben
What to do to keep MySQL databases running in peak performance?
===

I have a MySQL database that is continually growing. 

Every once in a while I OPTIMIZE all the tables. Would this be the sort of thing I should put a on a cron job daily or weekly? 

Are there any specific tasks I could set to run automatically that keeps the database in top performance?

Thanks

Ben