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

Re: [PHP] mysql_query blocking

2009-06-28 Thread Tom Worster
On 6/27/09 7:09 PM, Daniel Kolbo kolb0...@umn.edu wrote: Tom Worster wrote: On 6/27/09 3:15 PM, Daniel Kolbo kolb0...@umn.edu 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

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 setting a

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 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_query from

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 until the

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 blocks at the MySQL

Re: [PHP] mysql_query blocking

2009-06-27 Thread Tom Worster
On 6/27/09 3:15 PM, Daniel Kolbo kolb0...@umn.edu 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

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 kolb0...@umn.edu 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 Bastien Koert
On Saturday, June 27, 2009, Bastien Koert phps...@gmail.com wrote: Why issue/do a lock at all? Shouldn't need a large lock at read bastien On Saturday, June 27, 2009, Daniel Kolbo kolb0...@umn.edu wrote Ashley Sheridan wrote: On Sat, 2009-06-27 at 16:03 -0400, Daniel Kolbo wrote:

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 kolb0...@umn.edu 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

Re: [PHP] mysql_query blocking

2009-06-27 Thread Daniel Kolbo
Tom Worster wrote: On 6/27/09 3:15 PM, Daniel Kolbo kolb0...@umn.edu 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

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 kolb0...@umn.edu 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

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 kolb0...@umn.edu 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

Re: [PHP] mysql_query blocking

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