The Information Schema INNODB_SYS_SEMAPHORE_WAITS table contains information about current semaphore waits.
The PROCESS privilege is required to view the table.
It contains the following columns:
| Column | Description |
|---|---|
| THREAD_ID | |
| OBJECT_NAME | |
| FILE | |
| LINE | |
| WAIT_TIME | |
| WAIT_OBJECT | |
| WAIT_TYPE | |
| HOLDER_THREAD_ID | |
| HOLDER_FILE | |
| HOLDER_LINE | |
| CREATED_FILE | |
| CREATED_LINE | |
| WRITER_THREAD | |
| RESERVATION_MODE | |
| READERS | |
| WAITERS_FLAG | |
| LOCK_WORD | |
| LAST_READER_FILE | |
| LAST_READER_LINE | |
| LAST_WRITER_FILE | |
| LAST_WRITER_LINE | |
| OS_WAIT_COUNT |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/information-schema-innodb_sys_semaphore_waits-table/