> Hi Simon Hi, > You ask the question > "how often do you optimize/analyse the tables" > > I run dbmail-maintenance each night. > Is that what you mean by optimize the tables.
Not directly, (please someone correct me if I'm wrong) the dbmail-maintenance clears our old emails which are marked for delete. I was referring to the mysql optimize/analyze/repair syntax. Which is generally for MyISAM tables, shouldn't be needed for innodb tables. > If not can you give me the mysql commands and procedure to do this > optimize. http://dev.mysql.com/doc/mysql/en/ANALYZE_TABLE.html http://dev.mysql.com/doc/mysql/en/OPTIMIZE_TABLE.html Regards, Simon
