Wednesday, November 24, 2010

[Level 2] How to get tables are in use or locked in MySQL?

How to get tables are in use or locked in MySQL?
mysql> show open tables where in_use <> 0 or name_locked <> 0;

Wish this helps.
regards,
Stanley Huang