[Tools]  Datenbank: `information_schema`  Tabelle: `INNODB_SYS_SEMAPHORE_WAITS`

         ---               

SELECT * FROM `INNODB_SYS_SEMAPHORE_WAITS`

Die Ausführung von SQL-Befehlen kann Daten manipulieren! Der Autor übernimmt keine Haftung bei Datenverlusten.

Tabellen der Datenbank `information_schema` bearbeiten

Tabelle `INNODB_SYS_SEMAPHORE_WAITS`

Felder der Tabelle `INNODB_SYS_SEMAPHORE_WAITS`

		Field	Type	Size	NULL	Key	Attribute	Default	Extra	Sortierung	Kommentar
	1.	THREAD_ID	bigint	21	nein		unsigned
	2.	OBJECT_NAME	varchar	4000	ja					utf8_general_ci
	3.	FILE	varchar	4000	ja					utf8_general_ci
	4.	LINE	int	11	nein		unsigned
	5.	WAIT_TIME	bigint	21	nein		unsigned
	6.	WAIT_OBJECT	bigint	21	nein		unsigned
	7.	WAIT_TYPE	varchar	16	ja					utf8_general_ci
	8.	HOLDER_THREAD_ID	bigint	21	nein		unsigned
	9.	HOLDER_FILE	varchar	4000	ja					utf8_general_ci
	10.	HOLDER_LINE	int	11	nein		unsigned
	11.	CREATED_FILE	varchar	4000	ja					utf8_general_ci
	12.	CREATED_LINE	int	11	nein		unsigned
	13.	WRITER_THREAD	bigint	21	nein		unsigned
	14.	RESERVATION_MODE	varchar	16	ja					utf8_general_ci
	15.	READERS	int	11	nein		unsigned
	16.	WAITERS_FLAG	bigint	21	nein		unsigned
	17.	LOCK_WORD	bigint	21	nein		unsigned
	18.	LAST_WRITER_FILE	varchar	4000	ja					utf8_general_ci
	19.	LAST_WRITER_LINE	int	11	nein		unsigned
	20.	OS_WAIT_COUNT	int	11	nein		unsigned

Indizes der Tabelle `INNODB_SYS_SEMAPHORE_WAITS`