今天遇到了一个很奇怪的问题，mysql版本是5.7.17的。zabbix监控提示从库复制进程断开了，登上去看，确实有报1213错，看了一下这个报错的原因是因为有死锁，重试了10次之后就报错了，可以通过
今天遇到了一个很奇怪的问题，mysql版本是5.7.17的。zabbix监控提示从库复制进程断开了，登上去看，确实有报1213错，看了一下这个报错的原因是因为有死锁，重试了10次之后就报错了，可以通过设置slave_transaction_retries参数调整重试次数。
本来我是想把这个参数调大一些然后执行stop slave;start slave的，但是结果在stop slave的时候就卡住不动了。
这个问题有两个点我不明白：1就是为什么从库应用relaylog也会有死锁，2是为什么stop slave的时候会一直卡着。
最后这个问题是没有找到解决方法的，后面只能把mysql服务给重启了。这里面把相关信息贴出来，万一大家谁知道原因或者有解决方法麻烦告知。
show slave status的信息：
>show slave status/G*************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 10.16.0.114 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.085300 Read_Master_Log_Pos: 234532837 Relay_Log_File: relay-bin.254644 Relay_Log_Pos: 431048844 Relay_Master_Log_File: mysql-bin.085209 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: 1213 Last_Error: worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Skip_Counter: 0 Exec_Master_Log_Pos: 431048631 Relay_Log_Space: 55543637112 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: 10906Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 1213 Last_SQL_Error: worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Replicate_Ignore_Server_Ids: Master_Server_Id: 22629 Master_UUID: 3fdc55ff-fcb7-11e6-a264-1866daf3cc48 Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Waiting for workers to exit Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: 180615 12:00:21 Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: Executed_Gtid_Set: Auto_Position: 0 Replicate_Rewrite_DB: Channel_Name: Master_TLS_Version: 1 row in set (0.00 sec)
查看mysql错误日志：
2018-06-15T11:59:47.565750+08:00 359460654 [Warning] Slave SQL for channel '': Worker 17 failed executing transaction 'ANONYMOUS' at master log mysql-bin.085209, end_log_pos 431248932; Could not execute Write_rows event on table sa_db.listing_attr; Deadlock found when trying to get lock; try restarting transaction, Error_code: 1213; handler error HA_ERR_LOCK_DEADLOCK; the event's master log mysql-bin.085209, end_log_pos 431248932, Error_code: 1213
show processlist信息：
admin@(none) 12:49>show processlist;+-----------+-------------+---------------------+------+---------+-------+---------------------------------------------+------------------------------------------------------------------------------------------------------+-----------+---------------+| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined |+-----------+-------------+---------------------+------+---------+-------+---------------------------------------------+------------------------------------------------------------------------------------------------------+-----------+---------------+| 358474342 | admin | localhost | NULL | Query | 2558 | Killing slave | stop slave | 0 | 0 || 359460634 | system user | | NULL | Connect | 4728 | Waiting for master to send event | NULL | 0 | 0 || 359460635 | system user | | NULL | Connect | 2991 | Waiting for workers to exit | NULL | 0 | 0 || 359460636 | system user | | NULL | Connect | 10911 | Waiting for preceding transaction to commit | NULL | 0 | 0 || 359460637 | system user | | NULL | Connect | 10912 | Waiting for preceding transaction to commit | NULL | 0 | 0 || 359460639 | system user | | NULL | Connect | 10911 | Waiting for preceding transaction to commit | NULL | 0 | 0 || 359460640 | system user | | NULL | Connect | 10911 | Waiting for preceding transaction to commit | NULL | 0 | 0 || 359460641 | system user | | NULL | Connect | 10911 | Waiting for preceding transaction to commit | NULL | 0 | 0 || 359460642 | system user | | NULL | Connect | 10912 | Waiting for preceding transaction to commit | NULL | 0 | 0 || 359460643 | system user | | NULL | Connect | 10912 | Waiting for preceding transaction to commit | NULL | 0 | 0 || 359460644 | system user | | NULL | Connect | 10912 | Waiting for preceding transaction to commit | NULL | 0 | 0 || 359460645 | system user | | NULL | Connect | 10912 | Waiting for preceding transaction to commit | NULL | 0 | 0 || 359460646 | system user | | NULL | Connect | 10912 | Waiting for preceding transaction to commit | NULL | 0 | 0 || 359460647 | system user | | NULL | Connect | 10911 | Waiting for preceding transaction to commit | NULL | 0 | 0 || 359460661 | system user | | NULL | Connect | 10912 | Waiting for preceding transaction to commit | NULL | 0 | 0 || 359460662 | system user | | NULL | Connect | 10912 | Waiting for preceding transaction to commit | NULL | 0 | 0 || 359460663 | system user | | NULL | Connect | 10912 | Waiting for preceding transaction to commit | NULL | 0 | 0 || 359460664 | system user | | NULL | Connect | 10912 | Waiting for preceding transaction to commit | NULL | 0 | 0 || 359460665 | system user | | NULL | Connect | 10912 | Waiting for preceding transaction to commit | NULL | 0 | 0 || 359460666 | system user | | NULL | Connect | 10912 | Waiting for preceding transaction to commit | NULL | 0 | 0 || 359460667 | system user | | NULL | Connect | 10911 | Waiting for preceding transaction to commit | NULL | 0 | 0 || 359460668 | system user | | NULL | Connect | 10911 | Waiting for preceding transaction to commit | NULL | 0 | 0 |+-----------+-------------+---------------------+------+---------+-------+---------------------------------------------+--------------------------------------------------------------------------------------------------------------------------+-----------+---------------+
查看show engine innodb status的信息：
>show engine innodb status/G*************************** 1. row *************************** Type: InnoDB Name: Status: =====================================2018-06-15 13:46:10 0x7fc35269b700 INNODB MONITOR OUTPUT=====================================Per second averages calculated from the last 11 seconds-----------------BACKGROUND THREAD-----------------srv_master_thread loops: 7231342 srv_active, 0 srv_shutdown, 88148 srv_idlesrv_master_thread log flush and writes: 7319490----------SEMAPHORES----------OS WAIT ARRAY INFO: reservation count 846771560OS WAIT ARRAY INFO: signal count 11704563703RW-shared spins 0, rounds 7828610474, OS waits 306123779RW-excl spins 0, rounds 22442385026, OS waits 261543286RW-sx spins 519882803, rounds 11033550791, OS waits 144313611Spin rounds per wait: 7828610474.00 RW-shared, 22442385026.00 RW-excl, 21.22 RW-sx------------------------LATEST DETECTED DEADLOCK------------------------2018-06-15 12:00:21 0x7fc3b4120700*** (1) TRANSACTION:TRANSACTION 25206635187, ACTIVE 0 sec insertingmysql tables in use 1, locked 1LOCK WAIT 5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 3MySQL thread id 359460638, OS thread handle 140476847380224, query id 19188924556 System lockINSERT INTO `listing_attr` (`attr_name`, `attr_value`, `listing_id`) VALUES ('feature', 'Chronograph', '3833594')*** (1) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 23792 page no 70501 n bits 352 index uniq_listing_id_attr_name_attr_value of table `sa_db`.`listing_attr` trx id 25206635187 lock_mode X insert intention waiting*** (2) TRANSACTION:TRANSACTION 25206635184, ACTIVE 0 sec insertingmysql tables in use 1, locked 18 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 3MySQL thread id 359460659, OS thread handle 140478516430592, query id 19188924526 System lockINSERT INTO `listing_attr` (`attr_name`, `attr_value`, `listing_id`) VALUES ('material_type', 'Metal', '3833593')*** (2) HOLDS THE LOCK(S):RECORD LOCKS space id 23792 page no 70501 n bits 352 index uniq_listing_id_attr_name_attr_value of table `sa`.`listing_attr` trx id 25206635184 lock_mode X*** (2) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 23792 page no 70501 n bits 352 index uniq_listing_id_attr_name_attr_value of table `sa_db`.`listing_attr` trx id 25206635184 lock_mode X insert intention waiting*** WE ROLL BACK TRANSACTION (1)------------TRANSACTIONS------------Trx id counter 25206645739Purge done for trx's n:o < 25206645738 undo n:o < 0 state: running but idleHistory list length 25LIST OF TRANSACTIONS FOR EACH SESSION:---TRANSACTION 422158513818552, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513813784, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513714848, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513799480, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513742264, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513782792, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513768488, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513757760, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513716040, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513775640, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513736304, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513769680, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513767296, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513743456, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513701736, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513763720, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513717232, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513729152, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513723192, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513712464, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513900800, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513896032, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513879344, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513834048, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513741072, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513710080, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513830472, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513707696, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513909144, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513899608, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513809016, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513797096, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513774448, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513744648, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513832856, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513776832, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513787560, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513810208, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513891264, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513722000, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513725576, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513907952, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513803056, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513876960, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513745840, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513792328, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513760144, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513773256, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513732728, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513702928, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513811400, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513794712, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513917488, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513692200, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513881728, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513861464, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513758952, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513783984, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513699352, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513708888, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513918680, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513798288, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513955632, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513916296, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513756568, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513755376, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513770872, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513820936, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513705312, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513724384, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513800672, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513737496, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513700544, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513940136, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513738688, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513903184, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513880536, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513956824, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513950864, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513762528, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513835240, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513786368, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513847160, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513795904, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513695776, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513857888, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513730344, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513842392, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513733920, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513828088, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513954440, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513853120, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513823320, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513793520, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513931792, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513698160, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513966360, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513905568, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513886496, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513772064, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513752992, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513921064, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513801864, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513867424, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513855504, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513719616, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513739880, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513754184, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513817360, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513814976, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513869808, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513845968, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513812592, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513804248, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513748224, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513706504, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513696968, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513884112, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513915104, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513807824, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513851928, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513718424, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513840008, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513788752, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513969936, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513822128, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513781600, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513764912, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513947288, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513727960, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513944904, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513850736, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513952056, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513859080, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513948480, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513923448, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513932984, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513927024, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513924640, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513720808, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513912720, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513882920, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513901992, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513894840, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513890072, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513887688, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513863848, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513831664, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513843584, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513856696, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513897224, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513704120, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513866232, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513816168, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513836432, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513875768, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513873384, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513844776, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513868616, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513779216, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513838816, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513694584, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513789944, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513691008, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513735112, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513906760, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513780408, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513898416, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513865040, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513862656, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513860272, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513841200, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513825704, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513766104, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513986624, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158514034304, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513805440, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513941328, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513791136, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513935368, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513749416, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513711272, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513726768, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513967552, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513806632, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513911528, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513946096, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513785176, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513953248, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513930600, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513848352, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513997352, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158514014040, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158514028344, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513829280, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513761336, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513871000, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513819744, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513750608, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513826896, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513731536, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513713656, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513747032, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513751800, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513928216, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158514101056, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513778024, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158514134432, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158514070064, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158514239328, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158514090328, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513874576, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513885304, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513949672, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 422158513922256, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 25206635188, ACTIVE (PREPARED) 6349 sec19 lock struct(s), heap size 1136, 5 row lock(s), undo log entries 25MySQL thread id 359460644, OS thread handle 140457942128384, query id 19188924615 Waiting for preceding transaction to commit---TRANSACTION 25206635001, ACTIVE (PREPARED) 6389 sec4 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 2MySQL thread id 359460647, OS thread handle 140476127819520, query id 19188888488 Waiting for preceding transaction to commit---TRANSACTION 25206635000, ACTIVE (PREPARED) 6389 sec4 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 2MySQL thread id 359460646, OS thread handle 140457941063424, query id 19188888485 Waiting for preceding transaction to commit---TRANSACTION 25206634999, ACTIVE (PREPARED) 6389 sec4 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 2MySQL thread id 359460645, OS thread handle 140476522751744, query id 19188888467 Waiting for preceding transaction to commit---TRANSACTION 25206634997, ACTIVE (PREPARED) 6389 sec4 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 2MySQL thread id 359460637, OS thread handle 140476856698624, query id 19188888447 Waiting for preceding transaction to commit---TRANSACTION 25206634996, ACTIVE (PREPARED) 6389 sec17 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 25MySQL thread id 359460643, OS thread handle 140472954726144, query id 19188888496 Waiting for preceding transaction to commit---TRANSACTION 25206634995, ACTIVE (PREPARED) 6389 sec4 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 2MySQL thread id 359460642, OS thread handle 140476502783744, query id 19188888449 Waiting for preceding transaction to commit---TRANSACTION 25206634994, ACTIVE (PREPARED) 6389 sec4 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 2MySQL thread id 359460641, OS thread handle 140476845782784, query id 19188888445 Waiting for preceding transaction to commit---TRANSACTION 25206634986, ACTIVE (PREPARED) 6389 sec4 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 2MySQL thread id 359460640, OS thread handle 140472952862464, query id 19188888443 Waiting for preceding transaction to commit---TRANSACTION 25206634982, ACTIVE (PREPARED) 6389 sec4 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 2MySQL thread id 359460636, OS thread handle 140476391462656, query id 19188888354 Waiting for preceding transaction to commit---TRANSACTION 25206634981, ACTIVE (PREPARED) 6389 sec4 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 2MySQL thread id 359460639, OS thread handle 140478520157952, query id 19188888350 Waiting for preceding transaction to commit---TRANSACTION 25206634980, ACTIVE (PREPARED) 6389 sec4 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 2MySQL thread id 359460668, OS thread handle 140473105733376, query id 19188888346 Waiting for preceding transaction to commit---TRANSACTION 25206634979, ACTIVE (PREPARED) 6389 sec4 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 2MySQL thread id 359460667, OS thread handle 140476123293440, query id 19188888348 Waiting for preceding transaction to commit---TRANSACTION 25206634978, ACTIVE (PREPARED) 6389 sec4 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 2MySQL thread id 359460666, OS thread handle 140476863088384, query id 19188888347 Waiting for preceding transaction to commit---TRANSACTION 25206634977, ACTIVE (PREPARED) 6389 sec4 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 2MySQL thread id 359460665, OS thread handle 140476117169920, query id 19188888342 Waiting for preceding transaction to commit---TRANSACTION 25206634976, ACTIVE (PREPARED) 6389 sec4 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 2MySQL thread id 359460663, OS thread handle 140476128884480, query id 19188888340 Waiting for preceding transaction to commit---TRANSACTION 25206634975, ACTIVE (PREPARED) 6389 sec7 lock struct(s), heap size 1136, 42 row lock(s), undo log entries 42MySQL thread id 359460664, OS thread handle 140476373092096, query id 19188888436 Waiting for preceding transaction to commit---TRANSACTION 25206634974, ACTIVE (PREPARED) 6389 sec8 lock struct(s), heap size 1136, 6 row lock(s), undo log entries 11MySQL thread id 359460662, OS thread handle 140476879075072, query id 19188888377 Waiting for preceding transaction to commit---TRANSACTION 25206634973, ACTIVE (PREPARED) 6389 sec4 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 2MySQL thread id 359460661, OS thread handle 140476534732544, query id 19188888333 Waiting for preceding transaction to commit--------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 (read thread)I/O thread 7 state: waiting for completed aio requests (read thread)I/O thread 8 state: waiting for completed aio requests (read thread)I/O thread 9 state: waiting for completed aio requests (read 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)I/O thread 14 state: waiting for completed aio requests (write thread)I/O thread 15 state: waiting for completed aio requests (write thread)I/O thread 16 state: waiting for completed aio requests (write thread)I/O thread 17 state: waiting for completed aio requests (write thread)Pending normal aio reads: [0, 0, 0, 0, 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: 03574401789 OS file reads, 8061396199 OS file writes, 806486390 OS fsyncs0.09 reads/s, 16384 avg bytes/read, 1.18 writes/s, 1.00 fsyncs/s-------------------------------------INSERT BUFFER AND ADAPTIVE HASH INDEX-------------------------------------Ibuf: size 1, free list len 71849, seg size 71851, 55301491 mergesmerged operations: insert 288907720, delete mark 773091127, delete 204671161discarded operations: insert 0, delete mark 0, delete 0Hash table size 47806243, node heap has 136268 buffer(s)Hash table size 47806243, node heap has 108016 buffer(s)Hash table size 47806243, node heap has 54129 buffer(s)Hash table size 47806243, node heap has 37719 buffer(s)Hash table size 47806243, node heap has 77914 buffer(s)Hash table size 47806243, node heap has 33337 buffer(s)Hash table size 47806243, node heap has 46262 buffer(s)Hash table size 47806243, node heap has 27054 buffer(s)951565.22 hash searches/s, 10784.29 non-hash searches/s---LOG---Log sequence number 21099156043309Log flushed up to 21099156042961Pages flushed up to 21099156038721Last checkpoint at 21099156038712Max checkpoint age 1738750649Checkpoint age target 1684414692Modified age 4588Checkpoint age 45970 pending log flushes, 0 pending chkp writes5141910426 log i/o's done, 1.18 log i/o's/second----------------------BUFFER POOL AND MEMORY----------------------Total large memory allocated 201200762880Dictionary memory allocated 14265079Internal hash tables (constant factor + variable factor) Adaptive hash index 11590765632 (3059599552 + 8531166080) Page hash 19123288 (buffer pool 0 only) Dictionary cache 779164967 (764899888 + 14265079) File system 1348408 (812272 + 536136) Lock system 478389800 (478120568 + 269232) Recovery system 0 (0 + 0)Buffer pool size 11795040Buffer pool size, bytes 0Free buffers 10240Database pages 11264101Old database pages 4157831Modified db pages 47Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 411856925, not young 311403533460.82 youngs/s, 0.09 non-youngs/sPages read 3575086752, created 101520215, written 28420790790.09 reads/s, 0.00 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 11264101, unzip_LRU len: 0I/O sum[2170]:cur[0], unzip sum[0]:cur[0]----------------------INDIVIDUAL BUFFER POOL INFO-------------------------BUFFER POOL 0Buffer pool size 1179504Buffer pool size, bytes 0Free buffers 1024Database pages 1126196Old database pages 415704Modified db pages 13Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 41011848, not young 31034911890.09 youngs/s, 0.00 non-youngs/sPages read 357667649, created 10049656, written 2867035180.00 reads/s, 0.00 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 1126196, unzip_LRU len: 0I/O sum[217]:cur[0], unzip sum[0]:cur[0]---BUFFER POOL 1Buffer pool size 1179504Buffer pool size, bytes 0Free buffers 1023Database pages 1126472Old database pages 415806Modified db pages 0Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 41171092, not young 30965216840.18 youngs/s, 0.00 non-youngs/sPages read 357199786, created 10056942, written 2809625780.00 reads/s, 0.00 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 1126472, unzip_LRU len: 0I/O sum[217]:cur[0], unzip sum[0]:cur[0]---BUFFER POOL 2Buffer pool size 1179504Buffer pool size, bytes 0Free buffers 1024Database pages 1126341Old database pages 415758Modified db pages 5Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 41307053, not young 31263070580.00 youngs/s, 0.00 non-youngs/sPages read 357640651, created 10046742, written 2870204060.00 reads/s, 0.00 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 1126341, unzip_LRU len: 0I/O sum[217]:cur[0], unzip sum[0]:cur[0]---BUFFER POOL 3Buffer pool size 1179504Buffer pool size, bytes 0Free buffers 1024Database pages 1126454Old database pages 415799Modified db pages 0Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 40889319, not young 31666404950.09 youngs/s, 0.00 non-youngs/sPages read 357411673, created 10063744, written 2813655290.00 reads/s, 0.00 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 1126454, unzip_LRU len: 0I/O sum[217]:cur[0], unzip sum[0]:cur[0]---BUFFER POOL 4Buffer pool size 1179504Buffer pool size, bytes 0Free buffers 1024Database pages 1126440Old database pages 415794Modified db pages 9Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 41262103, not young 31385041670.00 youngs/s, 0.09 non-youngs/sPages read 357297882, created 10008005, written 2878028040.09 reads/s, 0.00 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 1126440, unzip_LRU len: 0I/O sum[217]:cur[0], unzip sum[0]:cur[0]---BUFFER POOL 5Buffer pool size 1179504Buffer pool size, bytes 0Free buffers 1024Database pages 1126405Old database pages 415781Modified db pages 0Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 41152454, not young 31069860140.09 youngs/s, 0.00 non-youngs/sPages read 357456916, created 10190489, written 2800978660.00 reads/s, 0.00 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 1126405, unzip_LRU len: 0I/O sum[217]:cur[0], unzip sum[0]:cur[0]---BUFFER POOL 6Buffer pool size 1179504Buffer pool size, bytes 0Free buffers 1025Database pages 1126539Old database pages 415831Modified db pages 0Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 40891794, not young 31141066360.00 youngs/s, 0.00 non-youngs/sPages read 357256406, created 10245285, written 2884698940.00 reads/s, 0.00 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 1126539, unzip_LRU len: 0I/O sum[217]:cur[0], unzip sum[0]:cur[0]---BUFFER POOL 7Buffer pool size 1179504Buffer pool size, bytes 0Free buffers 1024Database pages 1126529Old database pages 415827Modified db pages 0Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 41235464, not young 30581405520.18 youngs/s, 0.00 non-youngs/sPages read 357481690, created 10281301, written 2814716470.00 reads/s, 0.00 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 1126529, unzip_LRU len: 0I/O sum[217]:cur[0], unzip sum[0]:cur[0]---BUFFER POOL 8Buffer pool size 1179504Buffer pool size, bytes 0Free buffers 1024Database pages 1126450Old database pages 415798Modified db pages 20Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 41558814, not young 31317384360.00 youngs/s, 0.00 non-youngs/sPages read 358112298, created 10289390, written 2883915970.00 reads/s, 0.00 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 1126450, unzip_LRU len: 0I/O sum[217]:cur[0], unzip sum[0]:cur[0]---BUFFER POOL 9Buffer pool size 1179504Buffer pool size, bytes 0Free buffers 1024Database pages 1126275Old database pages 415733Modified db pages 0Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 41376984, not young 30979171150.18 youngs/s, 0.00 non-youngs/sPages read 357561801, created 10288661, written 2797932400.00 reads/s, 0.00 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 1126275, unzip_LRU len: 0I/O sum[217]:cur[0], unzip sum[0]:cur[0]--------------ROW OPERATIONS--------------0 queries inside InnoDB, 0 queries in queue3 read views open inside InnoDB19 RW transactions active inside InnoDB---OLDEST VIEW---Read view low limit trx n:o 25206645737Trx read view will not see trx with id >= 25206645737, sees < 25206634973Read view individually stored trx ids:Read view trx id 25206634973Read view trx id 25206634974Read view trx id 25206634975Read view trx id 25206634976Read view trx id 25206634977Read view trx id 25206634978Read view trx id 25206634979Read view trx id 25206634980Read view trx id 25206634981Read view trx id 25206634982Read view trx id 25206634986Read view trx id 25206634994Read view trx id 25206634995Read view trx id 25206634996Read view trx id 25206634997Read view trx id 25206634999Read view trx id 25206635000Read view trx id 25206635001Read view trx id 25206635188-----------------Process ID=87482, Main thread ID=140478837442304, state: sleepingNumber of rows inserted 6704792171, updated 9374134411, deleted 4105847387, read 3760268817707762.09 inserts/s, 1.18 updates/s, 0.00 deletes/s, 1250329.42 reads/s----------------------------END OF INNODB MONITOR OUTPUT============================
查看复制进程对应的系统进程id号：
>select * from threads where PROCESSLIST_ID=359460661/G*************************** 1. row *************************** THREAD_ID: 359460707 NAME: thread/sql/slave_worker TYPE: FOREGROUND PROCESSLIST_ID: 359460661 PROCESSLIST_USER: admin PROCESSLIST_HOST: localhost PROCESSLIST_DB: NULLPROCESSLIST_COMMAND: Connect PROCESSLIST_TIME: 18662 PROCESSLIST_STATE: Waiting for preceding transaction to commit PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 359460681 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 171298
查看这个进程的堆栈:
# pstack 171298Thread 1 (process 171298):#0 0x00007ff37cd7868c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0#1 0x0000000000f1c7d6 in Commit_order_manager::wait_for_its_turn(Slave_worker*, bool) ()#2 0x0000000000ee0b35 in MYSQL_BIN_LOG::ordered_commit(THD*, bool, bool) ()#3 0x0000000000ee160b in MYSQL_BIN_LOG::commit(THD*, bool) ()#4 0x0000000000821a24 in ha_commit_trans(THD*, bool, bool) ()#5 0x0000000000dcf719 in trans_commit(THD*) ()#6 0x0000000000eb691b in Xid_log_event::do_commit(THD*) ()#7 0x0000000000eb6823 in Xid_apply_log_event::do_apply_event_worker(Slave_worker*) ()#8 0x0000000000f1a585 in slave_worker_exec_job_group(Slave_worker*, Relay_log_info*) ()#9 0x0000000000f03b13 in handle_slave_worker ()#10 0x0000000001253254 in pfs_spawn_thread ()#11 0x00007ff37cd74aa1 in start_thread () from /lib64/libpthread.so.0#12 0x00007ff37b276aad in ioperm () from /lib64/libc.so.6#13 0x0000000000000000 in ?? ()
