Test for table lock

2002-10-21 Thread Mailing Lists
Hi, Using MySQL, perl and DBI, is there a way to test to see if a table is locked (as in "LOCK table..."). We batch process our updates every 3 hours or so (it's not a set schedule though, it depends when a certain level of new updates is reached), and our main tables are locked during this t

RE: Test for table lock

2002-10-21 Thread Don Read
On 21-Oct-2002 Mailing Lists wrote: > Hi, > > Using MySQL, perl and DBI, is there a way to test to see if a table is > locked (as in "LOCK table..."). We batch process our updates every 3 > hours or so (it's not a set schedule though, it depends when a certain level > of new updates is reach