Re: [PHP] Optimization of all mysql databases on a server

2007-03-27 Thread itoctopus
You're right, it was running from a browser, you need to use set_time_limit. -- itoctopus - http://www.itoctopus.com "Chris" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Jochem Maas wrote: > > Tijnema ! wrote: > >> On 3/26/07, Chris <[EMAIL PROTECTED]> wrote: > >>> itoctopus wrote

Re: [PHP] Optimization of all mysql databases on a server

2007-03-27 Thread Chris
Jochem Maas wrote: Tijnema ! wrote: On 3/26/07, Chris <[EMAIL PROTECTED]> 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 i

Re: [PHP] Optimization of all mysql databases on a server

2007-03-27 Thread itoctopus
Agreed that mysqlcheck is much more efficient... As for the timeout thing, I rememeber we were once using wget to run php scripts (which was not the correct way). Anyway, we had a script that was repeating every 15 minutes, and eventually we discovered that by default wget has a timeout of 15 minut

Re: [PHP] Optimization of all mysql databases on a server

2007-03-27 Thread Jochem Maas
Tijnema ! wrote: > On 3/26/07, Chris <[EMAIL PROTECTED]> 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 y

Re: [PHP] Optimization of all mysql databases on a server

2007-03-25 Thread Tijnema !
On 3/26/07, Chris <[EMAIL PROTECTED]> 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

Re: [PHP] Optimization of all mysql databases on a server

2007-03-25 Thread Chris
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. A