mysql5.7 mts_MySQL5.7 MTS work线程stack

mysql> show slave status\G

*************************** 1. row ***************************

Slave_IO_State: System lock

Master_Host:

Master_User: repl

Master_Port: xxxx

Connect_Retry: 60

Master_Log_File: mysql-bin.000056

Read_Master_Log_Pos: 384142784

Relay_Log_File: relay-log.000014

Relay_Log_Pos: 6517796

Relay_Master_Log_File: mysql-bin.000053

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: 6517623

Relay_Log_Space: 4657584528

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: 206184

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: 102121028

Master_UUID: 7eeec54f-6464-11e7-a16a-20f17c59daa2

Master_Info_File: mysql.slave_master_info

SQL_Delay: 0

SQL_Remaining_Delay: NULL

Slave_SQL_Running_State: Waiting for Slave Worker queue

Master_Retry_Count: 86400

Master_Bind:

Last_IO_Error_Timestamp:

Last_SQL_Error_Timestamp:

Master_SSL_Crl:

Master_SSL_Crlpath:

Retrieved_Gtid_Set: 7eeec54f-6464-11e7-a16a-20f17c59daa2:53936753-54857989

Executed_Gtid_Set: 7eeec54f-6464-11e7-a16a-20f17c59daa2:1-54494096,

ff8f1aa3-7431-11e6-888c-1051722626c0:42306882-42306884

Auto_Position: 1

Replicate_Rewrite_DB:

Channel_Name:

Master_TLS_Version:

---TRANSACTION 339088058, ACTIVE 43636 sec setting auto-inc lock

mysql tables in use 1, locked 1

1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 7842577

MySQL thread id 16, OS thread handle 140560924931840, query id 38813829 System lock

--------

mysql> select * frominformation_schema.innodb_trx\G*************************** 1. row ***************************trx_id:339088058trx_state: RUNNING

trx_started:2017-11-03 20:53:34trx_requested_lock_id:NULLtrx_wait_started:NULLtrx_weight:7846747trx_mysql_thread_id:16trx_query:NULLtrx_operation_state: setting auto-inc lock

trx_tables_in_use:1trx_tables_locked:1trx_lock_structs:1trx_lock_memory_bytes:1136trx_rows_locked:0trx_rows_modified:7846746trx_concurrency_tickets:0trx_isolation_level:READ COMMITTEDtrx_unique_checks:1trx_foreign_key_checks:1trx_last_foreign_key_error:NULLtrx_adaptive_hash_latched:0trx_adaptive_hash_timeout:0trx_is_read_only:0trx_autocommit_non_locking:0

1 row in set (0.00sec)

mysql>show processlist;+------+-------------+--------------------+-------------------+---------+--------+---------------------------------------+------------------+

| Id | User | Host | db | Command | Time | State | Info |

+------+-------------+--------------------+-------------------+---------+--------+---------------------------------------+------------------+

| 14 | system user | | NULL | Connect | 155776 | Waiting for master to send event | NULL |

| 15 | system user | | NULL | Connect | 0 | Waiting for Slave Worker queue | NULL |

| 16 | system user | | NULL | Connect | 209694 | System lock | NULL |

| 17 | system user | | NULL | Connect | 207404 | Waiting for an event from Coordinator | NULL |

| 18 | system user | | NULL | Connect | 213656 | Waiting for an event from Coordinator | NULL |

| 19 | system user | | NULL | Connect | 217230 | Waiting for an event from Coordinator | NULL |

| 1519 | checksum | || Sleep | 1 | | NULL |

| 1628 | root | localhost | NULL | Query | 0 | starting | show processlist |

+------+-------------+--------------------+-------------------+---------+--------+---------------------------------------+------------------+

8 rows in set (0.00 sec)