Re: MySQL give up on a query after a certain length of time

2005-05-24 Thread Jacob Friis Larsen
> Check if problem remains with official binaries. I will. My schedule won't allow it right now, but I will get to it soon. Thanks, Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL give up on a query after a certain length of time

2005-05-24 Thread Gleb Paharenko
Hello. Check if problem remains with official binaries. Jacob Friis Larsen <[EMAIL PROTECTED]> wrote: > > I use those from Debian: > http://packages.debian.org/testing/misc/mysql-server-4.1 > > Thanks, > Jacob > -- For technical support contracts, goto https://order.mysql.com/

Re: MySQL give up on a query after a certain length of time

2005-05-23 Thread Jacob Friis Larsen
> Normally such different behavior for same queries is > weird. Do you use an official binaries or from Debian? I use those from Debian: http://packages.debian.org/testing/misc/mysql-server-4.1 Thanks, Jacob > Jacob Friis Larsen <[EMAIL PROTECTED]> wrote: > > >> Check with SHOW PROCESSLIST in w

Re: MySQL give up on a query after a certain length of time

2005-05-23 Thread Gleb Paharenko
Hello. Normally such different behavior for same queries is weird. Do you use an official binaries or from Debian? Jacob Friis Larsen <[EMAIL PROTECTED]> wrote: >> Check with SHOW PROCESSLIST in what state your query hangs. > > It hangs while sending data. I only ask for 7 rows, and

Re: MySQL give up on a query after a certain length of time

2005-05-23 Thread Jacob Friis Larsen
> Variables are net_read_timeout and net_write_timeout : I don't think I can use net_read_timeout to timeout a query. "Net Read Timeout: The time required in seconds to wait for more data from a connection before aborting the read." Jacob -- MySQL General Mailing List For list archives: http://l

Re: MySQL give up on a query after a certain length of time

2005-05-23 Thread mfatene
Hi, forget previous email, Variables are net_read_timeout and net_write_timeout : mysql> show variables like '%timeout'; +--+---+ | Variable_name| Value | +--+---+ | connect_timeout | 5 | | delayed_insert_timeout |

Re: MySQL give up on a query after a certain length of time

2005-05-23 Thread mfatene
Hi, in the conf one use minus "-", in the command line it's generally underscore "_". the variables should be network_timeout Mathias Selon Jacob Friis Larsen <[EMAIL PROTECTED]>: > On 5/20/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > There is a variable called --network-timeout ! You c

Re: MySQL give up on a query after a certain length of time

2005-05-22 Thread Jacob Friis Larsen
On 5/20/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > There is a variable called --network-timeout ! You can set it to 300 (5 > minutes, etc.). SET SESSION network-timeout=120; ERROR 1193 (HY000): Unknown system variable 'network' How should I use network-timeout? Thanks, Jacob -- MySQL G

Re: MySQL give up on a query after a certain length of time

2005-05-21 Thread Jacob Friis Larsen
On 5/20/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > There is a variable called --network-timeout ! You can set it to 300 (5 > minutes, etc.). Don't you mean net_read_timeout? http://dev.mysql.com/doc/mysql/en/dynamic-system-variables.html SET SESSION net_read_timeout = 300; Thanks, Jacob

Re: MySQL give up on a query after a certain length of time

2005-05-20 Thread TheRefUmp
"Gleb Paharenko" <[EMAIL PROTECTED]> >To: >Sent: Friday, May 20, 2005 12:45 PM >Subject: Re: MySQL give up on a query after a certain length of time > > >> Hello. >> >> I don't remember such way (except your transaction could abort due to >> l

Re: MySQL give up on a query after a certain length of time

2005-05-20 Thread Tony Yau
Hi Guys, you can always set a max time out for your php script (php.ini) Tony - Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: Sent: Friday, May 20, 2005 12:45 PM Subject: Re: MySQL give up on a query after a certain length of time > Hello. &

Re: MySQL give up on a query after a certain length of time

2005-05-20 Thread Jacob Friis Larsen
> Check with SHOW PROCESSLIST in what state your query hangs. It hangs while sending data. I only ask for 7 rows, and normally this goes very fast. Have a nice weekend. Thanks, Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.my

Re: MySQL give up on a query after a certain length of time

2005-05-20 Thread Gleb Paharenko
Hello. I don't remember such way (except your transaction could abort due to lock timeout). Check with SHOW PROCESSLIST in what state your query hangs. Jacob Friis Larsen <[EMAIL PROTECTED]> wrote: > Hello. > > Is there a way to have MySQL give up on a query after a certain length o