I read that it is neccessary and good to optimize my DB tables frequently.. I am using
phpMyAdmin-2.5.4 to maintain my database and the program showed me that my overhead
for some tables is over 5000. Can i know when would be good for me to optimise my
tables? For example, once I have an overhead of 1000, I should optimise my tables?
Another of my concern is that, when I optimise tables, I read that my tables will be
locked. Does it mean that my customers cannot do a select statement on the table? In
this case, can I schedule phpMyAdmin to optimise the table at a certain time, say 3am
when there is very little traffic??
Thank you so much!