root@localhost:(none) 8.0.16 11:19:07> show engine innodb status \G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2019-07-30 11:20:00 0x7f56fd9ff700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 59 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 2269 srv_active, 0 srv_shutdown, 672 srv_idle srv_master_thread log flush and writes: 0 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 14859467 OS WAIT ARRAY INFO: signal count 5258897 RW-shared spins 4727018, rounds 12031814, OS waits 7354004 RW-excl spins 9131584, rounds 280788344, OS waits 5109235 RW-sx spins 1712558, rounds 49285763, OS waits 1526021 Spin rounds per wait: 2.55 RW-shared, 30.75 RW-excl, 28.78 RW-sx ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 2019-07-30 10:49:41 0x7f5b34331700 Transaction: TRANSACTION 897939685, ACTIVE 0 sec inserting, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 206, OS thread handle 140029694514944, query id 80487 10.10.0.209 hotdb_datasource update INSERT INTO join_b_jwy_child VALUES (15, 14, 'apa ch', '\'二\'', '2000-01-01 01:01:01') Foreign key constraint fails for table `pt253`.`join_b_jwy_child`: , CONSTRAINT `join_b_jwy_child_ibfk_1` FOREIGN KEY (`chbdnid`) REFERENCES `join_b_jwy` (`id`) ON DELETE CASCADE ON UPDATE CASCADE Trying to add in child table, in index chbdnid tuple: DATA TUPLE: 2 fields; 0: len 4; hex 8000000e; asc ;; 1: len 4; hex 0000000f; asc ;; But in parent table `pt253`.`join_b_jwy`, in index PRIMARY, the closest match we can find is record: PHYSICAL RECORD: n_fields 8; compact format; info bits 0 0: len 4; hex 8000000f; asc ;; 1: len 6; hex 0000358577c0; asc 5 w ;; 2: len 7; hex 81000000f8011d; asc ;; 3: len 4; hex 8000006a; asc j;; 4: len 4; hex 800003ed; asc ;; 5: len 2; hex 6635; asc f5;; 6: len 3; hex 4c4955; asc LIU;; 7: len 5; hex 99790c618a; asc y a ;; ------------ TRANSACTIONS ------------ Trx id counter 937840578 Purge done for trx's n:o < 937818819 undo n:o < 0 state: running but idle History list length 22 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421505365605808, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365604912, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365604016, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365603120, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365602224, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365601328, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365600432, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365599536, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365598640, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365597744, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365596848, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365595952, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365595056, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365594160, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365593264, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365592368, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365591472, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365590576, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365589680, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365588784, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365587888, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365586992, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365586096, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365585200, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365584304, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365583408, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365582512, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365581616, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365580720, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365579824, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365578928, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365578032, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365577136, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365576240, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365575344, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365574448, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365573552, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365572656, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365571760, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365570864, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365569968, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365371056, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365569072, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365568176, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365567280, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365566384, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365565488, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365564592, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365563696, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365562800, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365561904, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365561008, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365560112, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365559216, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365558320, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365557424, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365556528, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365555632, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365554736, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365553840, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365552944, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365552048, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365551152, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365550256, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365549360, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365548464, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365547568, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365546672, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365545776, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365544880, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365543984, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365543088, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365542192, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365541296, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365540400, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365539504, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365538608, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365537712, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365536816, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365535920, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365535024, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365534128, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365533232, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365532336, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365531440, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365530544, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365529648, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365528752, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365527856, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365526960, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365526064, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365525168, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365524272, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365523376, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365522480, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365521584, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365520688, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365519792, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365518896, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365518000, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365517104, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365516208, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365515312, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365514416, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365513520, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365512624, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365511728, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365510832, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365509936, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365509040, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365508144, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365507248, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365506352, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365505456, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365504560, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365503664, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365502768, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365501872, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365500976, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365500080, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365499184, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365498288, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365497392, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365496496, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365495600, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365494704, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365493808, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365492912, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365492016, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365490224, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365489328, not started mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365488432, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365484848, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365483056, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365482160, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365481264, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365480368, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365476784, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365475888, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365474096, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365472304, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365466928, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365465136, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365463344, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365462448, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365461552, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365460656, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365457968, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365457072, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365456176, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365455280, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365454384, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365451696, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365448112, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365447216, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365446320, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365444528, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365443632, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365441840, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365440944, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365439152, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365436464, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365424816, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365423920, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365423024, not started sleeping before entering InnoDB mysql tables in use 2, locked 2 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365421232, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365420336, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365419440, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365417648, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365415856, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365412272, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365406000, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365404208, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365401520, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365399728, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365398832, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365397936, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365397040, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365373744, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365395248, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365375536, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365392560, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365391664, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365390768, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365389872, not started mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365376432, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365382704, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365378224, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365387184, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365386288, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365385392, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365435568, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365434672, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365433776, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365403312, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365402416, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365370160, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365369264, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365367472, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365384496, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365366576, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365365680, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365364784, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365363888, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365362992, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365361200, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365360304, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365357616, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365356720, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365354928, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365353136, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365352240, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365351344, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365350448, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365349552, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365348656, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365345968, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365345072, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365344176, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365343280, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365342384, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365340592, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365339696, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365338800, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365380912, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365380016, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365368368, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365362096, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365359408, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365358512, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365355824, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365354032, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365347760, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365346864, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365341488, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421505365337904, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 937840577, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 657, OS thread handle 140017003460352, query id 40008486 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=553416 ---TRANSACTION 937840576, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 621, OS thread handle 140022928144128, query id 40008482 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=1584000 ---TRANSACTION 937840575, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 654, OS thread handle 140017004345088, query id 40008483 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=8657637 ---TRANSACTION 937840574, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 635, OS thread handle 140022915757824, query id 40008481 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=8003494 ---TRANSACTION 937840573, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 567, OS thread handle 140022922245888, query id 40008480 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=4916714 ---TRANSACTION 937840572, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 626, OS thread handle 140022918412032, query id 40008479 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=3778420 ---TRANSACTION 937840571, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 639, OS thread handle 140022914578176, query id 40008478 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=8371370 ---TRANSACTION 937840570, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 662, OS thread handle 140017001985792, query id 40008477 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=9652230 ---TRANSACTION 937840569, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 628, OS thread handle 140022917822208, query id 40008476 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=6676335 ---TRANSACTION 937840568, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 661, OS thread handle 140017002280704, query id 40008475 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=667235 ---TRANSACTION 937840567, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 581, OS thread handle 140022925784832, query id 40008474 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=3933450 ---TRANSACTION 937840566, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 625, OS thread handle 140022918706944, query id 40008472 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=6111387 ---TRANSACTION 937840565, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 569, OS thread handle 140022927849216, query id 40008470 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=4677514 ---TRANSACTION 937840564, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 582, OS thread handle 140022934632192, query id 40008471 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=4539111 ---TRANSACTION 937840563, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 682, OS thread handle 140016996087552, query id 40008473 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=9947551 ---TRANSACTION 937840562, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 597, OS thread handle 140022931093248, query id 40008469 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=8869175 ---TRANSACTION 937840561, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 584, OS thread handle 140026692908800, query id 40008468 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=9946750 ---TRANSACTION 937840560, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 562, OS thread handle 140022933157632, query id 40008466 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=3731957 ---TRANSACTION 937840559, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 609, OS thread handle 140022926374656, query id 40008467 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=7889423 ---TRANSACTION 937840558, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 617, OS thread handle 140022931388160, query id 40008465 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=3401761 ---TRANSACTION 937840557, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 610, OS thread handle 140022925489920, query id 40008464 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=3383542 ---TRANSACTION 937840556, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 576, OS thread handle 140022924605184, query id 40008463 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=3195530 ---TRANSACTION 937840555, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 623, OS thread handle 140022934042368, query id 40008462 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=4839715 ---TRANSACTION 937840554, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 668, OS thread handle 140017000216320, query id 40008461 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=4575140 ---TRANSACTION 937840553, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 619, OS thread handle 140030384891648, query id 40008457 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=43577 ---TRANSACTION 937840552, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 568, OS thread handle 140029691565824, query id 40008458 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=7122914 ---TRANSACTION 937840551, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 608, OS thread handle 140022929323776, query id 40008459 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=3236023 ---TRANSACTION 937840550, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 602, OS thread handle 140022921361152, query id 40008456 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=6430392 ---TRANSACTION 937840549, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 577, OS thread handle 140022928439040, query id 40008460 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=640795 ---TRANSACTION 937840548, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 559, OS thread handle 140022920771328, query id 40008455 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=9814004 ---TRANSACTION 937840547, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 645, OS thread handle 140017006999296, query id 40008454 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=241232 ---TRANSACTION 937840546, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 571, OS thread handle 140030385481472, query id 40008453 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=4062388 ---TRANSACTION 937840545, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 601, OS thread handle 140026671576832, query id 40008452 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=8114056 ---TRANSACTION 937840544, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 683, OS thread handle 140016995792640, query id 40008451 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=4779365 ---TRANSACTION 937840543, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 603, OS thread handle 140022927259392, query id 40008450 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=4876308 ---TRANSACTION 937840542, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 616, OS thread handle 140022933747456, query id 40008449 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=398775 ---TRANSACTION 937840541, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 560, OS thread handle 140022934337280, query id 40008448 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=4197768 ---TRANSACTION 937840540, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 650, OS thread handle 140017005524736, query id 40008445 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=2992341 ---TRANSACTION 937840539, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 583, OS thread handle 140026673641216, query id 40008443 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=2851419 ---TRANSACTION 937840538, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 648, OS thread handle 140017006114560, query id 40008447 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=6275300 ---TRANSACTION 937840537, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 613, OS thread handle 140022932567808, query id 40008446 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=8252036 ---TRANSACTION 937840536, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 684, OS thread handle 140016995497728, query id 40008444 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=8284210 ---TRANSACTION 937840535, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 651, OS thread handle 140017005229824, query id 40008442 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=2528755 ---TRANSACTION 937840534, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 620, OS thread handle 140022921066240, query id 40008441 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=8187003 ---TRANSACTION 937840533, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 622, OS thread handle 140022931977984, query id 40008437 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=5739872 ---TRANSACTION 937840532, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 604, OS thread handle 140022929618688, query id 40008438 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=2452728 ---TRANSACTION 937840531, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 627, OS thread handle 140022918117120, query id 40008440 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=8215504 ---TRANSACTION 937840530, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 679, OS thread handle 140016997267200, query id 40008439 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=544316 ---TRANSACTION 937840529, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 606, OS thread handle 140022926964480, query id 40008436 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=2077476 ---TRANSACTION 937840528, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 670, OS thread handle 140016999626496, query id 40008435 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=9502467 ---TRANSACTION 937840527, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 658, OS thread handle 140017003165440, query id 40008434 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=8500939 ---TRANSACTION 937840526, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 632, OS thread handle 140022916642560, query id 40008430 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=8138032 ---TRANSACTION 937840525, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 573, OS thread handle 140022956619520, query id 40008432 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=4497184 ---TRANSACTION 937840524, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 637, OS thread handle 140022915168000, query id 40008433 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=6337394 ---TRANSACTION 937840523, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 674, OS thread handle 140016998446848, query id 40008431 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=7917343 ---TRANSACTION 937840522, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 642, OS thread handle 140022913693440, query id 40008429 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=1709992 ---TRANSACTION 937840521, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 659, OS thread handle 140017002870528, query id 40008428 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=9569703 ---TRANSACTION 937840520, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 591, OS thread handle 140026694678272, query id 40008427 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=6391909 ---TRANSACTION 937840519, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 685, OS thread handle 140016995202816, query id 40008426 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=8550339 ---TRANSACTION 937840518, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 570, OS thread handle 140022924015360, query id 40008425 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=9693445 ---TRANSACTION 937840517, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 618, OS thread handle 140022923130624, query id 40008421 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=9789999 ---TRANSACTION 937840516, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 600, OS thread handle 140022925195008, query id 40008420 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=3595742 ---TRANSACTION 937840514, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 563, OS thread handle 140029691860736, query id 40008422 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=4277689 ---TRANSACTION 937840512, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 614, OS thread handle 140022934927104, query id 40008418 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=7367899 -------- 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 (read thread) I/O thread 11 state: waiting for completed aio requests (read thread) I/O thread 12 state: waiting for completed aio requests (read thread) I/O thread 13 state: waiting for completed aio requests (read thread) I/O thread 14 state: waiting for completed aio requests (read thread) I/O thread 15 state: waiting for completed aio requests (read thread) I/O thread 16 state: waiting for completed aio requests (read thread) I/O thread 17 state: waiting for completed aio requests (read thread) I/O thread 18 state: waiting for completed aio requests (write thread) I/O thread 19 state: waiting for completed aio requests (write thread) I/O thread 20 state: waiting for completed aio requests (write thread) I/O thread 21 state: waiting for completed aio requests (write thread) I/O thread 22 state: waiting for completed aio requests (write thread) I/O thread 23 state: waiting for completed aio requests (write thread) I/O thread 24 state: waiting for completed aio requests (write thread) I/O thread 25 state: waiting for completed aio requests (write thread) Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0, 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: 0 8267 OS file reads, 2738506 OS file writes, 17017 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 443, seg size 445, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 12750011, node heap has 1 buffer(s) Hash table size 12750011, node heap has 2 buffer(s) Hash table size 12750011, node heap has 1 buffer(s) Hash table size 12750011, node heap has 3 buffer(s) Hash table size 12750011, node heap has 24 buffer(s) Hash table size 12750011, node heap has 19 buffer(s) Hash table size 12750011, node heap has 2 buffer(s) Hash table size 12750011, node heap has 5 buffer(s) 57.71 hash searches/s, 0.75 non-hash searches/s --- LOG --- Log sequence number 487115574470 Log buffer assigned up to 487115574470 Log buffer completed up to 487115574470 Log written up to 487115574470 Log flushed up to 487115574470 Added dirty pages up to 487115574470 Pages flushed up to 487115574470 Last checkpoint at 487115574470 2599118 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 53150220288 Dictionary memory allocated 1564811 Buffer pool size 3169536 Free buffers 3036443 Database pages 133036 Old database pages 48945 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2643, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 8200, created 124836, written 130519 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: 133036, 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 396192 Free buffers 379422 Database pages 16763 Old database pages 6167 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 492, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1113, created 15650, written 16504 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: 16763, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 396192 Free buffers 379773 Database pages 16413 Old database pages 6038 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 255, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1028, created 15385, written 16144 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: 16413, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 396192 Free buffers 379344 Database pages 16842 Old database pages 6197 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 387, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1071, created 15771, written 16542 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: 16842, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 396192 Free buffers 379491 Database pages 16693 Old database pages 6142 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 260, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 995, created 15698, written 16273 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: 16693, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 396192 Free buffers 379683 Database pages 16500 Old database pages 6070 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 567, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 939, created 15561, written 16175 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: 16500, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 396192 Free buffers 379554 Database pages 16631 Old database pages 6119 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 134, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 910, created 15721, written 16264 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: 16631, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 396192 Free buffers 379458 Database pages 16727 Old database pages 6154 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 221, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1052, created 15675, written 16416 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: 16727, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 396192 Free buffers 379718 Database pages 16467 Old database pages 6058 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 327, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1092, created 15375, written 16201 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: 16467, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 64 queries inside InnoDB, 220 queries in queue 0 read views open inside InnoDB Process ID=8223, Main thread ID=140026745034496 , state=sleeping Number of rows inserted 10057462, updated 23906, deleted 12583, read 332225 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 58.46 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.01 sec)