Buy Percona SupportBuy 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  |
.....
This documentation is developed in Launchpad as part of the Percona Server 5.5.
If you spotted inaccuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.


General Inquiries

For general inquiries, please send us your question and someone will contact you.