sorry, what do you mean by _cron_ job? I'm hoping to optimise my tables, for example on, every Monday 9.30am. by the way, is there a problem if I optimise my tables too frequently? i mean, i was told not to defragment or format my harddisk too often cos it will cause wear and tear to the hardware.. does this apply to optimisation of tables? will this be bad for my server then? thank you so much. ----- Original Message ----- From: "Dynamix" <info@xxxxxxxxxxxxxx> To: "Ng Hwee Hwee" <hhwee@xxxxxxxxxxx>; "DBList" <php-db@xxxxxxxxxxxxx> Sent: Monday, May 03, 2004 4:29 PM Subject: Re: Optimize Tables > yep, check http://www.phpclasses.org/browse/package/1527.html > > And you can run this using a cron job, so it just fit with your needs. > > Regards, > Hatem > > ----- Original Message ----- > From: "Ng Hwee Hwee" <hhwee@xxxxxxxxxxx> > To: "DBList" <php-db@xxxxxxxxxxxxx> > Sent: Monday, May 03, 2004 11:19 AM > Subject: Optimize Tables > > > Hi, > > Is there a way to create a schedule to optimise my MySQL tables > automatically? The overhead of some of my tables can reach 355,548 bytes > over 3 working days! > > Please help me! > > Thanks. > 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
