sorry i have a great error in my last post, when i say: PhpmyAdmin or any other php script can be scheduled, i mean: PhpmyAdmin or any other php script _CAN_ _NOT_ be scheduled, it happends. ----- Original Message ----- From: "Ricardo Lopes" <lopes@xxxxxxxxxxxxxxx> To: "Ng Hwee Hwee" <hhwee@xxxxxxxxxxx> Cc: "PHP DB" <php-db@xxxxxxxxxxxxx> Sent: Friday, February 13, 2004 10:30 AM Subject: Re: Optimize Table > 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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
