SHOW CREATE TABLE INFORMATION_SCHEMA.INNODB_SYS_SEMAPHORE_WAITS; Table Create Table INNODB_SYS_SEMAPHORE_WAITS 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 ) ENGINE=MEMORY DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci