mysql> select * from replication_applier_status_by_worker; +--------------+-----------+-----------+---------------+-------------------------------------------------+-------------------+--------------------+----------------------+ | CHANNEL_NAME | WORKER_ID | THREAD_ID | SERVICE_STATE | LAST_SEEN_TRANSACTION | LAST_ERROR_NUMBER | LAST_ERROR_MESSAGE | LAST_ERROR_TIMESTAMP | +--------------+-----------+-----------+---------------+-------------------------------------------------+-------------------+--------------------+----------------------+ | | 1 | 52 | ON | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153276 | 0 | | 0000-00-00 00:00:00 | | | 2 | 53 | ON | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153275 | 0 | | 0000-00-00 00:00:00 | | | 3 | 54 | ON | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153277 | 0 | | 0000-00-00 00:00:00 | | | 4 | 55 | ON | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153273 | 0 | | 0000-00-00 00:00:00 | | | 5 | 56 | ON | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153278 | 0 | | 0000-00-00 00:00:00 | | | 6 | 57 | ON | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153279 | 0 | | 0000-00-00 00:00:00 | | | 7 | 58 | ON | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153280 | 0 | | 0000-00-00 00:00:00 | | | 8 | 59 | ON | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153281 | 0 | | 0000-00-00 00:00:00 | | | 9 | 60 | ON | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153282 | 0 | | 0000-00-00 00:00:00 | | | 10 | 61 | ON | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153283 | 0 | | 0000-00-00 00:00:00 | | | 11 | 62 | ON | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153284 | 0 | | 0000-00-00 00:00:00 | | | 12 | 63 | ON | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153285 | 0 | | 0000-00-00 00:00:00 | | | 13 | 64 | ON | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153274 | 0 | | 0000-00-00 00:00:00 | | | 14 | 65 | ON | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153286 | 0 | | 0000-00-00 00:00:00 | | | 15 | 66 | ON | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153287 | 0 | | 0000-00-00 00:00:00 | | | 16 | 67 | ON | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153288 | 0 | | 0000-00-00 00:00:00 | +--------------+-----------+-----------+---------------+-------------------------------------------------+-------------------+--------------------+----------------------+ 16 rows in set (0.00 sec) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 20.111.12.119 Master_User: dbscale_internal Master_Port: 6320 Connect_Retry: 60 Master_Log_File: greatdb-bin.003163 Read_Master_Log_Pos: 318825887 Relay_Log_File: mysql-relay.006927 Relay_Log_Pos: 804485073 Relay_Master_Log_File: greatdb-bin.003149 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 804484968 Relay_Log_Space: 15352520544 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 5078 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 11916320 Master_UUID: 97874c77-50d1-11eb-9b83-b4055d1499ee Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Waiting for slave workers to process their queues Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: 956fb75d-50d1-11eb-8ff7-b4055d149fd6:3-4, 95a79e48-50d1-11eb-9784-b4055d149e6a:694921-694922, 97874c77-50d1-11eb-9b83-b4055d1499ee:5002625770-7789522162 Executed_Gtid_Set: 346bd935-d3be-11eb-81d2-b4055d15045a:1-2202949, 956fb75d-50d1-11eb-8ff7-b4055d149fd6:1-4, 95a79e48-50d1-11eb-9784-b4055d149e6a:1-694922, 97874c77-50d1-11eb-9b83-b4055d1499ee:1-7772153272, 98b5e137-50d1-11eb-b342-b4055d149b9a:1-298297186, 9b1678ef-50d1-11eb-a8b6-b4055d1496be:1-26 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: Master_TLS_Version: 1 row in set (0.00 sec) mysql> select * from information_schema.processlist where command!='Sleep' order by time; +-------+-------------+-----------------+--------------------+---------+--------+---------------------------------------------------+-----------------------------------------------------------------------------------+ | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | +-------+-------------+-----------------+--------------------+---------+--------+---------------------------------------------------+-----------------------------------------------------------------------------------+ | 10297 | root | 127.0.0.1:48130 | performance_schema | Query | 0 | executing | select * from information_schema.processlist where command!='Sleep' order by time | | 38 | system user | | NULL | Connect | 5173 | Waiting for preceding transaction to commit | NULL | | 36 | system user | | NULL | Connect | 5173 | Waiting for preceding transaction to commit | NULL | | 37 | system user | | NULL | Connect | 5173 | Waiting for preceding transaction to commit | NULL | | 34 | system user | | NULL | Connect | 5173 | Waiting for preceding transaction to commit | NULL | | 35 | system user | | NULL | Connect | 5173 | Waiting for preceding transaction to commit | NULL | | 32 | system user | | NULL | Connect | 5173 | Waiting for preceding transaction to commit | NULL | | 33 | system user | | NULL | Connect | 5173 | Waiting for preceding transaction to commit | NULL | | 30 | system user | | NULL | Connect | 5173 | Waiting for preceding transaction to commit | NULL | | 31 | system user | | NULL | Connect | 5173 | Waiting for preceding transaction to commit | NULL | | 28 | system user | | NULL | Connect | 5173 | Waiting for preceding transaction to commit | NULL | | 29 | system user | | NULL | Connect | 5173 | Waiting for preceding transaction to commit | NULL | | 27 | system user | | NULL | Connect | 5173 | Waiting for preceding transaction to commit | NULL | | 25 | system user | | NULL | Connect | 5173 | Waiting for preceding transaction to commit | NULL | | 26 | system user | | NULL | Connect | 5173 | System lock | NULL | | 23 | system user | | NULL | Connect | 5173 | Waiting for preceding transaction to commit | NULL | | 24 | system user | | NULL | Connect | 5173 | Waiting for preceding transaction to commit | NULL | | 22 | system user | | NULL | Connect | 5174 | Waiting for slave workers to process their queues | NULL | | 39 | system user | | NULL | Connect | 933155 | Queueing master event to the relay log | NULL | +-------+-------------+-----------------+--------------------+---------+--------+---------------------------------------------------+-----------------------------------------------------------------------------------+ 19 rows in set (0.00 sec) mysql> select * from metadata_locks; +-------------+-----------------------+-----------------------+-----------------------+---------------------+---------------+-------------+--------+-----------------+----------------+ | OBJECT_TYPE | OBJECT_SCHEMA | OBJECT_NAME | OBJECT_INSTANCE_BEGIN | LOCK_TYPE | LOCK_DURATION | LOCK_STATUS | SOURCE | OWNER_THREAD_ID | OWNER_EVENT_ID | +-------------+-----------------------+-----------------------+-----------------------+---------------------+---------------+-------------+--------+-----------------+----------------+ | TABLE | performance_schema | metadata_locks | 140494285879632 | SHARED_READ | TRANSACTION | GRANTED | | 10326 | 1887 | | GLOBAL | NULL | NULL | 140498256763440 | INTENTION_EXCLUSIVE | STATEMENT | GRANTED | | 55 | 82699073600 | | TABLE | abappcdd_dbscale_4_19 | a_xx_asyn_timeout_reg | 140498256829808 | SHARED_WRITE | TRANSACTION | GRANTED | | 55 | 82699073600 | | TABLE | abappcdd_dbscale_2_11 | a_xx_asyn_timeout_reg | 140495932072672 | SHARED_WRITE | TRANSACTION | GRANTED | | 64 | 3565278629 | | COMMIT | NULL | NULL | 140495931598080 | INTENTION_EXCLUSIVE | EXPLICIT | GRANTED | | 64 | 3565278694 | | TABLE | abappcdd | a_xx_asyn_timeout_reg | 140498428306224 | SHARED_WRITE | TRANSACTION | GRANTED | | 53 | 179698590557 | | COMMIT | NULL | NULL | 140498443339040 | INTENTION_EXCLUSIVE | EXPLICIT | GRANTED | | 53 | 179698590622 | | TABLE | abappcdd | t_eb_npp_journal | 140498374972368 | SHARED_WRITE | TRANSACTION | GRANTED | | 52 | 227107326058 | | TABLE | abappcdd_dbscale_5_23 | t_eb_npp_journal | 140498232062560 | SHARED_WRITE | TRANSACTION | GRANTED | | 54 | 135434826184 | | TABLE | abappcdd_dbscale_1_7 | a_xx_asyn_timeout_reg | 140496373820320 | SHARED_WRITE | TRANSACTION | GRANTED | | 56 | 39982798398 | | COMMIT | NULL | NULL | 140493352285776 | INTENTION_EXCLUSIVE | EXPLICIT | GRANTED | | 52 | 227107326138 | | COMMIT | NULL | NULL | 140496377932032 | INTENTION_EXCLUSIVE | EXPLICIT | GRANTED | | 56 | 39982798464 | | COMMIT | NULL | NULL | 140498233214864 | INTENTION_EXCLUSIVE | EXPLICIT | GRANTED | | 54 | 135434826263 | | TABLE | abappcdd_dbscale_7_31 | t_eb_npp_journal | 140496232486208 | SHARED_WRITE | TRANSACTION | GRANTED | | 57 | 18685747721 | | TABLE | abappcdd_dbscale_6_27 | t_eb_npp_journal | 140496308928544 | SHARED_WRITE | TRANSACTION | GRANTED | | 58 | 11607711756 | | COMMIT | NULL | NULL | 140496239581776 | INTENTION_EXCLUSIVE | EXPLICIT | GRANTED | | 57 | 18685747800 | | TABLE | abappcdd_dbscale_6_27 | a_xx_asyn_timeout_reg | 140496109019552 | SHARED_WRITE | TRANSACTION | GRANTED | | 59 | 8760956228 | | COMMIT | NULL | NULL | 140496108457232 | INTENTION_EXCLUSIVE | EXPLICIT | GRANTED | | 59 | 8760956293 | | COMMIT | NULL | NULL | 140496306819744 | INTENTION_EXCLUSIVE | EXPLICIT | GRANTED | | 58 | 11607711873 | | TABLE | abappcdd_dbscale_6_27 | t_eb_npp_journal | 140496170469248 | SHARED_WRITE | TRANSACTION | GRANTED | | 60 | 6891258093 | | TABLE | abappcdd_dbscale_2_11 | a_xx_asyn_timeout_reg | 140495984796128 | SHARED_WRITE | TRANSACTION | GRANTED | | 61 | 5780186689 | | COMMIT | NULL | NULL | 140496167705552 | INTENTION_EXCLUSIVE | EXPLICIT | GRANTED | | 60 | 6891258187 | | COMMIT | NULL | NULL | 140495986475872 | INTENTION_EXCLUSIVE | EXPLICIT | GRANTED | | 61 | 5780186756 | | TABLE | abappcdd | t_eb_npp_journal | 140496044561488 | SHARED_WRITE | TRANSACTION | GRANTED | | 62 | 4726565070 | | TABLE | abappcdd_dbscale_3_15 | a_xx_asyn_timeout_reg | 140495834818128 | SHARED_WRITE | TRANSACTION | GRANTED | | 63 | 4006939305 | | COMMIT | NULL | NULL | 140496044728624 | INTENTION_EXCLUSIVE | EXPLICIT | GRANTED | | 62 | 4726565149 | | COMMIT | NULL | NULL | 140495831186656 | INTENTION_EXCLUSIVE | EXPLICIT | GRANTED | | 63 | 4006939371 | | TABLE | abappcdd_dbscale_2_11 | t_eb_npp_journal | 140495706720880 | SHARED_WRITE | TRANSACTION | GRANTED | | 65 | 2165658848 | | TABLE | abappcdd_dbscale_2_11 | a_xx_asyn_timeout_reg | 140495762533696 | SHARED_WRITE | TRANSACTION | GRANTED | | 66 | 1978143389 | | COMMIT | NULL | NULL | 140495699464864 | INTENTION_EXCLUSIVE | EXPLICIT | GRANTED | | 65 | 2165658942 | | COMMIT | NULL | NULL | 140495762539744 | INTENTION_EXCLUSIVE | EXPLICIT | GRANTED | | 66 | 1978143455 | | TABLE | abappcdd_dbscale_1_7 | t_eb_journal | 140495566200320 | SHARED_WRITE | TRANSACTION | GRANTED | | 67 | 1801840792 | | COMMIT | NULL | NULL | 140495575332688 | INTENTION_EXCLUSIVE | EXPLICIT | GRANTED | | 67 | 1801840853 | +-------------+-----------------------+-----------------------+-----------------------+---------------------+---------------+-------------+--------+-----------------+----------------+ 33 rows in set (0.00 sec) mysql> select * from threads where processlist_id >=20 and processlist_id<=40; +-----------+-------------------------+------------+----------------+------------------+------------------+-----------------------+---------------------+------------------+---------------------------------------------------+----------------------------------------------------------+------------------+------+--------------+---------+-----------------+--------------+ | THREAD_ID | NAME | TYPE | PROCESSLIST_ID | PROCESSLIST_USER | PROCESSLIST_HOST | PROCESSLIST_DB | PROCESSLIST_COMMAND | PROCESSLIST_TIME | PROCESSLIST_STATE | PROCESSLIST_INFO | PARENT_THREAD_ID | ROLE | INSTRUMENTED | HISTORY | CONNECTION_TYPE | THREAD_OS_ID | +-----------+-------------------------+------------+----------------+------------------+------------------+-----------------------+---------------------+------------------+---------------------------------------------------+----------------------------------------------------------+------------------+------+--------------+---------+-----------------+--------------+ | 51 | thread/sql/slave_sql | FOREGROUND | 22 | dbscale_internal | 20.111.12.111 | NULL | Connect | 5315 | Waiting for slave workers to process their queues | NULL | 31 | NULL | YES | YES | NULL | 82836 | | 52 | thread/sql/slave_worker | FOREGROUND | 23 | dbscale_internal | 20.111.12.111 | abappcdd | Connect | 5314 | Waiting for preceding transaction to commit | XA END X'323031393634343533352d302d3130312d3132',X'',1 | 51 | NULL | YES | YES | NULL | 82837 | | 53 | thread/sql/slave_worker | FOREGROUND | 24 | dbscale_internal | 20.111.12.111 | abappcdd_dbscale_2_11 | Connect | 5314 | Waiting for preceding transaction to commit | XA END X'3637333231383231332d302d3130312d3133',X'',1 | 51 | NULL | YES | YES | NULL | 82838 | | 54 | thread/sql/slave_worker | FOREGROUND | 25 | dbscale_internal | 20.111.12.111 | NULL | Connect | 5314 | Waiting for preceding transaction to commit | XA END X'323031393634343336382d352d3130312d3132',X'',1 | 51 | NULL | YES | YES | NULL | 82839 | | 55 | thread/sql/slave_worker | FOREGROUND | 26 | dbscale_internal | 20.111.12.111 | NULL | Connect | 5314 | System lock | XA START X'323136343732373731382d342d3130312d3131',X'',1 | 51 | NULL | YES | YES | NULL | 82840 | | 56 | thread/sql/slave_worker | FOREGROUND | 27 | dbscale_internal | 20.111.12.111 | NULL | Connect | 5314 | Waiting for preceding transaction to commit | XA END X'3637333231383231372d312d3130312d3133',X'',1 | 51 | NULL | YES | YES | NULL | 82841 | | 57 | thread/sql/slave_worker | FOREGROUND | 28 | dbscale_internal | 20.111.12.111 | NULL | Connect | 5314 | Waiting for preceding transaction to commit | XA END X'323031393634343533382d372d3130312d3132',X'',1 | 51 | NULL | YES | YES | NULL | 82842 | | 58 | thread/sql/slave_worker | FOREGROUND | 29 | dbscale_internal | 20.111.12.111 | NULL | Connect | 5314 | Waiting for preceding transaction to commit | XA END X'3637333231383131382d362d3130312d3133',X'',1 | 51 | NULL | YES | YES | NULL | 82843 | | 59 | thread/sql/slave_worker | FOREGROUND | 30 | dbscale_internal | 20.111.12.111 | NULL | Connect | 5314 | Waiting for preceding transaction to commit | XA END X'323031393634343531352d362d3130312d3132',X'',1 | 51 | NULL | YES | YES | NULL | 82844 | | 60 | thread/sql/slave_worker | FOREGROUND | 31 | dbscale_internal | 20.111.12.111 | NULL | Connect | 5314 | Waiting for preceding transaction to commit | XA END X'3637333231383135342d362d3130312d3133',X'',1 | 51 | NULL | YES | YES | NULL | 82845 | | 61 | thread/sql/slave_worker | FOREGROUND | 32 | dbscale_internal | 20.111.12.111 | NULL | Connect | 5314 | Waiting for preceding transaction to commit | XA END X'323136343732373733302d322d3130312d3131',X'',1 | 51 | NULL | YES | YES | NULL | 82846 | | 62 | thread/sql/slave_worker | FOREGROUND | 33 | dbscale_internal | 20.111.12.111 | NULL | Connect | 5314 | Waiting for preceding transaction to commit | XA END X'3637333231383132312d302d3130312d3133',X'',1 | 51 | NULL | YES | YES | NULL | 82847 | | 63 | thread/sql/slave_worker | FOREGROUND | 34 | dbscale_internal | 20.111.12.111 | NULL | Connect | 5314 | Waiting for preceding transaction to commit | XA END X'323031393634343532362d332d3130312d3132',X'',1 | 51 | NULL | YES | YES | NULL | 82848 | | 64 | thread/sql/slave_worker | FOREGROUND | 35 | dbscale_internal | 20.111.12.111 | NULL | Connect | 5314 | Waiting for preceding transaction to commit | XA END X'323136343732373731372d322d3130312d3131',X'',1 | 51 | NULL | YES | YES | NULL | 82849 | | 65 | thread/sql/slave_worker | FOREGROUND | 36 | dbscale_internal | 20.111.12.111 | NULL | Connect | 5314 | Waiting for preceding transaction to commit | XA END X'323136343732373638372d322d3130312d3131',X'',1 | 51 | NULL | YES | YES | NULL | 82850 | | 66 | thread/sql/slave_worker | FOREGROUND | 37 | dbscale_internal | 20.111.12.111 | NULL | Connect | 5314 | Waiting for preceding transaction to commit | XA END X'3637333231383234332d322d3130312d3133',X'',1 | 51 | NULL | YES | YES | NULL | 82851 | | 67 | thread/sql/slave_worker | FOREGROUND | 38 | dbscale_internal | 20.111.12.111 | NULL | Connect | 5314 | Waiting for preceding transaction to commit | XA END X'323031393634343230332d312d3130312d3132',X'',1 | 51 | NULL | YES | YES | NULL | 82852 | | 68 | thread/sql/slave_io | FOREGROUND | 39 | dbscale_internal | 20.111.12.111 | NULL | Connect | 933296 | Waiting for master to send event | NULL | 31 | NULL | YES | YES | NULL | 82853 | +-----------+-------------------------+------------+----------------+------------------+------------------+-----------------------+---------------------+------------------+---------------------------------------------------+----------------------------------------------------------+------------------+------+--------------+---------+-----------------+--------------+ 18 rows in set (0.00 sec) mysql> select * from events_statements_history where thread_id=55 order by TIMER_START; +-----------+-------------+--------------+------------------------+--------+--------------------+--------------------+------------+-----------+----------------------------------------------------------+----------------------------------+------------------+----------------+-------------+---------------+-------------+-----------------------+-------------+-------------------+--------------+--------+----------+---------------+-----------+---------------+-------------------------+--------------------+------------------+------------------------+--------------+--------------------+-------------+-------------------+------------+-----------+-----------+---------------+--------------------+------------------+--------------------+---------------------+ | THREAD_ID | EVENT_ID | END_EVENT_ID | EVENT_NAME | SOURCE | TIMER_START | TIMER_END | TIMER_WAIT | LOCK_TIME | SQL_TEXT | DIGEST | DIGEST_TEXT | CURRENT_SCHEMA | OBJECT_TYPE | OBJECT_SCHEMA | OBJECT_NAME | OBJECT_INSTANCE_BEGIN | MYSQL_ERRNO | RETURNED_SQLSTATE | MESSAGE_TEXT | ERRORS | WARNINGS | ROWS_AFFECTED | ROWS_SENT | ROWS_EXAMINED | CREATED_TMP_DISK_TABLES | CREATED_TMP_TABLES | SELECT_FULL_JOIN | SELECT_FULL_RANGE_JOIN | SELECT_RANGE | SELECT_RANGE_CHECK | SELECT_SCAN | SORT_MERGE_PASSES | SORT_RANGE | SORT_ROWS | SORT_SCAN | NO_INDEX_USED | NO_GOOD_INDEX_USED | NESTING_EVENT_ID | NESTING_EVENT_TYPE | NESTING_EVENT_LEVEL | +-----------+-------------+--------------+------------------------+--------+--------------------+--------------------+------------+-----------+----------------------------------------------------------+----------------------------------+------------------+----------------+-------------+---------------+-------------+-----------------------+-------------+-------------------+--------------+--------+----------+---------------+-----------+---------------+-------------------------+--------------------+------------------+------------------------+--------------+--------------------+-------------+-------------------+------------+-----------+-----------+---------------+--------------------+------------------+--------------------+---------------------+ | 55 | 82699072100 | 82699072113 | statement/sql/xa_start | | 928275080824096000 | 928275080835123000 | 11027000 | 0 | XA START X'3637333231383135362d352d3130312d3133',X'',1 | 4ffe8012ab67120c12154e8be23c81ee | XA START ?, ... | abappcdd | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | | 55 | 82699072172 | 82699072182 | statement/sql/xa_end | | 928275080900868000 | 928275080906636000 | 5768000 | 0 | XA END X'3637333231383135362d352d3130312d3133',X'',1 | 312ea0514a3d7ad1b544fcfeb565ad8b | XA END ?, ... | abappcdd | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 82699072104 | TRANSACTION | 0 | | 55 | 82699072319 | 82699072332 | statement/sql/xa_start | | 928275081293761000 | 928275081304028000 | 10267000 | 0 | XA START X'323136343732373539392d332d3130312d3131',X'',1 | 4ffe8012ab67120c12154e8be23c81ee | XA START ?, ... | abappcdd | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | | 55 | 82699072406 | 82699072416 | statement/sql/xa_end | | 928275081442718000 | 928275081449661000 | 6943000 | 0 | XA END X'323136343732373539392d332d3130312d3131',X'',1 | 312ea0514a3d7ad1b544fcfeb565ad8b | XA END ?, ... | abappcdd | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 82699072323 | TRANSACTION | 0 | | 55 | 82699072562 | 82699072575 | statement/sql/xa_start | | 928275081743195000 | 928275081754682000 | 11487000 | 0 | XA START X'3637333231383135302d332d3130312d3133',X'',1 | 4ffe8012ab67120c12154e8be23c81ee | XA START ?, ... | abappcdd | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | | 55 | 82699072635 | 82699072645 | statement/sql/xa_end | | 928275081816819000 | 928275081821850000 | 5031000 | 0 | XA END X'3637333231383135302d332d3130312d3133',X'',1 | 312ea0514a3d7ad1b544fcfeb565ad8b | XA END ?, ... | abappcdd | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 82699072566 | TRANSACTION | 0 | | 55 | 82699072791 | 82699072804 | statement/sql/xa_start | | 928275082239544000 | 928275082251088000 | 11544000 | 0 | XA START X'323031393634343434332d342d3130312d3132',X'',1 | 4ffe8012ab67120c12154e8be23c81ee | XA START ?, ... | abappcdd | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | | 55 | 82699072865 | 82699072875 | statement/sql/xa_end | | 928275082313997000 | 928275082319074000 | 5077000 | 0 | XA END X'323031393634343434332d342d3130312d3132',X'',1 | 312ea0514a3d7ad1b544fcfeb565ad8b | XA END ?, ... | abappcdd | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 82699072795 | TRANSACTION | 0 | | 55 | 82699073020 | 82699073031 | statement/sql/begin | | 928275082850562000 | 928275082856464000 | 5902000 | 0 | BEGIN | f57daa74a09445d1e1c496f28fe6d906 | BEGIN | abappcdd | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | | 55 | 82699073578 | 82699073591 | statement/sql/xa_start | | 928275083504190000 | 928275083511914000 | 7724000 | 0 | XA START X'323136343732373731382d342d3130312d3131',X'',1 | 4ffe8012ab67120c12154e8be23c81ee | XA START ?, ... | abappcdd | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | +-----------+-------------+--------------+------------------------+--------+--------------------+--------------------+------------+-----------+----------------------------------------------------------+----------------------------------+------------------+----------------+-------------+---------------+-------------+-----------------------+-------------+-------------------+--------------+--------+----------+---------------+-----------+---------------+-------------------------+--------------------+------------------+------------------------+--------------+--------------------+-------------+-------------------+------------+-----------+-----------+---------------+--------------------+------------------+--------------------+---------------------+ mysql> select * from events_waits_current where thread_id=55; +-----------+-------------+--------------+-----------------------------+--------+--------------------+--------------------+-------------------+-------+-----------------------+-----------------------+------------+-------------+-----------------------+------------------+--------------------+----------------+-----------------+-------+ | THREAD_ID | EVENT_ID | END_EVENT_ID | EVENT_NAME | SOURCE | TIMER_START | TIMER_END | TIMER_WAIT | SPINS | OBJECT_SCHEMA | OBJECT_NAME | INDEX_NAME | OBJECT_TYPE | OBJECT_INSTANCE_BEGIN | NESTING_EVENT_ID | NESTING_EVENT_TYPE | OPERATION | NUMBER_OF_BYTES | FLAGS | +-----------+-------------+--------------+-----------------------------+--------+--------------------+--------------------+-------------------+-------+-----------------------+-----------------------+------------+-------------+-----------------------+------------------+--------------------+----------------+-----------------+-------+ | 55 | 82699073606 | NULL | wait/lock/table/sql/handler | | 927261386621228690 | 938105694127642644 | 10844307506413954 | NULL | abappcdd_dbscale_4_19 | a_xx_asyn_timeout_reg | PRIMARY | TABLE | 140498256448944 | 82699073605 | STAGE | write external | NULL | NULL | +-----------+-------------+--------------+-----------------------------+--------+--------------------+--------------------+-------------------+-------+-----------------------+-----------------------+------------+-------------+-----------------------+------------------+--------------------+----------------+-----------------+-------+ 1 row in set (0.00 sec) mysql> select * from events_waits_history where thread_id=55; +-----------+-------------+--------------+-----------------------------------+--------+--------------------+--------------------+------------+-------+---------------+-------------+------------+-------------+-----------------------+------------------+--------------------+-----------+-----------------+-------+ | THREAD_ID | EVENT_ID | END_EVENT_ID | EVENT_NAME | SOURCE | TIMER_START | TIMER_END | TIMER_WAIT | SPINS | OBJECT_SCHEMA | OBJECT_NAME | INDEX_NAME | OBJECT_TYPE | OBJECT_INSTANCE_BEGIN | NESTING_EVENT_ID | NESTING_EVENT_TYPE | OPERATION | NUMBER_OF_BYTES | FLAGS | +-----------+-------------+--------------+-----------------------------------+--------+--------------------+--------------------+------------+-------+---------------+-------------+------------+-------------+-----------------------+------------------+--------------------+-----------+-----------------+-------+ | 55 | 82699183183 | 82699183183 | wait/synch/mutex/innodb/trx_mutex | | 938116289524878012 | 938116289525007858 | 129846 | NULL | NULL | NULL | NULL | NULL | 140611875092304 | 82699073606 | WAIT | lock | NULL | NULL | | 55 | 82699183174 | 82699183174 | wait/synch/mutex/innodb/trx_mutex | | 938115389963715818 | 938115389963936750 | 220932 | NULL | NULL | NULL | NULL | NULL | 140611875092304 | 82699073606 | WAIT | lock | NULL | NULL | | 55 | 82699183175 | 82699183175 | wait/synch/mutex/innodb/trx_mutex | | 938115489913392024 | 938115489913519286 | 127262 | NULL | NULL | NULL | NULL | NULL | 140611875092304 | 82699073606 | WAIT | lock | NULL | NULL | | 55 | 82699183176 | 82699183176 | wait/synch/mutex/innodb/trx_mutex | | 938115589862682568 | 938115589862814352 | 131784 | NULL | NULL | NULL | NULL | NULL | 140611875092304 | 82699073606 | WAIT | lock | NULL | NULL | | 55 | 82699183177 | 82699183177 | wait/synch/mutex/innodb/trx_mutex | | 938115689819531958 | 938115689819733510 | 201552 | NULL | NULL | NULL | NULL | NULL | 140611875092304 | 82699073606 | WAIT | lock | NULL | NULL | | 55 | 82699183178 | 82699183178 | wait/synch/mutex/innodb/trx_mutex | | 938115789771053786 | 938115789771180402 | 126616 | NULL | NULL | NULL | NULL | NULL | 140611875092304 | 82699073606 | WAIT | lock | NULL | NULL | | 55 | 82699183179 | 82699183179 | wait/synch/mutex/innodb/trx_mutex | | 938115889724376662 | 938115889724503924 | 127262 | NULL | NULL | NULL | NULL | NULL | 140611875092304 | 82699073606 | WAIT | lock | NULL | NULL | | 55 | 82699183180 | 82699183180 | wait/synch/mutex/innodb/trx_mutex | | 938115989675437246 | 938115989675563862 | 126616 | NULL | NULL | NULL | NULL | NULL | 140611875092304 | 82699073606 | WAIT | lock | NULL | NULL | | 55 | 82699183181 | 82699183181 | wait/synch/mutex/innodb/trx_mutex | | 938116089625017198 | 938116089625149628 | 132430 | NULL | NULL | NULL | NULL | NULL | 140611875092304 | 82699073606 | WAIT | lock | NULL | NULL | | 55 | 82699183182 | 82699183182 | wait/synch/mutex/innodb/trx_mutex | | 938116189575554522 | 938116189575745738 | 191216 | NULL | NULL | NULL | NULL | NULL | 140611875092304 | 82699073606 | WAIT | lock | NULL | NULL | +-----------+-------------+--------------+-----------------------------------+--------+--------------------+--------------------+------------+-------+---------------+-------------+------------+-------------+-----------------------+------------------+--------------------+-----------+-----------------+-------+ 10 rows in set (0.00 sec) mysql> select * from events_transactions_current where thread_id=55; +-----------+-------------+--------------+-------------+--------+--------+-------------------------------------------------+---------------+---------------------+-----------+----------+--------+--------------------+--------------------+-------------------+-------------+-----------------+------------+----------------------+---------------------------------+-----------------------------+-----------------------+------------------+--------------------+ | THREAD_ID | EVENT_ID | END_EVENT_ID | EVENT_NAME | STATE | TRX_ID | GTID | XID_FORMAT_ID | XID_GTRID | XID_BQUAL | XA_STATE | SOURCE | TIMER_START | TIMER_END | TIMER_WAIT | ACCESS_MODE | ISOLATION_LEVEL | AUTOCOMMIT | NUMBER_OF_SAVEPOINTS | NUMBER_OF_ROLLBACK_TO_SAVEPOINT | NUMBER_OF_RELEASE_SAVEPOINT | OBJECT_INSTANCE_BEGIN | NESTING_EVENT_ID | NESTING_EVENT_TYPE | +-----------+-------------+--------------+-------------+--------+--------+-------------------------------------------------+---------------+---------------------+-----------+----------+--------+--------------------+--------------------+-------------------+-------------+-----------------+------------+----------------------+---------------------------------+-----------------------------+-----------------------+------------------+--------------------+ | 55 | 82699073582 | NULL | transaction | ACTIVE | NULL | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153273 | 1 | 2164727718-4-101-11 | NULL | ACTIVE | | 928275083508505000 | 939151142259082000 | 10876058750577000 | READ WRITE | READ COMMITTED | NO | 0 | 0 | 0 | NULL | 82699073578 | STATEMENT | +-----------+-------------+--------------+-------------+--------+--------+-------------------------------------------------+---------------+---------------------+-----------+----------+--------+--------------------+--------------------+-------------------+-------------+-----------------+------------+----------------------+---------------------------------+-----------------------------+-----------------------+------------------+--------------------+ 1 row in set (0.00 sec) mysql> select * from events_transactions_history where thread_id=55; +-----------+-------------+--------------+-------------+-----------+-----------------+-------------------------------------------------+---------------+---------------------+-----------+-----------+--------+--------------------+--------------------+------------+-------------+-----------------+------------+----------------------+---------------------------------+-----------------------------+-----------------------+------------------+--------------------+ | THREAD_ID | EVENT_ID | END_EVENT_ID | EVENT_NAME | STATE | TRX_ID | GTID | XID_FORMAT_ID | XID_GTRID | XID_BQUAL | XA_STATE | SOURCE | TIMER_START | TIMER_END | TIMER_WAIT | ACCESS_MODE | ISOLATION_LEVEL | AUTOCOMMIT | NUMBER_OF_SAVEPOINTS | NUMBER_OF_ROLLBACK_TO_SAVEPOINT | NUMBER_OF_RELEASE_SAVEPOINT | OBJECT_INSTANCE_BEGIN | NESTING_EVENT_ID | NESTING_EVENT_TYPE | +-----------+-------------+--------------+-------------+-----------+-----------------+-------------------------------------------------+---------------+---------------------+-----------+-----------+--------+--------------------+--------------------+------------+-------------+-----------------+------------+----------------------+---------------------------------+-----------------------------+-----------------------+------------------+--------------------+ | 55 | 82699072029 | 82699072077 | transaction | COMMITTED | 422086851807520 | AUTOMATIC | NULL | NULL | NULL | NULL | | 928275080450841000 | 928275080564388000 | 113547000 | READ WRITE | READ COMMITTED | YES | 0 | 0 | 0 | NULL | NULL | NULL | | 55 | 82699072104 | 82699072245 | transaction | COMMITTED | NULL | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153245 | 1 | 673218156-5-101-13 | NULL | COMMITTED | | 928275080830971000 | 928275081061955000 | 230984000 | READ WRITE | READ COMMITTED | NO | 0 | 0 | 0 | NULL | 82699072100 | STATEMENT | | 55 | 82699072256 | 82699072296 | transaction | COMMITTED | 422086851807520 | AUTOMATIC | NULL | NULL | NULL | NULL | | 928275081071175000 | 928275081180288000 | 109113000 | READ WRITE | READ COMMITTED | YES | 0 | 0 | 0 | NULL | NULL | NULL | | 55 | 82699072323 | 82699072489 | transaction | COMMITTED | NULL | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153249 | 1 | 2164727599-3-101-11 | NULL | COMMITTED | | 928275081299301000 | 928275081596595000 | 297294000 | READ WRITE | READ COMMITTED | NO | 0 | 0 | 0 | NULL | 82699072319 | STATEMENT | | 55 | 82699072500 | 82699072539 | transaction | COMMITTED | 422086851807520 | AUTOMATIC | NULL | NULL | NULL | NULL | | 928275081608077000 | 928275081689951000 | 81874000 | READ WRITE | READ COMMITTED | YES | 0 | 0 | 0 | NULL | NULL | NULL | | 55 | 82699072566 | 82699072719 | transaction | COMMITTED | NULL | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153254 | 1 | 673218150-3-101-13 | NULL | COMMITTED | | 928275081750177000 | 928275081977938000 | 227761000 | READ WRITE | READ COMMITTED | NO | 0 | 0 | 0 | NULL | 82699072562 | STATEMENT | | 55 | 82699072730 | 82699072768 | transaction | COMMITTED | 422086851807520 | AUTOMATIC | NULL | NULL | NULL | NULL | | 928275081994908000 | 928275082094344000 | 99436000 | READ WRITE | READ COMMITTED | YES | 0 | 0 | 0 | NULL | NULL | NULL | | 55 | 82699072795 | 82699072947 | transaction | COMMITTED | NULL | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153258 | 1 | 2019644443-4-101-12 | NULL | COMMITTED | | 928275082245905000 | 928275082435285000 | 189380000 | READ WRITE | READ COMMITTED | NO | 0 | 0 | 0 | NULL | 82699072791 | STATEMENT | | 55 | 82699072958 | 82699072997 | transaction | COMMITTED | 422086851807520 | AUTOMATIC | NULL | NULL | NULL | NULL | | 928275082443433000 | 928275082491664000 | 48231000 | READ WRITE | READ COMMITTED | YES | 0 | 0 | 0 | NULL | NULL | NULL | | 55 | 82699073024 | 82699073559 | transaction | COMMITTED | NULL | 97874c77-50d1-11eb-9b83-b4055d1499ee:7772153262 | NULL | NULL | NULL | NULL | | 928275082854896000 | 928275083434249000 | 579353000 | READ WRITE | READ COMMITTED | NO | 0 | 0 | 0 | NULL | 82699073020 | STATEMENT | +-----------+-------------+--------------+-------------+-----------+-----------------+-------------------------------------------------+---------------+---------------------+-----------+-----------+--------+--------------------+--------------------+------------+-------------+-----------------+------------+----------------------+---------------------------------+-----------------------------+-----------------------+------------------+--------------------+ 10 rows in set (0.00 sec) mysql> select * from events_statements_current where thread_id=55; +-----------+-------------+--------------+------------------------+--------+--------------------+--------------------+------------+-----------+----------------------------------------------------------+----------------------------------+------------------+----------------+-------------+---------------+-------------+-----------------------+-------------+-------------------+--------------+--------+----------+---------------+-----------+---------------+-------------------------+--------------------+------------------+------------------------+--------------+--------------------+-------------+-------------------+------------+-----------+-----------+---------------+--------------------+------------------+--------------------+---------------------+ | THREAD_ID | EVENT_ID | END_EVENT_ID | EVENT_NAME | SOURCE | TIMER_START | TIMER_END | TIMER_WAIT | LOCK_TIME | SQL_TEXT | DIGEST | DIGEST_TEXT | CURRENT_SCHEMA | OBJECT_TYPE | OBJECT_SCHEMA | OBJECT_NAME | OBJECT_INSTANCE_BEGIN | MYSQL_ERRNO | RETURNED_SQLSTATE | MESSAGE_TEXT | ERRORS | WARNINGS | ROWS_AFFECTED | ROWS_SENT | ROWS_EXAMINED | CREATED_TMP_DISK_TABLES | CREATED_TMP_TABLES | SELECT_FULL_JOIN | SELECT_FULL_RANGE_JOIN | SELECT_RANGE | SELECT_RANGE_CHECK | SELECT_SCAN | SORT_MERGE_PASSES | SORT_RANGE | SORT_ROWS | SORT_SCAN | NO_INDEX_USED | NO_GOOD_INDEX_USED | NESTING_EVENT_ID | NESTING_EVENT_TYPE | NESTING_EVENT_LEVEL | +-----------+-------------+--------------+------------------------+--------+--------------------+--------------------+------------+-----------+----------------------------------------------------------+----------------------------------+------------------+----------------+-------------+---------------+-------------+-----------------------+-------------+-------------------+--------------+--------+----------+---------------+-----------+---------------+-------------------------+--------------------+------------------+------------------------+--------------+--------------------+-------------+-------------------+------------+-----------+-----------+---------------+--------------------+------------------+--------------------+---------------------+ | 55 | 82699073578 | 82699073591 | statement/sql/xa_start | | 928275083504190000 | 928275083511914000 | 7724000 | 0 | XA START X'323136343732373731382d342d3130312d3131',X'',1 | 4ffe8012ab67120c12154e8be23c81ee | XA START ?, ... | abappcdd | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | +-----------+-------------+--------------+------------------------+--------+--------------------+--------------------+------------+-----------+----------------------------------------------------------+----------------------------------+------------------+----------------+-------------+---------------+-------------+-----------------------+-------------+-------------------+--------------+--------+----------+---------------+-----------+---------------+-------------------------+--------------------+------------------+------------------------+--------------+--------------------+-------------+-------------------+------------+-----------+-----------+---------------+--------------------+------------------+--------------------+---------------------+ 1 row in set (0.01 sec) mysql> select * from events_statements_history where thread_id=55; +-----------+-------------+--------------+------------------------+--------+--------------------+--------------------+------------+-----------+----------------------------------------------------------+----------------------------------+------------------+----------------+-------------+---------------+-------------+-----------------------+-------------+-------------------+--------------+--------+----------+---------------+-----------+---------------+-------------------------+--------------------+------------------+------------------------+--------------+--------------------+-------------+-------------------+------------+-----------+-----------+---------------+--------------------+------------------+--------------------+---------------------+ | THREAD_ID | EVENT_ID | END_EVENT_ID | EVENT_NAME | SOURCE | TIMER_START | TIMER_END | TIMER_WAIT | LOCK_TIME | SQL_TEXT | DIGEST | DIGEST_TEXT | CURRENT_SCHEMA | OBJECT_TYPE | OBJECT_SCHEMA | OBJECT_NAME | OBJECT_INSTANCE_BEGIN | MYSQL_ERRNO | RETURNED_SQLSTATE | MESSAGE_TEXT | ERRORS | WARNINGS | ROWS_AFFECTED | ROWS_SENT | ROWS_EXAMINED | CREATED_TMP_DISK_TABLES | CREATED_TMP_TABLES | SELECT_FULL_JOIN | SELECT_FULL_RANGE_JOIN | SELECT_RANGE | SELECT_RANGE_CHECK | SELECT_SCAN | SORT_MERGE_PASSES | SORT_RANGE | SORT_ROWS | SORT_SCAN | NO_INDEX_USED | NO_GOOD_INDEX_USED | NESTING_EVENT_ID | NESTING_EVENT_TYPE | NESTING_EVENT_LEVEL | +-----------+-------------+--------------+------------------------+--------+--------------------+--------------------+------------+-----------+----------------------------------------------------------+----------------------------------+------------------+----------------+-------------+---------------+-------------+-----------------------+-------------+-------------------+--------------+--------+----------+---------------+-----------+---------------+-------------------------+--------------------+------------------+------------------------+--------------+--------------------+-------------+-------------------+------------+-----------+-----------+---------------+--------------------+------------------+--------------------+---------------------+ | 55 | 82699072865 | 82699072875 | statement/sql/xa_end | | 928275082313997000 | 928275082319074000 | 5077000 | 0 | XA END X'323031393634343434332d342d3130312d3132',X'',1 | 312ea0514a3d7ad1b544fcfeb565ad8b | XA END ?, ... | abappcdd | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 82699072795 | TRANSACTION | 0 | | 55 | 82699073020 | 82699073031 | statement/sql/begin | | 928275082850562000 | 928275082856464000 | 5902000 | 0 | BEGIN | f57daa74a09445d1e1c496f28fe6d906 | BEGIN | abappcdd | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | | 55 | 82699073578 | 82699073591 | statement/sql/xa_start | | 928275083504190000 | 928275083511914000 | 7724000 | 0 | XA START X'323136343732373731382d342d3130312d3131',X'',1 | 4ffe8012ab67120c12154e8be23c81ee | XA START ?, ... | abappcdd | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | | 55 | 82699072100 | 82699072113 | statement/sql/xa_start | | 928275080824096000 | 928275080835123000 | 11027000 | 0 | XA START X'3637333231383135362d352d3130312d3133',X'',1 | 4ffe8012ab67120c12154e8be23c81ee | XA START ?, ... | abappcdd | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | | 55 | 82699072172 | 82699072182 | statement/sql/xa_end | | 928275080900868000 | 928275080906636000 | 5768000 | 0 | XA END X'3637333231383135362d352d3130312d3133',X'',1 | 312ea0514a3d7ad1b544fcfeb565ad8b | XA END ?, ... | abappcdd | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 82699072104 | TRANSACTION | 0 | | 55 | 82699072319 | 82699072332 | statement/sql/xa_start | | 928275081293761000 | 928275081304028000 | 10267000 | 0 | XA START X'323136343732373539392d332d3130312d3131',X'',1 | 4ffe8012ab67120c12154e8be23c81ee | XA START ?, ... | abappcdd | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | | 55 | 82699072406 | 82699072416 | statement/sql/xa_end | | 928275081442718000 | 928275081449661000 | 6943000 | 0 | XA END X'323136343732373539392d332d3130312d3131',X'',1 | 312ea0514a3d7ad1b544fcfeb565ad8b | XA END ?, ... | abappcdd | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 82699072323 | TRANSACTION | 0 | | 55 | 82699072562 | 82699072575 | statement/sql/xa_start | | 928275081743195000 | 928275081754682000 | 11487000 | 0 | XA START X'3637333231383135302d332d3130312d3133',X'',1 | 4ffe8012ab67120c12154e8be23c81ee | XA START ?, ... | abappcdd | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | | 55 | 82699072635 | 82699072645 | statement/sql/xa_end | | 928275081816819000 | 928275081821850000 | 5031000 | 0 | XA END X'3637333231383135302d332d3130312d3133',X'',1 | 312ea0514a3d7ad1b544fcfeb565ad8b | XA END ?, ... | abappcdd | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 82699072566 | TRANSACTION | 0 | | 55 | 82699072791 | 82699072804 | statement/sql/xa_start | | 928275082239544000 | 928275082251088000 | 11544000 | 0 | XA START X'323031393634343434332d342d3130312d3132',X'',1 | 4ffe8012ab67120c12154e8be23c81ee | XA START ?, ... | abappcdd | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | +-----------+-------------+--------------+------------------------+--------+--------------------+--------------------+------------+-----------+----------------------------------------------------------+----------------------------------+------------------+----------------+-------------+---------------+-------------+-----------------------+-------------+-------------------+--------------+--------+----------+---------------+-----------+---------------+-------------------------+--------------------+------------------+------------------------+--------------+--------------------+-------------+-------------------+------------+-----------+-----------+---------------+--------------------+------------------+--------------------+---------------------+ 10 rows in set (0.01 sec) mysql> select * from events_stages_current where thread_id=55; +-----------+-------------+--------------+-----------------------+--------+--------------------+--------------------+-------------------+----------------+----------------+------------------+--------------------+ | THREAD_ID | EVENT_ID | END_EVENT_ID | EVENT_NAME | SOURCE | TIMER_START | TIMER_END | TIMER_WAIT | WORK_COMPLETED | WORK_ESTIMATED | NESTING_EVENT_ID | NESTING_EVENT_TYPE | +-----------+-------------+--------------+-----------------------+--------+--------------------+--------------------+-------------------+----------------+----------------+------------------+--------------------+ | 55 | 82699073605 | NULL | stage/sql/System lock | | 928275083542092000 | 939213926539615000 | 10938842997523000 | NULL | NULL | 82699073578 | STATEMENT | +-----------+-------------+--------------+-----------------------+--------+--------------------+--------------------+-------------------+----------------+----------------+------------------+--------------------+ 1 row in set (0.00 sec) mysql> select * from events_stages_history where thread_id=55; +-----------+-------------+--------------+-----------------------------------------------------+--------+--------------------+--------------------+------------+----------------+----------------+------------------+--------------------+ | THREAD_ID | EVENT_ID | END_EVENT_ID | EVENT_NAME | SOURCE | TIMER_START | TIMER_END | TIMER_WAIT | WORK_COMPLETED | WORK_ESTIMATED | NESTING_EVENT_ID | NESTING_EVENT_TYPE | +-----------+-------------+--------------+-----------------------------------------------------+--------+--------------------+--------------------+------------+----------------+----------------+------------------+--------------------+ | 55 | 82699073566 | 82699073567 | stage/sql/System lock | | 928275083496555000 | 928275083497005000 | 450000 | NULL | NULL | 82699073020 | STATEMENT | | 55 | 82699073579 | 82699073584 | stage/sql/starting | | 928275083504311000 | 928275083510483000 | 6172000 | NULL | NULL | 82699073578 | STATEMENT | | 55 | 82699073585 | 82699073586 | stage/sql/query end | | 928275083510483000 | 928275083510762000 | 279000 | NULL | NULL | 82699073578 | STATEMENT | | 55 | 82699073587 | 82699073587 | stage/sql/closing tables | | 928275083510762000 | 928275083510891000 | 129000 | NULL | NULL | 82699073578 | STATEMENT | | 55 | 82699073588 | 82699073591 | stage/sql/freeing items | | 928275083510891000 | 928275083511855000 | 964000 | NULL | NULL | 82699073578 | STATEMENT | | 55 | 82699073599 | 82699073604 | stage/sql/Opening tables | | 928275083534232000 | 928275083542092000 | 7860000 | NULL | NULL | 82699073578 | STATEMENT | | 55 | 82699073507 | 82699073531 | stage/sql/System lock | | 928275083155912000 | 928275083414492000 | 258580000 | NULL | NULL | 82699073020 | STATEMENT | | 55 | 82699073532 | 82699073533 | stage/semisync/Waiting for semi-sync ACK from slave | | 928275083414492000 | 928275083414950000 | 458000 | NULL | NULL | 82699073020 | STATEMENT | | 55 | 82699073534 | 82699073562 | stage/sql/System lock | | 928275083414950000 | 928275083437591000 | 22641000 | NULL | NULL | 82699073020 | STATEMENT | | 55 | 82699073563 | 82699073565 | stage/sql/Waiting for an event from Coordinator | | 928275083437591000 | 928275083496555000 | 58964000 | NULL | NULL | 82699073020 | STATEMENT | +-----------+-------------+--------------+-----------------------------------------------------+--------+--------------------+--------------------+------------+----------------+----------------+------------------+--------------------+ 10 rows in set (0.00 sec) mysql> show engine innodb status\G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2021-07-09 10:02:06 0x7fc88d3f2700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 8 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 591946 srv_active, 0 srv_shutdown, 341362 srv_idle srv_master_thread log flush and writes: 933308 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 46620468 OS WAIT ARRAY INFO: signal count 218052468 RW-shared spins 0, rounds 555350529, OS waits 18731461 RW-excl spins 0, rounds 2670592691, OS waits 6484174 RW-sx spins 115154360, rounds 1660839719, OS waits 13504520 Spin rounds per wait: 555350529.00 RW-shared, 2670592691.00 RW-excl, 14.42 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 23438459182 Purge done for trx's n:o < 23438459182 undo n:o < 0 state: running but idle History list length 25 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 422086851856768, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422086851802960, not started mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422086851824848, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422086851819376, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422086851818464, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422086851817552, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422086851816640, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422086851815728, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422086851814816, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422086851813904, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422086851812992, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422086851812080, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422086851811168, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422086851810256, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422086851809344, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422086851808432, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422086851807520, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422086851806608, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422086851805696, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422086851804784, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422086851803872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 23438434536, ACTIVE 5362 sec 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 38, OS thread handle 140499344779008, query id 8912386623 Waiting for preceding transaction to commit ---TRANSACTION 23438434535, ACTIVE 5362 sec 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 37, OS thread handle 140499345049344, query id 8912386620 Waiting for preceding transaction to commit ---TRANSACTION 23438434534, ACTIVE 5362 sec 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 36, OS thread handle 140499345319680, query id 8912386619 Waiting for preceding transaction to commit ---TRANSACTION 23438434533, ACTIVE 5362 sec 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 34, OS thread handle 140499345860352, query id 8912386614 Waiting for preceding transaction to commit ---TRANSACTION 23438434532, ACTIVE 5362 sec 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 33, OS thread handle 140499346130688, query id 8912386613 Waiting for preceding transaction to commit ---TRANSACTION 23438434531, ACTIVE 5362 sec 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 32, OS thread handle 140499346401024, query id 8912386608 Waiting for preceding transaction to commit ---TRANSACTION 23438434530, ACTIVE 5362 sec 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 31, OS thread handle 140499346671360, query id 8912386607 Waiting for preceding transaction to commit ---TRANSACTION 23438434529, ACTIVE 5362 sec 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 30, OS thread handle 140499346941696, query id 8912386601 Waiting for preceding transaction to commit ---TRANSACTION 23438434528, ACTIVE 5362 sec 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 29, OS thread handle 140499347212032, query id 8912386602 Waiting for preceding transaction to commit ---TRANSACTION 23438434527, ACTIVE 5362 sec 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 28, OS thread handle 140499347482368, query id 8912386598 Waiting for preceding transaction to commit ---TRANSACTION 23438434525, ACTIVE 5362 sec 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 27, OS thread handle 140499347752704, query id 8912386592 Waiting for preceding transaction to commit ---TRANSACTION 23438434523, ACTIVE 5362 sec 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 25, OS thread handle 140499348293376, query id 8912386593 Waiting for preceding transaction to commit ---TRANSACTION 23438434521, ACTIVE 5362 sec 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 23, OS thread handle 140499348834048, query id 8912386591 Waiting for preceding transaction to commit ---TRANSACTION 23438434519, ACTIVE 5362 sec 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 24, OS thread handle 140499348563712, query id 8912386586 Waiting for preceding transaction to commit ---TRANSACTION 23438434516, ACTIVE 5362 sec 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 35, OS thread handle 140499345590016, query id 8912386582 Waiting for preceding transaction to commit ---TRANSACTION 23438434385, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 5 ---TRANSACTION 23438434380, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 3 ---TRANSACTION 23438434377, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 3 ---TRANSACTION 23438434376, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 5 ---TRANSACTION 23438434373, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 6 ---TRANSACTION 23438434370, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 5 ---TRANSACTION 23438434364, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 5 ---TRANSACTION 23438434354, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 7 ---TRANSACTION 23438434090, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 3 ---TRANSACTION 23438434089, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 4 ---TRANSACTION 23438434086, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 11 ---TRANSACTION 23438434081, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 3 ---TRANSACTION 23438434078, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 3 ---TRANSACTION 23438434077, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 2 ---TRANSACTION 23438434076, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 7 ---TRANSACTION 23438434065, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 4 ---TRANSACTION 23438434060, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 4 ---TRANSACTION 23438434057, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 6 ---TRANSACTION 23438434052, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 5 ---TRANSACTION 23438434049, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 2 ---TRANSACTION 23438434048, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 3 ---TRANSACTION 23438434043, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 3 ---TRANSACTION 23438434042, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 4 ---TRANSACTION 23438434041, ACTIVE (PREPARED) 5362 sec recovered trx 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 5 -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) I/O thread 10 state: waiting for completed aio requests (write thread) I/O thread 11 state: waiting for completed aio requests (write thread) I/O thread 12 state: waiting for completed aio requests (write thread) I/O thread 13 state: waiting for completed aio requests (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 0 4667650 OS file reads, 4518879206 OS file writes, 4392730071 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 4.00 writes/s, 4.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 11072, seg size 11074, 75190 merges merged operations: insert 212509, delete mark 15142, delete 8696 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 26559067, node heap has 0 buffer(s) Hash table size 26559067, node heap has 0 buffer(s) Hash table size 26559067, node heap has 0 buffer(s) Hash table size 26559067, node heap has 0 buffer(s) Hash table size 26559067, node heap has 0 buffer(s) Hash table size 26559067, node heap has 0 buffer(s) Hash table size 26559067, node heap has 0 buffer(s) Hash table size 26559067, node heap has 0 buffer(s) 0.00 hash searches/s, 4.00 non-hash searches/s --- LOG --- Log sequence number 17052674266375 Log flushed up to 17052674266375 Pages flushed up to 17052672657301 Last checkpoint at 17052672657292 0 pending log flushes, 0 pending chkp writes 4347544418 log i/o's done, 3.56 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 109943193600 Dictionary memory allocated 63582532 Buffer pool size 6552800 Free buffers 10240 Database pages 6542560 Old database pages 2414920 Modified db pages 311 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2578272, not young 31712586 0.00 youngs/s, 0.00 non-youngs/s Pages read 4665130, created 115392253, written 159142319 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 6542560, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 655280 Free buffers 1024 Database pages 654256 Old database pages 241492 Modified db pages 45 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 257769, not young 3216172 0.00 youngs/s, 0.00 non-youngs/s Pages read 466215, created 11537852, written 16145102 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 654256, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 655280 Free buffers 1024 Database pages 654256 Old database pages 241492 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 258112, not young 3121005 0.00 youngs/s, 0.00 non-youngs/s Pages read 466865, created 11539790, written 15712147 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 654256, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 655280 Free buffers 1024 Database pages 654256 Old database pages 241492 Modified db pages 57 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 257122, not young 3103587 0.00 youngs/s, 0.00 non-youngs/s Pages read 466473, created 11534237, written 15954569 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 654256, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 655280 Free buffers 1024 Database pages 654256 Old database pages 241492 Modified db pages 64 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 257781, not young 3225022 0.00 youngs/s, 0.00 non-youngs/s Pages read 467133, created 11531731, written 15931739 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 654256, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 655280 Free buffers 1024 Database pages 654256 Old database pages 241492 Modified db pages 52 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 258354, not young 3256542 0.00 youngs/s, 0.00 non-youngs/s Pages read 466796, created 11541483, written 16081682 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 654256, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 655280 Free buffers 1024 Database pages 654256 Old database pages 241492 Modified db pages 22 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 258305, not young 3058847 0.00 youngs/s, 0.00 non-youngs/s Pages read 467396, created 11532343, written 15747060 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 654256, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 655280 Free buffers 1024 Database pages 654256 Old database pages 241492 Modified db pages 37 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 257123, not young 3201724 0.00 youngs/s, 0.00 non-youngs/s Pages read 465439, created 11545765, written 16049162 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 654256, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 655280 Free buffers 1024 Database pages 654256 Old database pages 241492 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 258127, not young 3238964 0.00 youngs/s, 0.00 non-youngs/s Pages read 466282, created 11543826, written 15686123 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 654256, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 8 Buffer pool size 655280 Free buffers 1024 Database pages 654256 Old database pages 241492 Modified db pages 32 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 257465, not young 3150320 0.00 youngs/s, 0.00 non-youngs/s Pages read 466027, created 11540077, written 16032262 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 654256, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 9 Buffer pool size 655280 Free buffers 1024 Database pages 654256 Old database pages 241492 Modified db pages 2 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 258114, not young 3140403 0.00 youngs/s, 0.00 non-youngs/s Pages read 466504, created 11545149, written 15802473 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 654256, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=82365, Main thread ID=140499646146304, state: sleeping Number of rows inserted 4778767449, updated 3025709421, deleted 747526328, read 3773600048 0.12 inserts/s, 4.00 updates/s, 0.00 deletes/s, 4.12 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.00 sec) mysql> select * from threads where processlist_id=26; +-----------+-------------------------+------------+----------------+------------------+------------------+----------------+---------------------+------------------+-------------------+----------------------------------------------------------+------------------+------+--------------+---------+-----------------+--------------+ | THREAD_ID | NAME | TYPE | PROCESSLIST_ID | PROCESSLIST_USER | PROCESSLIST_HOST | PROCESSLIST_DB | PROCESSLIST_COMMAND | PROCESSLIST_TIME | PROCESSLIST_STATE | PROCESSLIST_INFO | PARENT_THREAD_ID | ROLE | INSTRUMENTED | HISTORY | CONNECTION_TYPE | THREAD_OS_ID | +-----------+-------------------------+------------+----------------+------------------+------------------+----------------+---------------------+------------------+-------------------+----------------------------------------------------------+------------------+------+--------------+---------+-----------------+--------------+ | 55 | thread/sql/slave_worker | FOREGROUND | 26 | dbscale_internal | 20.111.12.111 | NULL | Connect | 23510 | System lock | XA START X'323136343732373731382d342d3130312d3131',X'',1 | 51 | NULL | YES | YES | NULL | 82840 | +-----------+-------------------------+------------+----------------+------------------+------------------+----------------+---------------------+------------------+-------------------+----------------------------------------------------------+------------------+------+--------------+---------+-----------------+--------------+ 1 row in set (0.00 sec)