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 reached), and our main tables are locked during this time
> for around 10 minutes or so. I'd like to be able to modify our search and
> display scripts to inform the users to come back later while the tables are
> locked.
>
Take a look at user level locking: GET_LOCK() and RELEASE_LOCK()
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
