INNODB_SYS_SEMAPHORE_WAITS
This page is part of MariaDB's Documentation.
The parent of this page is: Information Schema for MariaDB Enterprise Server
Topics on this page:
Overview
In 11.4 ES, 10.6 ES, 10.6 CS:
Not present
In 11.4 ES, 10.6 ES:
Not present
In 10.5 ES, 10.5 CS, 10.4 ES, 10.4 CS, 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:
InnoDB SYS_
SEMAPHORE_ WAITS
In 10.5 ES, 10.4 ES:
InnoDB SYS_
SEMAPHORE_ WAITS
USAGE
DETAILS
SYNONYMS
SCHEMA
CREATE TEMPORARY TABLE `INNODB_SYS_SEMAPHORE_WAITS` (
`THREAD_ID` bigint(21) unsigned NOT NULL,
`OBJECT_NAME` varchar(4000),
`FILE` varchar(4000),
`LINE` int(11) unsigned NOT NULL,
`WAIT_TIME` bigint(21) unsigned NOT NULL,
`WAIT_OBJECT` bigint(21) unsigned NOT NULL,
`WAIT_TYPE` varchar(16),
`HOLDER_THREAD_ID` bigint(21) unsigned NOT NULL,
`HOLDER_FILE` varchar(4000),
`HOLDER_LINE` int(11) unsigned NOT NULL,
`CREATED_FILE` varchar(4000),
`CREATED_LINE` int(11) unsigned NOT NULL,
`WRITER_THREAD` bigint(21) unsigned NOT NULL,
`RESERVATION_MODE` varchar(16),
`READERS` int(11) unsigned NOT NULL,
`WAITERS_FLAG` bigint(21) unsigned NOT NULL,
`LOCK_WORD` bigint(21) unsigned NOT NULL,
`LAST_WRITER_FILE` varchar(4000),
`LAST_WRITER_LINE` int(11) unsigned NOT NULL,
`OS_WAIT_COUNT` int(11) unsigned NOT NULL
)
PARAMETERS
SKYSQL
PRIVILEGES
EXAMPLES
ERROR HANDLING
FEATURE INTERACTION
RESPONSES
DIAGNOSIS
ISO 9075:2016
CHANGE HISTORY
Release Series | History |
---|---|
11.4 Enterprise |
|
10.6 Enterprise |
|
10.6 Community |
|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
Release Series | History |
---|---|
11.4 Enterprise |
|
10.6 Enterprise |
|
10.5 Enterprise |
|
10.4 Enterprise |
|
RELATED TOPICS
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.