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

         ---               

SELECT * FROM `INNODB_TRX`

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

Tabellen der Datenbank `information_schema` bearbeiten

Tabelle `INNODB_TRX`

Felder der Tabelle `INNODB_TRX`

		Field	Type	Size	NULL	Key	Attribute	Default	Extra	Sortierung	Kommentar
	1.	trx_id	bigint	21	nein		unsigned
	2.	trx_state	varchar	13	nein					utf8_general_ci
	3.	trx_started	datetime		nein
	4.	trx_requested_lock_id	varchar	81	ja					utf8_general_ci
	5.	trx_wait_started	datetime		ja
	6.	trx_weight	bigint	21	nein		unsigned
	7.	trx_mysql_thread_id	bigint	21	nein		unsigned
	8.	trx_query	varchar	1024	ja					utf8_general_ci
	9.	trx_operation_state	varchar	64	ja					utf8_general_ci
	10.	trx_tables_in_use	bigint	21	nein		unsigned
	11.	trx_tables_locked	bigint	21	nein		unsigned
	12.	trx_lock_structs	bigint	21	nein		unsigned
	13.	trx_lock_memory_bytes	bigint	21	nein		unsigned
	14.	trx_rows_locked	bigint	21	nein		unsigned
	15.	trx_rows_modified	bigint	21	nein		unsigned
	16.	trx_concurrency_tickets	bigint	21	nein		unsigned
	17.	trx_isolation_level	enum('READ		nein		UNCOMMITTED','READ COMMITTED','REPEATABLE READ','SERIALIZABLE')			utf8_general_ci
	18.	trx_unique_checks	int	1	nein
	19.	trx_foreign_key_checks	int	1	nein
	20.	trx_last_foreign_key_error	varchar	256	ja					utf8_general_ci
	21.	trx_is_read_only	int	1	nein
	22.	trx_autocommit_non_locking	int	1	nein

Indizes der Tabelle `INNODB_TRX`