Re: Lost Connection each hour :(

2008-01-17 Thread Matthias Witte
On Tue, Jan 15, 2008 at 09:27:10PM +0100, MAS! wrote: Can anyone help me to understand why my site (php 4.4.2 / ubuntu dapper) loose all connections to mysql server when /etc/cron/hourly starts? (there are no process to start hourly, the directory is empty) Is the assumption correct, that

Re: Lost Connection each hour :(

2008-01-16 Thread MAS!
Il giorno 16 gen 2008, alle ore 02:59, Moon's Father ha scritto: Post your error message here. (from php) Error message: mysql_connect(): Lost connection to MySQL server during query and I have that for _each_ apache2 thread/php-page opened MAS! -- MySQL General Mailing List For list

Re: Lost Connection each hour :(

2008-01-16 Thread Moon's Father
Enter your mysql shell and enter the command: set global max_allowed_packet=10M The value of the variable can be set whatever you want . On Jan 16, 2008 4:36 PM, MAS! [EMAIL PROTECTED] wrote: Il giorno 16 gen 2008, alle ore 02:59, Moon's Father ha scritto: Post your error message here.

Re: Lost Connection each hour :(

2008-01-16 Thread MAS!
Enter your mysql shell and enter the command: set global max_allowed_packet=10M I have it setted at 32M, but that is not the problem; the data are not too much ... and it's strange because _ALL_ clients seems to died/be disconnected each hour, when the hourly cron runs.. -- MySQL

Re: Lost Connection each hour :(

2008-01-16 Thread Moon's Father
You should give me an error message here. On Jan 16, 2008 4:44 PM, MAS! [EMAIL PROTECTED] wrote: Enter your mysql shell and enter the command: set global max_allowed_packet=10M I have it setted at 32M, but that is not the problem; the data are not too much ... and it's strange because

Re: Lost Connection each hour :(

2008-01-16 Thread Dušan Pavlica
Marco, can you post values of wait_timeout and interactive_timeout variables. You can get them from SHOW VARIABLES output. If they are set to 3600 (1 hour in secs), set them to something bigger like one week and then you will see if it helps or not. You can read more about those timeouts also

Re: Lost Connection each hour :(

2008-01-16 Thread MAS!
can you post values of wait_timeout and interactive_timeout variables. You can get them from SHOW VARIABLES output. If they are set to 3600 (1 hour in secs), set them to something bigger like one week and then you will see if it helps or not. You can read more about

Re: Lost Connection each hour :(

2008-01-16 Thread Dušan Pavlica
MAS! napsal(a): can you post values of wait_timeout and interactive_timeout variables. You can get them from SHOW VARIABLES output. If they are set to 3600 (1 hour in secs), set them to something bigger like one week and then you will see if it helps or not. You can read more about

Re: Lost Connection each hour :(

2008-01-16 Thread Baron Schwartz
Hi, On Jan 16, 2008 3:36 AM, MAS! [EMAIL PROTECTED] wrote: Il giorno 16 gen 2008, alle ore 02:59, Moon's Father ha scritto: Post your error message here. (from php) Error message: mysql_connect(): Lost connection to MySQL server during query and I have that for _each_ apache2

Lost Connection each hour :(

2008-01-15 Thread MAS!
Can anyone help me to understand why my site (php 4.4.2 / ubuntu dapper) loose all connections to mysql server when /etc/cron/hourly starts? (there are no process to start hourly, the directory is empty) I have heavvy web/apache2 traffic on my site and that is not so nice for my users..

Re: Lost Connection each hour :(

2008-01-15 Thread Moon's Father
Post your error message here. On Jan 16, 2008 4:27 AM, MAS! [EMAIL PROTECTED] wrote: Can anyone help me to understand why my site (php 4.4.2 / ubuntu dapper) loose all connections to mysql server when /etc/cron/hourly starts? (there are no process to start hourly, the directory is empty) I