Buy Percona ServicesBuy Now!

Show Lock Names

This feature is currently undocumented except for the following example.

Example:

mysql> SHOW ENGINE INNODB MUTEX;
+--------+---------------------------+---------------+
| Type   | Name                      | Status        |
+--------+---------------------------+---------------+
| InnoDB | &rseg->mutex              | os_waits=210  |
| InnoDB | &dict_sys->mutex          | os_waits=3    |
| InnoDB | &trx_doublewrite->mutex   | os_waits=1    |
| InnoDB | &log_sys->mutex           | os_waits=1197 |
| InnoDB | &LRU_list_mutex           | os_waits=2    |
| InnoDB | &fil_system->mutex        | os_waits=5    |
| InnoDB | &kernel_mutex             | os_waits=242  |
| InnoDB | &new_index->lock          | os_waits=2    |
| InnoDB | &new_index->lock          | os_waits=415  |
.....

Previous topic

Show Storage Engines

Next topic

Process List

Visit Percona Store


General Inquiries

For general inquiries about our open source software and database management tools, please send us your question and someone will contact you.