Re: Optimization of all mysql databases on a server
| From: | Tijnema ! | Date: | Mon, 26 Mar 2007 07:38:53 +0000 |
| Subject: | Re: Optimization of all mysql databases on a server | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-251353@lists.php.net to get a copy of this message | ||
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.What about set_time_limit(999999)??
Also a much easier option is to run mysqlcheck -o ...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