mysql> show engine innodb status \G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2016-04-05 08:03:44 0x7fe5c2b54700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 35 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 19432 srv_active, 0 srv_shutdown, 36647 srv_idle srv_master_thread log flush and writes: 56079 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3484445 OS WAIT ARRAY INFO: signal count 1868856 RW-shared spins 0, rounds 167900, OS waits 64305 RW-excl spins 0, rounds 298604, OS waits 7303 RW-sx spins 5395, rounds 152224, OS waits 4649 Spin rounds per wait: 167900.00 RW-shared, 298604.00 RW-excl, 28.22 RW-sx ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2016-04-05 07:35:45 0x7fe5c80aa700 *** (1) TRANSACTION: TRANSACTION 2181965, ACTIVE 19 sec fetching rows mysql tables in use 1, locked 1 LOCK WAIT 140 lock struct(s), heap size 24784, 32361 row lock(s) MySQL thread id 1582, OS thread handle 140624798619392, query id 439807 03ucas.csi.it 158.102.109.85 dspam updating UPDATE dspam_token_data SET last_hit=CURRENT_DATE(),innocent_hits=innocent_hits+1 WHERE uid=1567 AND token IN ('14822728442300393828','775062969050721000','9557197683641891143','13780744010083109818','2325993340322513011','9567555186955417699','15589605075224684900','16941100860279960827','8835710348938694415','9659844558438381175','11223114090783677431','7519108987979846909','9927529377446550413','7565866511792138514','3349674998348944073','18411263089752140132','6620706401526865920','2423091787690094674','6225032522693918720','7658351160871930739','8858631077574108733','5111792531757688041','214217867040294487','5915870537525805056','9731864419967966569','1941657893535810150','13147962357488289599','557403863372042473','6728553518869047553','5717584670918123155','783029068232911592','4382176655678052131','107059695121527081','8454806434022253801','17450495502431974344','15947889639536308650', *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 176 page no 143024 n bits 248 index id_token_data_01 of table `dspam`.`dspam_token_data` /* Partition `p4` */ trx id 2181965 lock_mode X waiting Record lock, heap no 182 PHYSICAL RECORD: n_fields 7; compact format; info bits 0 0: len 4; hex 000005dd; asc ;; 1: len 8; hex 00bb07748086b190; asc t ;; 2: len 6; hex 000000214ba4; asc !K ;; 3: len 7; hex a400001f993e32; asc >2;; 4: len 8; hex 0000000000000000; asc ;; 5: len 8; hex 0000000000000001; asc ;; 6: len 3; hex 8fc085; asc ;; *** (2) TRANSACTION: TRANSACTION 2182052, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 3 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 834 MySQL thread id 49, OS thread handle 140624880379648, query id 440045 03ucas.csi.it 158.102.109.85 dspam update INSERT INTO dspam_token_data(uid,token,spam_hits,innocent_hits,last_hit) VALUES(1501,'12203203646138861033',0,1,CURRENT_DATE()),(1501,'13144952159098717927',0,1,CURRENT_DATE()),(1501,'17311233726216734332',0,1,CURRENT_DATE()),(1501,'5502410444563375337',0,1,CURRENT_DATE()),(1501,'3521562160412439458',0,1,CURRENT_DATE()),(1501,'6887468567342851430',0,1,CURRENT_DATE()),(1501,'6975953825014185839',0,1,CURRENT_DATE()),(1501,'17787996415244185939',0,1,CURRENT_DATE()),(1501,'13775133543684996672',0,1,CURRENT_DATE()),(1501,'8325741652720066953',0,1,CURRENT_DATE()),(1501,'733856687333089353',0,1,CURRENT_DATE()),(1501,'82837956143819172',0,1,CURRENT_DATE()),(1501,'4663575665567946019',0,1,CURRENT_DATE()),(1501,'16079726859171871953',0,1,CURRENT_DATE()),(1501,'3165077460530118784',0,1,CURRENT_DATE()),(1501,'14964216803032507594',0,1,CURRENT_DATE()),(1501,'3720811294980878594',0,1,CURRENT_DATE()),(1501,'11266 *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 176 page no 143024 n bits 248 index id_token_data_01 of table `dspam`.`dspam_token_data` /* Partition `p4` */ trx id 2182052 lock_mode X locks rec but not gap Record lock, heap no 182 PHYSICAL RECORD: n_fields 7; compact format; info bits 0 0: len 4; hex 000005dd; asc ;; 1: len 8; hex 00bb07748086b190; asc t ;; 2: len 6; hex 000000214ba4; asc !K ;; 3: len 7; hex a400001f993e32; asc >2;; 4: len 8; hex 0000000000000000; asc ;; 5: len 8; hex 0000000000000001; asc ;; 6: len 3; hex 8fc085; asc ;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 176 page no 131796 n bits 256 index id_token_data_01 of table `dspam`.`dspam_token_data` /* Partition `p4` */ trx id 2182052 lock_mode X locks gap before rec insert intention waiting Record lock, heap no 10 PHYSICAL RECORD: n_fields 7; compact format; info bits 0 0: len 4; hex 000005dd; asc ;; 1: len 8; hex 006b413a7cd4047c; asc kA:| |;; 2: len 6; hex 000000067a6e; asc zn;; 3: len 7; hex fb000001e3298c; asc ) ;; 4: len 8; hex 0000000000000000; asc ;; 5: len 8; hex 0000000000000001; asc ;; 6: len 3; hex 8fc07e; asc ~;; *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 2190397 Purge done for trx's n:o < 2190396 undo n:o < 0 state: running but idle History list length 155 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 422112484293408, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484313472, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484308912, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484317120, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484310736, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484309824, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484307088, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484303440, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484302528, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484341744, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484340832, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484339920, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484339008, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484338096, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484337184, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484305264, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484300704, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484298880, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484296144, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484294320, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484292496, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484291584, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484290672, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484287936, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484281552, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484335360, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484333536, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484319856, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484322592, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484318944, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484318032, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484301616, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484297056, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484297968, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484295232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484288848, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484316208, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484299792, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484289760, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484287024, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484286112, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484285200, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484284288, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484283376, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484282464, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484280640, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484279728, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484278816, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484277904, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484276992, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484276080, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484275168, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484274256, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484273344, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484272432, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484271520, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484270608, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484269696, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484268784, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484267872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484266960, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484266048, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484265136, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484264224, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484261488, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422112484260576, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 2190396, ACTIVE 1 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 48, OS thread handle 140624880645888, query id 466210 03ucas.csi.it 158.102.109.85 dspam updating UPDATE dspam_token_data SET last_hit=CURRENT_DATE(),innocent_hits=innocent_hits+1 WHERE uid=82 AND token IN ('9567555186955417699','10446659161155721495','1026179340677244137','13458828133823099408','15408090777473706340','15154149719392354495','668710054403232422','9878093161694653415','5076928224955887081','14501367015846799499','2423091787690094674','2249913145501519238','7619616403877980735','1123492447053588442','13096886385523160027','6279150879403761112','4244623274904728120','15211909104099715428','6945630571729155010','2287901783020365033','5282037095311890717','2488313755657476305',' ------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 213 page no 13311 n bits 400 index id_token_data_01 of table `dspam`.`dspam_token_data` /* Partition `p1` */ trx id 2190396 lock_mode X locks rec but not gap waiting Record lock, heap no 63 PHYSICAL RECORD: n_fields 7; compact format; info bits 0 0: len 4; hex 00000052; asc R;; 1: len 8; hex 00478797b8b10210; asc G ;; 2: len 6; hex 0000002164ee; asc !d ;; 3: len 7; hex 3a000003ff0730; asc : 0;; 4: len 8; hex 0000000000000000; asc ;; 5: len 8; hex 0000000000000325; asc %;; 6: len 3; hex 8fc085; asc ;; ------------------ ---TRANSACTION 2190347, ACTIVE 10 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 47, OS thread handle 140624880912128, query id 466021 03ucas.csi.it 158.102.109.85 dspam updating UPDATE dspam_token_data SET last_hit=CURRENT_DATE(),innocent_hits=innocent_hits+1 WHERE uid=19 AND token IN ('6362647548452652409','9567555186955417699','6208150416587842793','15154149719392354495','17020457261305220163','15977590319312527204','13401596831119492704','12104722801698916828','10562727883662666429','7619616403877980735','13096886385523160027','16709713247732678115','10361574902204393657','12807611994955572863','13751548503746968340','200996710007495397','18178604032711156086','16324644699627788789','9449299958972360164','1026249994348881129','8627831945568774500','1164669208570231 ------- TRX HAS BEEN WAITING 10 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 213 page no 229582 n bits 352 index id_token_data_01 of table `dspam`.`dspam_token_data` /* Partition `p1` */ trx id 2190347 lock_mode X locks rec but not gap waiting Record lock, heap no 35 PHYSICAL RECORD: n_fields 7; compact format; info bits 0 0: len 4; hex 00000013; asc ;; 1: len 8; hex 00478797b8b10210; asc G ;; 2: len 6; hex 0000002115fe; asc ! ;; 3: len 7; hex 6d000001c10110; asc m ;; 4: len 8; hex 0000000000000000; asc ;; 5: len 8; hex 0000000000000061; asc a;; 6: len 3; hex 8fc085; asc ;; ------------------ ---TRANSACTION 2190328, ACTIVE 14 sec fetching rows mysql tables in use 1, locked 1 99060 lock struct(s), heap size 11952336, 21883793 row lock(s) MySQL thread id 7, OS thread handle 140625262069504, query id 465925 01ucas.csi.it 158.102.109.83 dspam updating UPDATE dspam_token_data SET last_hit=CURRENT_DATE(),innocent_hits=innocent_hits+1 WHERE uid=255 AND token IN ('7170339962745422626','2111610832256244706','552891471833425129','4663057623114363138','1437042169092228521','6200783654128773498','3763830402074920520','10873079353118163665','9567555186955417699','17876936503699268841','4610038519997998096','9271175406804380038','11805404004278670955','336864676244193276','10372970888095986396','6622464847454957568','10726212840999659272','6623942591082688512','15384598969351665563','608919307977802391','7961275886705665257','15154149719392354495','4 -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) 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 168058590 OS file reads, 11321873 OS file writes, 2379353 OS fsyncs 3913.46 reads/s, 16384 avg bytes/read, 159.00 writes/s, 18.31 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 7296 merges merged operations: insert 7642, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 2656163, node heap has 8 buffer(s) Hash table size 2656163, node heap has 0 buffer(s) Hash table size 2656163, node heap has 228 buffer(s) Hash table size 2656163, node heap has 509 buffer(s) Hash table size 2656163, node heap has 1 buffer(s) Hash table size 2656163, node heap has 0 buffer(s) Hash table size 2656163, node heap has 9 buffer(s) Hash table size 2656163, node heap has 12 buffer(s) 47.34 hash searches/s, 5506.10 non-hash searches/s --- LOG --- Log sequence number 85799121329 Log flushed up to 85799121329 Pages flushed up to 85681148717 Last checkpoint at 85681148717 0 pending log flushes, 0 pending chkp writes 176458 log i/o's done, 11.37 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 10994319360 Dictionary memory allocated 1029301 Buffer pool size 655320 Free buffers 0 Database pages 653824 Old database pages 241479 Modified db pages 149159 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 38221654, not young 33445390813 540.27 youngs/s, 716703.55 non-youngs/s Pages read 168061338, created 814821, written 9893891 3913.75 reads/s, 14.37 creates/s, 140.22 writes/s Buffer pool hit rate 997 / 1000, young-making rate 0 / 1000 not 627 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 653824, unzip_LRU len: 0 I/O sum[1826464]:cur[11128], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 81910 Free buffers 0 Database pages 81712 Old database pages 30179 Modified db pages 18774 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 4759027, not young 4197927216 73.40 youngs/s, 81843.52 non-youngs/s Pages read 21045659, created 99682, written 1235665 457.99 reads/s, 0.17 creates/s, 10.06 writes/s Buffer pool hit rate 997 / 1000, young-making rate 0 / 1000 not 571 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 81712, unzip_LRU len: 0 I/O sum[228308]:cur[1391], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 81920 Free buffers 0 Database pages 81727 Old database pages 30184 Modified db pages 18471 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 4708206, not young 4182361977 71.03 youngs/s, 97026.06 non-youngs/s Pages read 21005209, created 101336, written 1226223 520.84 reads/s, 0.89 creates/s, 26.68 writes/s Buffer pool hit rate 997 / 1000, young-making rate 0 / 1000 not 663 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 81727, unzip_LRU len: 0 I/O sum[228308]:cur[1391], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 81910 Free buffers 0 Database pages 81719 Old database pages 30181 Modified db pages 18661 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 4785973, not young 4190259398 67.71 youngs/s, 96850.00 non-youngs/s Pages read 21062761, created 99892, written 1244662 525.93 reads/s, 5.09 creates/s, 25.06 writes/s Buffer pool hit rate 997 / 1000, young-making rate 0 / 1000 not 691 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 81719, unzip_LRU len: 0 I/O sum[228308]:cur[1391], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 81920 Free buffers 0 Database pages 81729 Old database pages 30184 Modified db pages 18222 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 4765925, not young 4198917684 62.94 youngs/s, 80783.72 non-youngs/s Pages read 21139258, created 98600, written 1239496 452.47 reads/s, 2.63 creates/s, 10.34 writes/s Buffer pool hit rate 997 / 1000, young-making rate 0 / 1000 not 572 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 81729, unzip_LRU len: 0 I/O sum[228308]:cur[1391], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 81910 Free buffers 0 Database pages 81717 Old database pages 30182 Modified db pages 18943 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 4802234, not young 4191041881 70.23 youngs/s, 84456.47 non-youngs/s Pages read 21077743, created 106076, written 1248109 466.50 reads/s, 1.09 creates/s, 15.49 writes/s Buffer pool hit rate 997 / 1000, young-making rate 0 / 1000 not 614 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 81717, unzip_LRU len: 0 I/O sum[228308]:cur[1391], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 81920 Free buffers 0 Database pages 81737 Old database pages 30189 Modified db pages 19290 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 4838200, not young 4145813518 59.40 youngs/s, 102377.87 non-youngs/s Pages read 20839620, created 101557, written 1244066 540.76 reads/s, 1.83 creates/s, 17.40 writes/s Buffer pool hit rate 997 / 1000, young-making rate 0 / 1000 not 707 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 81737, unzip_LRU len: 0 I/O sum[228308]:cur[1391], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 81910 Free buffers 0 Database pages 81728 Old database pages 30185 Modified db pages 18124 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 4794941, not young 4164321419 63.46 youngs/s, 88361.90 non-youngs/s Pages read 20886789, created 103991, written 1227892 483.07 reads/s, 1.49 creates/s, 16.57 writes/s Buffer pool hit rate 997 / 1000, young-making rate 0 / 1000 not 606 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 81728, unzip_LRU len: 0 I/O sum[228308]:cur[1391], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 81920 Free buffers 0 Database pages 81755 Old database pages 30195 Modified db pages 18674 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 4767148, not young 4174747720 72.11 youngs/s, 85004.00 non-youngs/s Pages read 21004299, created 103687, written 1227778 466.19 reads/s, 1.20 creates/s, 18.63 writes/s Buffer pool hit rate 997 / 1000, young-making rate 0 / 1000 not 594 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 81755, unzip_LRU len: 0 I/O sum[228308]:cur[1391], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=24835, Main thread ID=140625328461568, state: sleeping Number of rows inserted 17815063, updated 21181802, deleted 0, read 60487314732 1821.03 inserts/s, 1961.46 updates/s, 0.00 deletes/s, 1135894.20 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================