Optimize Table
| From: | Ng Hwee Hwee | Date: | Fri, 13 Feb 2004 02:04:25 +0000 |
| Subject: | Optimize Table | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-32924@lists.php.net to get a copy of this message | ||
Hi all
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!
kind regards,
hwee