Re: Optimization of all mysql databases on a server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Tijnema ! wrote:
> On 3/26/07, Chris <dmagick@xxxxxxxxx> wrote:
>> itoctopus wrote:
>> > The purpose of this script is to optimize all associated tables in all
>> > databases on a mysql server. This script is working great, you can
>> put in a
>> > CRON and run it every day. Feel free to throw in your 2 cents!
>>
>> It's going to time out if you have any large databases or tables.

php will not timeout on the commandline unless you actually specify
a timeout - unlike php as used as a webserver SAPI.

> 
> What about set_time_limit(999999)??

RTFM: set_time_limit(0);

although it's not needed.

> 
>>
>> Also a much easier option is to run
>>
>> mysqlcheck -o ...

indeed - use the right tool for the job.

> 
> That's true :)
> 
> Tijnema
>>
>> -- 
>> Postgresql & php tutorials
>> http://www.designmagick.com/
>>
>> -- 
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux