Re: Optimization of all mysql databases on a server

From:	Chris	Date:	Wed, 28 Mar 2007 00:40:09 +0000
Subject:	Re: Optimization of all mysql databases on a server
References:	1 2 3 4	Groups:	php.general
Request:	Send a blank email to php-general+get-251501@lists.php.net to get a copy of this message

Jochem Maas wrote:

Tijnema ! wrote:
On 3/26/07, Chris <dmagick@gmail.com> 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.

Considering the amount of html in the script I guessed (maybe incorrectly) it was for running from a browser - which is why I mentioned about the timeout issue. A command line script isn't going to have <br/>'s or tables or anything (well, none that I've written recently do). -- Postgresql & php tutorials http://www.designmagick.com/