阅读MySql死锁日志

àì夳堔傛蜴生んèń 2023-03-14 08:06 76阅读 0赞

*************************** 1. row ***************************
      Type: InnoDB
      Name: 
    Status: 
    =====================================
    2020-03-30 14:07:35 0x4d68 INNODB MONITOR OUTPUT
    =====================================
    Per second averages calculated from the last 19 seconds
    -----------------
    BACKGROUND THREAD
    -----------------
    srv_master_thread loops: 628 srv_active, 0 srv_shutdown, 1134509 srv_idle
    srv_master_thread log flush and writes: 1135130
    ----------
    SEMAPHORES
    ----------
    OS WAIT ARRAY INFO: reservation count 1342
    OS WAIT ARRAY INFO: signal count 1294
    RW-shared spins 0, rounds 1982, OS waits 918
    RW-excl spins 0, rounds 1303, OS waits 33
    RW-sx spins 36, rounds 700, OS waits 20
    Spin rounds per wait: 1982.00 RW-shared, 1303.00 RW-excl, 19.44 RW-sx
    ------------------------
    LATEST DETECTED DEADLOCK
    ------------------------
    2020-03-30 10:58:07 0x4d68
    *** (1) TRANSACTION:   #事务1
    TRANSACTION 86155, ACTIVE 1 sec fetching rows
    # 事务ID 86155，活跃1s，
    # fetching rows 获取行数据
    # 其它的状态：starting index read 根据索引读取数据；inserting、updating、deleting
    mysql tables in use 1, locked 1
    # 一个表被使用，一个表锁
    LOCK WAIT 4 lock struct(s), heap size 1136, 64 row lock(s)
    # LOCK WAIT：事务正在等待锁，
    # 4 lock struct(s)：该事务的锁链表长度为4，每个链表节点代表该事务持有的一个锁结构，包括表锁，记录锁以及 autoinc 锁等
    # head size 1136：为事务分配的锁堆内存大小
    # 64 row lock(s)：表示当前事务持有的行锁个数, 通过遍历上边的4个锁结构、找到其中类型为LOCK_REC的记录数
    MySQL thread id 162285, OS thread handle 9248, query id 2370982 localhost 127.0.0.1 root updating   #事务线程信息
    delete from T_EBG_FRONT_Detail   where  ( pay_Bank_Version = 'HSBC_DC'  and  detail_File_Name =  'MT942CN.FO821.010213434573.626157390011.TXT'  )   #正在执行的sql语句
    *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
    RECORD LOCKS space id 162 page no 10 n bits 128 index PRIMARY of table "ebg850"."t_ebg_front_detail" trx id 86155 lock_mode X waiting
    # 表示记录锁，space id 162,page号为10，正在等待表t_ebg_front_detail的X锁(next-key)
    # 记录锁（LOCK_REC_NOT_GAP）: lock_mode X locks rec but not gap
    # 间隙锁（LOCK_GAP）: lock_mode X locks gap before rec
    # Next-key 锁（LOCK_ORNIDARY）: lock_mode X
    # 插入意向锁（LOCK_INSERT_INTENTION）: lock_mode X locks gap before rec insert intention
    Record lock, heap no 21 PHYSICAL RECORD: n_fields 35; compact format; info bits 32
     0: len 16; hex 36343934333534393934363032313033; asc 6494354994602103;;
     1: len 6; hex 00000001508e; asc     P ;;
     2: len 7; hex 51000002792d62; asc Q   y-b;;
     3: len 11; hex 3434373131323130343232; asc 44711210422;;
     4: len 23; hex 434e204d454e474e495520444149525920434f204c5444; asc CN MENGNIU DAIRY CO LTD;;
     5: SQL NULL;
     6: len 7; hex 5343425f483248; asc SCB_H2H;;
     7: len 0; hex ; asc ;;
     8: len 0; hex ; asc ;;
     9: len 0; hex ; asc ;;
     10: len 30; hex 47434e41313538372e5245504f525453435553542e323031393039323131; asc GCNA1587.REPORTSCUST.201909211; (total 44 bytes);
     11: SQL NULL;
     12: SQL NULL;
     13: len 3; hex 484b44; asc HKD;;
     14: len 9; hex 800000000000076161; asc        aa;;
     15: len 9; hex 80000000004a375e05; asc      J7^ ;;
     16: len 5; hex 4445424954; asc DEBIT;;
     17: len 5; hex 99a428985e; asc   ( ^;;
     18: SQL NULL;
     19: SQL NULL;
     20: SQL NULL;
     21: SQL NULL;
     22: SQL NULL;
     23: SQL NULL;
     24: len 30; hex 53434e313835393544303030303635392d30303030312032303139303932; asc SCN18595D0000659-00001 2019092; (total 105 bytes);
     25: len 0; hex ; asc ;;
     26: SQL NULL;
     27: SQL NULL;
     28: SQL NULL;
     29: SQL NULL;
     30: SQL NULL;
     31: len 29; hex 392d303030303120323031393039323030393333323720202020737473; asc 9-00001 20190920093327    sts;;
     32: SQL NULL;
     33: SQL NULL;
     34: SQL NULL;
    
    *** (2) TRANSACTION:   #s事务2
    TRANSACTION 86158, ACTIVE 1 sec starting index read
    # 事务ID为86158，活跃1s，正在根据索引读取数据
    mysql tables in use 1, locked 1
    # 一个表被使用，一个表锁
    5 lock struct(s), heap size 1136, 16 row lock(s), undo log entries 6
    MySQL thread id 162283, OS thread handle 19816, query id 2371114 localhost 127.0.0.1 root updating
    delete from T_EBG_FRONT_Detail  where (pay_Acc_No =  '501510404397' and pay_Bank_Version = 'SCB_H2H' and  tx_Date between '2019-09-20 00:00:00' and  '2019-09-20 23:59:59')
    *** (2) HOLDS THE LOCK(S):
    RECORD LOCKS space id 162 page no 10 n bits 128 index PRIMARY of table "ebg850"."t_ebg_front_detail" trx id 86158 lock_mode X locks rec but not gap
    Record lock, heap no 21 PHYSICAL RECORD: n_fields 35; compact format; info bits 32
     0: len 16; hex 36343934333534393934363032313033; asc 6494354994602103;;
     1: len 6; hex 00000001508e; asc     P ;;
     2: len 7; hex 51000002792d62; asc Q   y-b;;
     3: len 11; hex 3434373131323130343232; asc 44711210422;;
     4: len 23; hex 434e204d454e474e495520444149525920434f204c5444; asc CN MENGNIU DAIRY CO LTD;;
     5: SQL NULL;
     6: len 7; hex 5343425f483248; asc SCB_H2H;;
     7: len 0; hex ; asc ;;
     8: len 0; hex ; asc ;;
     9: len 0; hex ; asc ;;
     10: len 30; hex 47434e41313538372e5245504f525453435553542e323031393039323131; asc GCNA1587.REPORTSCUST.201909211; (total 44 bytes);
     11: SQL NULL;
     12: SQL NULL;
     13: len 3; hex 484b44; asc HKD;;
     14: len 9; hex 800000000000076161; asc        aa;;
     15: len 9; hex 80000000004a375e05; asc      J7^ ;;
     16: len 5; hex 4445424954; asc DEBIT;;
     17: len 5; hex 99a428985e; asc   ( ^;;
     18: SQL NULL;
     19: SQL NULL;
     20: SQL NULL;
     21: SQL NULL;
     22: SQL NULL;
     23: SQL NULL;
     24: len 30; hex 53434e313835393544303030303635392d30303030312032303139303932; asc SCN18595D0000659-00001 2019092; (total 105 bytes);
     25: len 0; hex ; asc ;;
     26: SQL NULL;
     27: SQL NULL;
     28: SQL NULL;
     29: SQL NULL;
     30: SQL NULL;
     31: len 29; hex 392d303030303120323031393039323030393333323720202020737473; asc 9-00001 20190920093327    sts;;
     32: SQL NULL;
     33: SQL NULL;
     34: SQL NULL;
    
    Record lock, heap no 22 PHYSICAL RECORD: n_fields 35; compact format; info bits 32
     0: len 16; hex 36343934333534393934363036323030; asc 6494354994606200;;
     1: len 6; hex 00000001508e; asc     P ;;
     2: len 7; hex 51000002792db8; asc Q   y- ;;
     3: len 11; hex 3434373131323130343232; asc 44711210422;;
     4: len 23; hex 434e204d454e474e495520444149525920434f204c5444; asc CN MENGNIU DAIRY CO LTD;;
     5: SQL NULL;
     6: len 7; hex 5343425f483248; asc SCB_H2H;;
     7: len 0; hex ; asc ;;
     8: len 0; hex ; asc ;;
     9: len 0; hex ; asc ;;
     10: len 30; hex 47434e41313538372e5245504f525453435553542e323031393039323131; asc GCNA1587.REPORTSCUST.201909211; (total 44 bytes);
     11: SQL NULL;
     12: SQL NULL;
     13: len 3; hex 484b44; asc HKD;;
     14: len 9; hex 80000000000005dc00; asc          ;;
     15: len 9; hex 80000000004a375e05; asc      J7^ ;;
     16: len 5; hex 4445424954; asc DEBIT;;
     17: len 5; hex 99a428c6e6; asc   (  ;;
     18: SQL NULL;
     19: SQL NULL;
     20: SQL NULL;
     21: SQL NULL;
     22: SQL NULL;
     23: SQL NULL;
     24: len 30; hex 53484b343331343143303030303730392d30303030312020202020202020; asc SHK43141C0000709-00001        ; (total 105 bytes);
     25: len 0; hex ; asc ;;
     26: SQL NULL;
     27: SQL NULL;
     28: SQL NULL;
     29: SQL NULL;
     30: SQL NULL;
     31: len 29; hex 392d303030303120202020202020202020202020202020202020737473; asc 9-00001                   sts;;
     32: SQL NULL;
     33: SQL NULL;
     34: SQL NULL;
    
    Record lock, heap no 23 PHYSICAL RECORD: n_fields 35; compact format; info bits 32
     0: len 16; hex 36343934333534393934363036323031; asc 6494354994606201;;
     1: len 6; hex 00000001508e; asc     P ;;
     2: len 7; hex 51000002792e0e; asc Q   y. ;;
     3: len 11; hex 3434373131323130343232; asc 44711210422;;
     4: len 23; hex 434e204d454e474e495520444149525920434f204c5444; asc CN MENGNIU DAIRY CO LTD;;
     5: SQL NULL;
     6: len 7; hex 5343425f483248; asc SCB_H2H;;
     7: len 0; hex ; asc ;;
     8: len 10; hex 52454a2031204954454d; asc REJ 1 ITEM;;
     9: len 0; hex ; asc ;;
     10: len 30; hex 47434e41313538372e5245504f525453435553542e323031393039323131; asc GCNA1587.REPORTSCUST.201909211; (total 44 bytes);
     11: SQL NULL;
     12: SQL NULL;
     13: len 3; hex 484b44; asc HKD;;
     14: len 9; hex 800000000000c91811; asc          ;;
     15: len 9; hex 80000000004a375e05; asc      J7^ ;;
     16: len 6; hex 435245444954; asc CREDIT;;
     17: len 5; hex 99a428f1a3; asc   (  ;;
     18: SQL NULL;
     19: SQL NULL;
     20: SQL NULL;
     21: SQL NULL;
     22: SQL NULL;
     23: SQL NULL;
     24: len 30; hex 52454a2031204954454d0952454a2031204954454d090909090909090909; asc REJ 1 ITEM REJ 1 ITEM         ; (total 37 bytes);
     25: len 0; hex ; asc ;;
     26: SQL NULL;
     27: SQL NULL;
     28: SQL NULL;
     29: SQL NULL;
     30: SQL NULL;
     31: len 0; hex ; asc ;;
     32: SQL NULL;
     33: SQL NULL;
     34: SQL NULL;
    
    Record lock, heap no 24 PHYSICAL RECORD: n_fields 35; compact format; info bits 32
     0: len 16; hex 36343934333534393934363130323938; asc 6494354994610298;;
     1: len 6; hex 00000001508e; asc     P ;;
     2: len 7; hex 51000002792e65; asc Q   y.e;;
     3: len 11; hex 3434373139303638353532; asc 44719068552;;
     4: len 25; hex 4541535920524541434820494e564553544d454e542043204c; asc EASY REACH INVESTMENT C L;;
     5: SQL NULL;
     6: len 7; hex 5343425f483248; asc SCB_H2H;;
     7: len 0; hex ; asc ;;
     8: len 0; hex ; asc ;;
     9: len 0; hex ; asc ;;
     10: len 30; hex 47434e41313538372e5245504f525453435553542e323031393039323131; asc GCNA1587.REPORTSCUST.201909211; (total 44 bytes);
     11: SQL NULL;
     12: SQL NULL;
     13: len 3; hex 434e59; asc CNY;;
     14: len 9; hex 800000000000000100; asc          ;;
     15: len 9; hex 800000000000002c00; asc        , ;;
     16: len 5; hex 4445424954; asc DEBIT;;
     17: len 5; hex 99a4289d38; asc   ( 8;;
     18: SQL NULL;
     19: SQL NULL;
     20: SQL NULL;
     21: SQL NULL;
     22: SQL NULL;
     23: SQL NULL;
     24: len 30; hex 53434e313835393544303030303636302d30303030312032303139303932; asc SCN18595D0000660-00001 2019092; (total 105 bytes);
     25: len 0; hex ; asc ;;
     26: SQL NULL;
     27: SQL NULL;
     28: SQL NULL;
     29: SQL NULL;
     30: SQL NULL;
     31: len 29; hex 302d303030303120323031393039323030393532353220202020737473; asc 0-00001 20190920095252    sts;;
     32: SQL NULL;
     33: SQL NULL;
     34: SQL NULL;
    
    Record lock, heap no 25 PHYSICAL RECORD: n_fields 35; compact format; info bits 32
     0: len 16; hex 36343934333534393934363134333935; asc 6494354994614395;;
     1: len 6; hex 00000001508e; asc     P ;;
     2: len 7; hex 51000002792ebb; asc Q   y. ;;
     3: len 11; hex 3434373139303638353532; asc 44719068552;;
     4: len 25; hex 4541535920524541434820494e564553544d454e542043204c; asc EASY REACH INVESTMENT C L;;
     5: SQL NULL;
     6: len 7; hex 5343425f483248; asc SCB_H2H;;
     7: len 0; hex ; asc ;;
     8: len 0; hex ; asc ;;
     9: len 0; hex ; asc ;;
     10: len 30; hex 47434e41313538372e5245504f525453435553542e323031393039323131; asc GCNA1587.REPORTSCUST.201909211; (total 44 bytes);
     11: SQL NULL;
     12: SQL NULL;
     13: len 3; hex 434e59; asc CNY;;
     14: len 9; hex 800000000000000100; asc          ;;
     15: len 9; hex 800000000000002c00; asc        , ;;
     16: len 5; hex 4445424954; asc DEBIT;;
     17: len 5; hex 99a428a629; asc   ( );;
     18: SQL NULL;
     19: SQL NULL;
     20: SQL NULL;
     21: SQL NULL;
     22: SQL NULL;
     23: SQL NULL;
     24: len 30; hex 53434e313835393544303030303636312d30303030312032303139303932; asc SCN18595D0000661-00001 2019092; (total 105 bytes);
     25: len 0; hex ; asc ;;
     26: SQL NULL;
     27: SQL NULL;
     28: SQL NULL;
     29: SQL NULL;
     30: SQL NULL;
     31: len 29; hex 312d303030303120323031393039323031303234333720202020737473; asc 1-00001 20190920102437    sts;;
     32: SQL NULL;
     33: SQL NULL;
     34: SQL NULL;
    
    Record lock, heap no 26 PHYSICAL RECORD: n_fields 35; compact format; info bits 32
     0: len 16; hex 36343934333534393934363138343932; asc 6494354994618492;;
     1: len 6; hex 00000001508e; asc     P ;;
     2: len 7; hex 51000002792f11; asc Q   y/ ;;
     3: len 11; hex 3434373139303638353532; asc 44719068552;;
     4: len 25; hex 4541535920524541434820494e564553544d454e542043204c; asc EASY REACH INVESTMENT C L;;
     5: SQL NULL;
     6: len 7; hex 5343425f483248; asc SCB_H2H;;
     7: len 0; hex ; asc ;;
     8: len 23; hex 52544e3a434e3138353935523030303036363120413033; asc RTN:CN18595R0000661 A03;;
     9: len 0; hex ; asc ;;
     10: len 30; hex 47434e41313538372e5245504f525453435553542e323031393039323131; asc GCNA1587.REPORTSCUST.201909211; (total 44 bytes);
     11: SQL NULL;
     12: SQL NULL;
     13: len 3; hex 434e59; asc CNY;;
     14: len 9; hex 800000000000000100; asc          ;;
     15: len 9; hex 800000000000002c00; asc        , ;;
     16: len 6; hex 435245444954; asc CREDIT;;
     17: len 5; hex 99a428f6ed; asc   (  ;;
     18: SQL NULL;
     19: SQL NULL;
     20: SQL NULL;
     21: SQL NULL;
     22: SQL NULL;
     23: SQL NULL;
     24: len 30; hex 52544e3a434e31383539355230303030363631204130330952544e3a434e; asc RTN:CN18595R0000661 A03 RTN:CN; (total 63 bytes);
     25: len 0; hex ; asc ;;
     26: SQL NULL;
     27: SQL NULL;
     28: SQL NULL;
     29: SQL NULL;
     30: SQL NULL;
     31: len 8; hex 3036363120613033; asc 0661 a03;;
     32: SQL NULL;
     33: SQL NULL;
     34: SQL NULL;
    
    *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
    RECORD LOCKS space id 162 page no 10 n bits 128 index PRIMARY of table "ebg850"."t_ebg_front_detail" trx id 86158 lock_mode X locks rec but not gap waiting   #记录锁
    Record lock, heap no 19 PHYSICAL RECORD: n_fields 35; compact format; info bits 0
     0: len 16; hex 36343934333534393934353136303835; asc 6494354994516085;;
     1: len 6; hex 000000015031; asc     P1;;
     2: len 7; hex aa0000011e0110; asc        ;;
     3: len 12; hex 353031353130343034333937; asc 501510404397;;
     4: len 30; hex 494e4e4552204d4f4e474f4c4941204d454e474e49552044414952592028; asc INNER MONGOLIA MENGNIU DAIRY (; (total 35 bytes);
     5: SQL NULL;
     6: len 7; hex 5343425f483248; asc SCB_H2H;;
     7: len 0; hex ; asc ;;
     8: len 17; hex 435245444954202d20494e544552455354; asc CREDIT - INTEREST;;
     9: len 0; hex ; asc ;;
     10: len 30; hex 47434e41313538372e5245504f525453435553542e323031393039323131; asc GCNA1587.REPORTSCUST.201909211; (total 44 bytes);
     11: SQL NULL;
     12: SQL NULL;
     13: len 3; hex 434e59; asc CNY;;
     14: len 9; hex 800000000000000019; asc          ;;
     15: len 9; hex 800000000000000019; asc          ;;
     16: len 6; hex 435245444954; asc CREDIT;;
     17: len 5; hex 99a4280000; asc   (  ;;
     18: SQL NULL;
     19: SQL NULL;
     20: SQL NULL;
     21: SQL NULL;
     22: SQL NULL;
     23: SQL NULL;
     24: len 30; hex 435245444954202d20494e54455245535409435245444954202d20494e54; asc CREDIT - INTEREST CREDIT - INT; (total 68 bytes);
     25: len 17; hex 435245444954202d20494e544552455354; asc CREDIT - INTEREST;;
     26: SQL NULL;
     27: SQL NULL;
     28: SQL NULL;
     29: SQL NULL;
     30: SQL NULL;
     31: len 7; hex 30303030303330; asc 0000030;;
     32: SQL NULL;
     33: SQL NULL;
     34: SQL NULL;
    
    *** WE ROLL BACK TRANSACTION (1)   #选择回滚事务1
    ------------
    TRANSACTIONS
    ------------
    Trx id counter 86280
    Purge done for trx's n:o < 86278 undo n:o < 0 state: running but idle
    History list length 30
    LIST OF TRANSACTIONS FOR EACH SESSION:
    ---TRANSACTION 281475155575064, not started
    0 lock struct(s), heap size 1136, 0 row lock(s)
    ---TRANSACTION 281475155561984, not started
    0 lock struct(s), heap size 1136, 0 row lock(s)
    ---TRANSACTION 281475155566344, not started
    0 lock struct(s), heap size 1136, 0 row lock(s)
    ---TRANSACTION 281475155574192, not started
    0 lock struct(s), heap size 1136, 0 row lock(s)
    ---TRANSACTION 281475155573320, not started
    0 lock struct(s), heap size 1136, 0 row lock(s)
    ---TRANSACTION 281475155571576, not started
    0 lock struct(s), heap size 1136, 0 row lock(s)
    ---TRANSACTION 281475155564600, not started
    0 lock struct(s), heap size 1136, 0 row lock(s)
    ---TRANSACTION 281475155568960, not started
    0 lock struct(s), heap size 1136, 0 row lock(s)
    ---TRANSACTION 281475155567216, not started
    0 lock struct(s), heap size 1136, 0 row lock(s)
    ---TRANSACTION 281475155568088, not started
    0 lock struct(s), heap size 1136, 0 row lock(s)
    ---TRANSACTION 281475155569832, not started
    0 lock struct(s), heap size 1136, 0 row lock(s)
    ---TRANSACTION 281475155570704, not started
    0 lock struct(s), heap size 1136, 0 row lock(s)
    ---TRANSACTION 281475155563728, not started
    0 lock struct(s), heap size 1136, 0 row lock(s)
    ---TRANSACTION 281475155562856, not started
    0 lock struct(s), heap size 1136, 0 row lock(s)
    ---TRANSACTION 281475155565472, not started
    0 lock struct(s), heap size 1136, 0 row lock(s)
    ---TRANSACTION 281475155572448, not started
    0 lock struct(s), heap size 1136, 0 row lock(s)
    ---TRANSACTION 281475155561112, not started
    0 lock struct(s), heap size 1136, 0 row lock(s)
    ---TRANSACTION 281475155560240, not started
    0 lock struct(s), heap size 1136, 0 row lock(s)
    --------
    FILE I/O
    --------
    I/O thread 0 state: wait Windows aio (insert buffer thread)
    I/O thread 1 state: wait Windows aio (log thread)
    I/O thread 2 state: wait Windows aio (read thread)
    I/O thread 3 state: wait Windows aio (read thread)
    I/O thread 4 state: wait Windows aio (read thread)
    I/O thread 5 state: wait Windows aio (read thread)
    I/O thread 6 state: wait Windows aio (write thread)
    I/O thread 7 state: wait Windows aio (write thread)
    I/O thread 8 state: wait Windows aio (write thread)
    I/O thread 9 state: wait Windows aio (write thread)
    Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
     ibuf aio reads:, log i/o's:, sync i/o's:
    Pending flushes (fsync) log: 0; buffer pool: 0
    1036 OS file reads, 6745 OS file writes, 4158 OS fsyncs
    0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
    -------------------------------------
    INSERT BUFFER AND ADAPTIVE HASH INDEX
    -------------------------------------
    Ibuf: size 1, free list len 0, seg size 2, 11 merges
    merged operations:
     insert 11, delete mark 34, delete 29
    discarded operations:
     insert 0, delete mark 0, delete 0
    Hash table size 34679, node heap has 1 buffer(s)
    Hash table size 34679, node heap has 1 buffer(s)
    Hash table size 34679, node heap has 1 buffer(s)
    Hash table size 34679, node heap has 2 buffer(s)
    Hash table size 34679, node heap has 2 buffer(s)
    Hash table size 34679, node heap has 2 buffer(s)
    Hash table size 34679, node heap has 1 buffer(s)
    Hash table size 34679, node heap has 2 buffer(s)
    0.00 hash searches/s, 0.00 non-hash searches/s
    ---
    LOG
    ---
    Log sequence number 66281948
    Log flushed up to   66281948
    Pages flushed up to 66281948
    Last checkpoint at  66281939
    0 pending log flushes, 0 pending chkp writes
    2567 log i/o's done, 0.00 log i/o's/second
    ----------------------
    BUFFER POOL AND MEMORY
    ----------------------
    Total large memory allocated 137297920
    Dictionary memory allocated 632834
    Buffer pool size   8192
    Free buffers       7103
    Database pages     1077
    Old database pages 411
    Modified db pages  0
    Pending reads      0
    Pending writes: LRU 0, flush list 0, single page 0
    Pages made young 1, not young 0
    0.00 youngs/s, 0.00 non-youngs/s
    Pages read 959, created 118, written 3730
    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: 1077, 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=3528, Main thread ID=4308, state: sleeping
    Number of rows inserted 126584, updated 256, deleted 195, read 30624534
    0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 65.73 reads/s
    ----------------------------
    END OF INNODB MONITOR OUTPUT
    ============================