root@localhost [mytest]>select * from INFORMATION_SCHEMA.INNODB_TRX WHERE TRX_MYSQL_THREAD_ID = connection_id()G; *************************** 1. row *************************** trx_id: 16200 trx_state: RUNNING trx_started: 2020-03-26 17:39:53 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 2 trx_query: select * from INFORMATION_SCHEMA.INNODB_TRX WHERE TRX_MYSQL_THREAD_ID = connection_id() trx_operation_state: NULL trx_tables_in_use: 0 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1136 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_adaptive_hash_latched: 0 trx_adaptive_hash_timeout: 0 trx_is_read_only: 0 trx_autocommit_non_locking: 0 1 row in set (0.00 sec) ERROR: No query specified