Re: [PHP] mysql_query blocking

2009-06-28 Thread Tom Worster
On 6/27/09 7:09 PM, "Daniel Kolbo" wrote: > Tom Worster wrote: >> On 6/27/09 3:15 PM, "Daniel Kolbo" wrote: >> >>> When a MySQL table is locked a php call of mysql_query() that requires >>> that table will hang as the request blocks at the MySQL server until the >>> table is unlocked. Is there

Re: [PHP] mysql_query blocking

2009-06-28 Thread Lester Caine
Daniel Kolbo wrote: Hello, When a MySQL table is locked a php call of mysql_query() that requires that table will hang as the request blocks at the MySQL server until the table is unlocked. Is there a way to stop a mysql_query from hanging (by setting a time limit)? Daniel I can understand yo

Re: [PHP] mysql_query blocking

2009-06-27 Thread Phpster
On Jun 27, 2009, at 7:17 PM, Daniel Kolbo wrote: Phpster wrote: Bastien Sent from my iPod On Jun 27, 2009, at 4:13 PM, Daniel Kolbo wrote: Ashley Sheridan wrote: On Sat, 2009-06-27 at 16:03 -0400, Daniel Kolbo wrote: Ashley Sheridan wrote: On Sat, 2009-06-27 at 15:15 -0400, Daniel

Re: [PHP] mysql_query blocking

2009-06-27 Thread Daniel Kolbo
Phpster wrote: > > > Bastien > > Sent from my iPod > > On Jun 27, 2009, at 4:13 PM, Daniel Kolbo wrote: > >> Ashley Sheridan wrote: >>> On Sat, 2009-06-27 at 16:03 -0400, Daniel Kolbo wrote: Ashley Sheridan wrote: > On Sat, 2009-06-27 at 15:15 -0400, Daniel Kolbo wrote: >> Hello,

Re: [PHP] mysql_query blocking

2009-06-27 Thread Daniel Kolbo
Bastien Koert wrote: > Why issue/do a lock at all? Shouldn't need a large lock at read > > bastien > > On Saturday, June 27, 2009, Daniel Kolbo wrote: >> Ashley Sheridan wrote: >>> On Sat, 2009-06-27 at 16:03 -0400, Daniel Kolbo wrote: Ashley Sheridan wrote: > On Sat, 2009-06-27 at 15:1

Re: [PHP] mysql_query blocking

2009-06-27 Thread Daniel Kolbo
Tom Worster wrote: > On 6/27/09 3:15 PM, "Daniel Kolbo" wrote: > >> When a MySQL table is locked a php call of mysql_query() that requires >> that table will hang as the request blocks at the MySQL server until the >> table is unlocked. Is there a way to stop a mysql_query from hanging >> (by se

Re: [PHP] mysql_query blocking

2009-06-27 Thread Phpster
Bastien Sent from my iPod On Jun 27, 2009, at 4:13 PM, Daniel Kolbo wrote: Ashley Sheridan wrote: On Sat, 2009-06-27 at 16:03 -0400, Daniel Kolbo wrote: Ashley Sheridan wrote: On Sat, 2009-06-27 at 15:15 -0400, Daniel Kolbo wrote: Hello, When a MySQL table is locked a php call of mysql

Re: [PHP] mysql_query blocking

2009-06-27 Thread Bastien Koert
On Saturday, June 27, 2009, Bastien Koert wrote: > Why issue/do a lock at all? Shouldn't need a large lock at read > > bastien > > On Saturday, June 27, 2009, Daniel Kolbo wrote >> Ashley Sheridan wrote: >>> On Sat, 2009-06-27 at 16:03 -0400, Daniel Kolbo wrote: Ashley Sheridan wrote: >>

Re: [PHP] mysql_query blocking

2009-06-27 Thread Bastien Koert
Why issue/do a lock at all? Shouldn't need a large lock at read bastien On Saturday, June 27, 2009, Daniel Kolbo wrote: > Ashley Sheridan wrote: >> On Sat, 2009-06-27 at 16:03 -0400, Daniel Kolbo wrote: >>> Ashley Sheridan wrote: On Sat, 2009-06-27 at 15:15 -0400, Daniel Kolbo wrote: >

Re: [PHP] mysql_query blocking

2009-06-27 Thread Tom Worster
On 6/27/09 3:15 PM, "Daniel Kolbo" wrote: > When a MySQL table is locked a php call of mysql_query() that requires > that table will hang as the request blocks at the MySQL server until the > table is unlocked. Is there a way to stop a mysql_query from hanging > (by setting a time limit)? would

Re: [PHP] mysql_query blocking

2009-06-27 Thread Daniel Kolbo
Ashley Sheridan wrote: > On Sat, 2009-06-27 at 16:03 -0400, Daniel Kolbo wrote: >> Ashley Sheridan wrote: >>> On Sat, 2009-06-27 at 15:15 -0400, Daniel Kolbo wrote: Hello, When a MySQL table is locked a php call of mysql_query() that requires that table will hang as the request

Re: [PHP] mysql_query blocking

2009-06-27 Thread Ashley Sheridan
On Sat, 2009-06-27 at 16:03 -0400, Daniel Kolbo wrote: > Ashley Sheridan wrote: > > On Sat, 2009-06-27 at 15:15 -0400, Daniel Kolbo wrote: > >> Hello, > >> > >> When a MySQL table is locked a php call of mysql_query() that requires > >> that table will hang as the request blocks at the MySQL server

Re: [PHP] mysql_query blocking

2009-06-27 Thread Daniel Kolbo
Ashley Sheridan wrote: > On Sat, 2009-06-27 at 15:15 -0400, Daniel Kolbo wrote: >> Hello, >> >> When a MySQL table is locked a php call of mysql_query() that requires >> that table will hang as the request blocks at the MySQL server until the >> table is unlocked. Is there a way to stop a mysql_qu

Re: [PHP] mysql_query blocking

2009-06-27 Thread Daniel Kolbo
Daniel Kolbo wrote: > Hello, > > When a MySQL table is locked a php call of mysql_query() that requires > that table will hang as the request blocks at the MySQL server until the > table is unlocked. Is there a way to stop a mysql_query from hanging > (by setting a time limit)? > > The php.ini

Re: [PHP] mysql_query blocking

2009-06-27 Thread Ashley Sheridan
On Sat, 2009-06-27 at 15:15 -0400, Daniel Kolbo wrote: > Hello, > > When a MySQL table is locked a php call of mysql_query() that requires > that table will hang as the request blocks at the MySQL server until the > table is unlocked. Is there a way to stop a mysql_query from hanging > (by settin

[PHP] mysql_query blocking

2009-06-27 Thread Daniel Kolbo
Hello, When a MySQL table is locked a php call of mysql_query() that requires that table will hang as the request blocks at the MySQL server until the table is unlocked. Is there a way to stop a mysql_query from hanging (by setting a time limit)? The php.ini directive max_execution_time does not