Mysql ‘de locked edilmis tablolari asagidaki gibi izleyebilirsiniz.
mysql> show processlist;
ve
mysql> <strong>show open tables WHERE In_use > 0;</strong><br />
+--------------+--------------+--------+-------------+<br />
| Database | Table | In_use | Name_locked |<br />
+--------------+--------------+--------+-------------+<br />
| murat_ugur_ | eminoglu | 5 | 0 |<br />
+--------------+--------------+--------+-------------+<br />
1 row in set (0.00 sec)
+--------------+--------------+--------+-------------+<br />
| Database | Table | In_use | Name_locked |<br />
+--------------+--------------+--------+-------------+<br />
| murat_ugur_ | eminoglu | 5 | 0 |<br />
+--------------+--------------+--------+-------------+<br />
1 row in set (0.00 sec)
Leave a comment