SHOW ENGINE engine_name {STATUS | MUTEX}
The SHOW ENGINE statement provides operational details about a storage engine. To use this statement, you must have the PROCESS privilege.
The statement is commonly used in the following forms:
SHOW ENGINE INNODB STATUS
SHOW ENGINE INNODB MUTEX
SHOW ENGINE PERFORMANCE_SCHEMA STATUS
The SHOW ENGINE INNODB STATUS statement returns detailed information from the standard InnoDB Monitor about the state of the InnoDB storage engine.
SHOW ENGINE INNODB MUTEX shows statistics on InnoDB mutexes and read-write locks (rw-locks).
The following table lists the SHOW ENGINE INNODB MUTEX output columns.
| Column | Description |
|---|---|
Type |
Always InnoDB. |
Name |
For mutexes, shows the mutex name. For read-write locks, it shows the source file and line number where the rw-lock is created. The line number can vary between MySQL versions. |
Status |
Shows the status of the mutex, including the number of spins, waits, and requests. It tracks:
|
SHOW ENGINE PERFORMANCE_SCHEMA STATUS can be used to examine the internal operation of the Performance Schema.
For more information, see the MySQL documentation: SHOW ENGINE Statement.