Show Lock Names

This feature is curently undocumented except for the following example.

Example:

mysql> show mutex status;
+--------+---------------------------+---------------+
| 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  |
.....
+1-888-316-9775 (USA - Sales)
+1-208-473-2904 (USA - Sales)
+44-208-133-0309 (UK - Sales)
+1-888-488-8556 (Emergency)

Server Series

Previous topic

Show Storage Engines

Next topic

Process List

This Page

© Copyright 2012, Percona Inc.
Except where otherwise noted, this documentation is licensed under the following license:
CC Attribution-ShareAlike 2.0 Generic
Created using Sphinx 1.0.7.
This documentation is developed in Launchpad as part of the Percona Server source code.
If you find errors, omissions or encounter trouble understanding parts of our documentation, please file a bug.
]]>