RE: [PHP-WIN] MySQL Table Locks
| From: | Rich Gray | Date: | Fri, 07 Mar 2003 13:07:28 +0000 |
| Subject: | RE: [PHP-WIN] MySQL Table Locks | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-18894@lists.php.net to get a copy of this message | ||
> Anyone any idea how to check whether a table is locked? In
> particular I use
> FLUSH TABLES WITH READ LOCK before backup starts and want to know whether
> this has happened.
>
> Thanks in advance,
>
> . : Fran Thomas
Fran
I don't believe there is any method to show the lock status of a table -
well at least not one that can be queried at the SQL level... I guess you
could kludge it by using calls to GET_LOCK(),RELEASE_LOCK() instead ...
HTH
Rich