For the overhead i can't tell you anything, probably you will have something in the mysql manual. About the locking i supose that your users will be able to select from the table, but wont be able to do updates, etc.. while the optimization ocurrs. The database will probably put those instruction on hold till the optimization ends, só you probably wont even have to care with that. But the optimization is an expensive operation (consume many resources), so the best it to do it in a time when the operations on the database are minimal or none. PhpmyAdmin or any other php script can be scheduled, they only execute when a client request the page. But you can schedule a job in you operative system to do that cron / at for *nix/linux, windows also have schedule managers. Hope it helps. Ricardo Lopes ----- Original Message ----- From: "Ng Hwee Hwee" <hhwee@xxxxxxxxxxx> To: "DBList" <php-db@xxxxxxxxxxxxx> Sent: Friday, February 13, 2004 2:04 AM Subject: Optimize Table 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
