=====================================
2020-02-21 12:57:55 0x2ba8e12c3700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 12 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 2688881 srv_active, 0 srv_shutdown, 45 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 192324060
OS WAIT ARRAY INFO: signal count 127420760
RW-shared spins 0, rounds 103854483, OS waits 21462520
RW-excl spins 0, rounds 426967681, OS waits 13525776
RW-sx spins 1531024, rounds 9117349, OS waits 91138
Spin rounds per wait: 103854483.00 RW-shared, 426967681.00 RW-excl, 5.96 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2020-02-21 11:01:41 0x2ba9a8d54700 Transaction:
TRANSACTION 10685197829, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
1589 lock struct(s), heap size 1136, 117098 row lock(s), undo log entries 10088
MySQL thread id 51743111, OS thread handle 48007682017024, query id 6465701247 10.100.162.196 shipmonk-prod updating
DELETE FROM web_hook_event WHERE DATE_ADD(created_at, INTERVAL 1209600 SECOND) < '2020-02-21 06:01:36'
Foreign key constraint fails for table `shipmonk_tracking`.`web_hook_call`:
,
  CONSTRAINT `FK_9E912F7C8D5467B` FOREIGN KEY (`web_hook_event_id`) REFERENCES `web_hook_event` (`id`)
Trying to delete or update in parent table, in index PRIMARY tuple:
DATA TUPLE: 10 fields;
 0: len=16; bufptr=0x2ba8e15f7398; hex= 09e2047cce8a4ee0bd8b4c83a29a1e1f; asc    |  N   L     ;;
 1: len=6; bufptr=0x2ba8e15f73a8; hex= 00027ce32e05; asc   | . ;;
 2: len=7; bufptr=0x2ba8e15f73ae; hex= 4d001a14dc15f8; asc M      ;;
 3: len=16; bufptr=0x2ba8e15f73b5; hex= a324c0dc36cc46fe8882dc4365a6d135; asc  $  6 F    Ce  5;;
 4: len=16; bufptr=0x2ba8e15f73c5; hex= 74dfcec7b2ca43f990761bfc81161695; asc t     C  v      ;;
 5: len=14; bufptr=0x2ba8e15f73d5; hex= 747261636b65725f757064617465; asc tracker_update;;
 6: len=9; bufptr=0x2ba8e15f73e3; hex= 636f6d706c65746564; asc completed;;
 7: SQL NULL;
 8: len=5; bufptr=0x2ba8e15f73ec; hex= 99a58e604d; asc    `M;;
 9: len=5; bufptr=0x2ba8e15f73f1; hex= 99a58e606a; asc    `j;;

But in child table `shipmonk_tracking`.`web_hook_call`, in index IDX_9E912F7C8D5467B, there is a record:
PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len=16; bufptr=0x2b9682e3cc57; hex= 09e2047cce8a4ee0bd8b4c83a29a1e1f; asc    |  N   L     ;;
 1: len=16; bufptr=0x2b9682e3cc67; hex= 4882f30f86264e2a982a2aeaf2dcad3a; asc H    &N* **    :;;

------------------------
LATEST DETECTED DEADLOCK
------------------------
2020-02-21 12:43:45 0x2ba8efa4f700
*** (1) TRANSACTION:
TRANSACTION 10687502215, ACTIVE 2 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 4 lock struct(s), heap size 1136, 2 row lock(s)
MySQL thread id 51825062, OS thread handle 48007617971968, query id 6483549360 10.100.176.118 shipmonk-prod statistics
SELECT 1 FROM fulfillment t0 WHERE t0.id = 14868819 FOR UPDATE
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1801 page no 211489 n bits 0 index PRIMARY of table `shipmonk`.`fulfillment` trx id 10687502215 lock_mode X locks rec but not gap waiting
Record lock, heap no 18 PHYSICAL RECORD: n_fields 65; compact format; info bits 0
 0: len=4; bufptr=0x2b928912118a; hex= 80e2e153; asc    S;;
 1: len=6; bufptr=0x2b928912118e; hex= 00027d05b2a3; asc   }   ;;
 2: len=7; bufptr=0x2b9289121194; hex= 47003880370055; asc G 8 7 U;;
 3: len=4; bufptr=0x2b928912119b; hex= 80e1e102; asc     ;;
 4: len=4; bufptr=0x2b928912119f; hex= 800000c3; asc     ;;
 5: SQL NULL;
 6: len=8; bufptr=0x2b92891211a3; hex= d7a3703d0ad71740; asc   p=   @;;
 7: SQL NULL;
 8: len=8; bufptr=0x2b92891211ab; hex= 333333333333eb3f; asc 333333 ?;;
 9: SQL NULL;
 10: SQL NULL;
 11: len=8; bufptr=0x2b92891211b3; hex= 0000000000000000; asc         ;;
 12: SQL NULL;
 13: len=4; bufptr=0x2b92891211bb; hex= 800080e9; asc     ;;
 14: SQL NULL;
 15: len=8; bufptr=0x2b92891211bf; hex= 0ad7a3703d0a1340; asc    p=  @;;
 16: len=1; bufptr=0x2b92891211c7; hex= 80; asc  ;;
 17: SQL NULL;
 18: SQL NULL;
 19: len=8; bufptr=0x2b92891211c8; hex= 0000000000000040; asc        @;;
 20: len=8; bufptr=0x2b92891211d0; hex= 0000000000002540; asc       %@;;
 21: len=8; bufptr=0x2b92891211d8; hex= 0000000000001240; asc        @;;
 22: len=8; bufptr=0x2b92891211e0; hex= 0000000000001c40; asc        @;;
 23: len=4; bufptr=0x2b92891211e8; hex= 8000073a; asc    :;;
 24: len=4; bufptr=0x2b92891211ec; hex= 8000004c; asc    L;;
 25: SQL NULL;
 26: len=8; bufptr=0x2b92891211f0; hex= 536869704d6f6e6b; asc ShipMonk;;
 27: SQL NULL;
 28: SQL NULL;
 29: SQL NULL;
 30: len=4; bufptr=0x2b92891211f8; hex= 80000000; asc     ;;
 31: len=1; bufptr=0x2b92891211fc; hex= 80; asc  ;;
 32: len=1; bufptr=0x2b92891211fd; hex= 80; asc  ;;
 33: SQL NULL;
 34: len=4; bufptr=0x2b92891211fe; hex= 80000004; asc     ;;
 35: SQL NULL;
 36: SQL NULL;
 37: len=1; bufptr=0x2b9289121202; hex= 80; asc  ;;
 38: len=1; bufptr=0x2b9289121203; hex= 80; asc  ;;
 39: SQL NULL;
 40: len=2; bufptr=0x2b9289121204; hex= 5b5d; asc [];;
 41: len=8; bufptr=0x2b9289121206; hex= 000000000000d03f; asc        ?;;
 42: len=8; bufptr=0x2b928912120e; hex= 85eb51b81e852340; asc   Q   #@;;
 43: len=1; bufptr=0x2b9289121216; hex= 80; asc  ;;
 44: len=8; bufptr=0x2b9289121217; hex= 0000000000000000; asc         ;;
 45: SQL NULL;
 46: SQL NULL;
 47: len=11; bufptr=0x2b928912121f; hex= 6d65726368616e64697365; asc merchandise;;
 48: SQL NULL;
 49: SQL NULL;
 50: SQL NULL;
 51: len=1; bufptr=0x2b928912122a; hex= 80; asc  ;;
 52: SQL NULL;
 53: len=7; bufptr=0x2b928912122b; hex= 726567756c6172; asc regular;;
 54: len=1; bufptr=0x2b9289121232; hex= 80; asc  ;;
 55: len=4; bufptr=0x2b9289121233; hex= 6e6f6e65; asc none;;
 56: SQL NULL;
 57: SQL NULL;
 58: len=1; bufptr=0x2b9289121237; hex= 80; asc  ;;
 59: len=8; bufptr=0x2b9289121238; hex= 0000000000000000; asc         ;;
 60: len=1; bufptr=0x2b9289121240; hex= 80; asc  ;;
 61: len=1; bufptr=0x2b9289121241; hex= 35; asc 5;;
 62: SQL NULL;
 63: SQL NULL;
 64: SQL NULL;

*** (2) TRANSACTION:
TRANSACTION 10687460003, ACTIVE 170 sec fetching rows
mysql tables in use 1, locked 1
LOCK WAIT 539126 lock struct(s), heap size 1136, 33991723 row lock(s), undo log entries 17483
MySQL thread id 51821776, OS thread handle 48004332271360, query id 6483417511 10.100.168.78 shipmonk-prod updating
UPDATE f_order SET validation = (validation & 223) WHERE id IN (14797757, 14800016, 14800323, 14800583, 14800747, 14801236, 14801583, 14801597, 14801601, 14801605, 14801610, 14801618, 14801623, 14801627, 14801635, 14801639, 14801648, 14801652, 14801657, 14801666, 14801671, 14801675, 14801685, 14801692, 14801700, 14801712, 14801721, 14801727, 14801733, 14801735, 14801741, 14801745, 14801747, 14801751, 14801755, 14801760, 14801765, 14801769, 14801773, 14801780, 14801784, 14801788, 14801792, 14801796, 14801807, 14801811, 14801818, 14801819, 14801834, 14801841, 14801857, 14801870, 14801878, 14801884, 14801895, 14801902, 14801911, 14801915, 14801919, 14801927, 14801929, 14801933, 14801941, 14801945, 14801950, 14801956, 14801961, 14801965, 14801971, 14801975, 14801984, 14801987, 14801991, 14801995, 14802000, 14802005, 14802009, 14802014, 14802025, 14802029, 14802038, 14802044, 14802049, 14802053, 148
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 1801 page no 211489 n bits 0 index PRIMARY of table `shipmonk`.`fulfillment` trx id 10687460003 lock_mode X
Record lock, heap no 2 PHYSICAL RECORD: n_fields 65; compact format; info bits 0
 0: len=4; bufptr=0x2b928912008d; hex= 80e2e143; asc    C;;
 1: len=6; bufptr=0x2b9289120091; hex= 00027b369b5f; asc   {6 _;;
 2: len=7; bufptr=0x2b9289120097; hex= 320030002110e6; asc 2 0 !  ;;
 3: len=4; bufptr=0x2b928912009e; hex= 80e1e0f2; asc     ;;
 4: len=4; bufptr=0x2b92891200a2; hex= 800000c3; asc     ;;
 5: len=4; bufptr=0x2b92891200a6; hex= 8000073a; asc    :;;
 6: len=8; bufptr=0x2b92891200aa; hex= a4703d0ad7a31640; asc  p=    @;;
 7: SQL NULL;
 8: len=8; bufptr=0x2b92891200b2; hex= 9a9999999999e93f; asc        ?;;
 9: SQL NULL;
 10: len=20; bufptr=0x2b92891200ba; hex= 3631323939393934393739373436393339313939; asc 61299994979746939199;;
 11: len=8; bufptr=0x2b92891200ce; hex= 0000000000000000; asc         ;;
 12: len=5; bufptr=0x2b92891200d6; hex= 99a4ee6c2c; asc    l,;;
 13: len=4; bufptr=0x2b92891200db; hex= 80007817; asc   x ;;
 14: len=7; bufptr=0x2b92891200df; hex= 656e526f757465; asc enRoute;;
 15: len=8; bufptr=0x2b92891200e6; hex= 0ad7a3703d0a1340; asc    p=  @;;
 16: len=1; bufptr=0x2b92891200ee; hex= 81; asc  ;;
 17: len=4; bufptr=0x2b92891200ef; hex= 8000ea57; asc    W;;
 18: len=5; bufptr=0x2b92891200f3; hex= 99a5420000; asc   B  ;;
 19: len=8; bufptr=0x2b92891200f8; hex= 333333333333f73f; asc 333333 ?;;
 20: len=8; bufptr=0x2b9289120100; hex= 0000000000002540; asc       %@;;
 21: len=8; bufptr=0x2b9289120108; hex= 0000000000001240; asc        @;;
 22: len=8; bufptr=0x2b9289120110; hex= 0000000000001c40; asc        @;;
 23: len=4; bufptr=0x2b9289120118; hex= 8000073a; asc    :;;
 24: len=4; bufptr=0x2b928912011c; hex= 8000004c; asc    L;;
 25: SQL NULL;
 26: len=8; bufptr=0x2b9289120120; hex= 536869704d6f6e6b; asc ShipMonk;;
 27: SQL NULL;
 28: SQL NULL;
 29: len=5; bufptr=0x2b9289120128; hex= 99a4ee6d30; asc    m0;;
 30: len=4; bufptr=0x2b928912012d; hex= 80000001; asc     ;;
 31: len=1; bufptr=0x2b9289120131; hex= 80; asc  ;;
 32: len=1; bufptr=0x2b9289120132; hex= 80; asc  ;;
 33: SQL NULL;
 34: len=4; bufptr=0x2b9289120133; hex= 80000004; asc     ;;
 35: len=5; bufptr=0x2b9289120137; hex= 99a4f5056b; asc     k;;
 36: len=5; bufptr=0x2b928912013c; hex= 99a4f5056b; asc     k;;
 37: len=1; bufptr=0x2b9289120141; hex= 80; asc  ;;
 38: len=1; bufptr=0x2b9289120142; hex= 80; asc  ;;
 39: len=5; bufptr=0x2b9289120143; hex= 99a5a280de; asc      ;;
 40: len=2; bufptr=0x2b9289120148; hex= 5b5d; asc [];;
 41: len=8; bufptr=0x2b928912014a; hex= d7a3703d0ad7d33f; asc   p=   ?;;
 42: len=8; bufptr=0x2b9289120152; hex= 5c8fc2f528dc2640; asc \   ( &@;;
 43: len=1; bufptr=0x2b928912015a; hex= 80; asc  ;;
 44: len=8; bufptr=0x2b928912015b; hex= 0000000000000000; asc         ;;
 45: len=5; bufptr=0x2b9289120163; hex= 99a4ee6c2c; asc    l,;;
 46: SQL NULL;
 47: len=11; bufptr=0x2b9289120168; hex= 6d65726368616e64697365; asc merchandise;;
 48: SQL NULL;
 49: SQL NULL;
 50: SQL NULL;
 51: len=1; bufptr=0x2b9289120173; hex= 80; asc  ;;
 52: len=7; bufptr=0x2b9289120174; hex= 726567756c6172; asc regular;;
 53: len=7; bufptr=0x2b928912017b; hex= 726567756c6172; asc regular;;
 54: len=1; bufptr=0x2b9289120182; hex= 80; asc  ;;
 55: len=8; bufptr=0x2b9289120183; hex= 7265736f6c766564; asc resolved;;
 56: SQL NULL;
 57: SQL NULL;
 58: len=1; bufptr=0x2b928912018b; hex= 81; asc  ;;
 59: len=8; bufptr=0x2b928912018c; hex= 0000000000000000; asc         ;;
 60: len=1; bufptr=0x2b9289120194; hex= 80; asc  ;;
 61: len=1; bufptr=0x2b9289120195; hex= 38; asc 8;;
 62: SQL NULL;
 63: len=4; bufptr=0x2b9289120196; hex= 8000e3b3; asc     ;;
 64: SQL NULL;

[bitmap of 256 bytes in hex: fe ff ff ff ff ff df 3f 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ]
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1788 page no 257431 n bits 0 index PRIMARY of table `shipmonk`.`f_order` trx id 10687460003 lock_mode X waiting
Record lock, heap no 5 PHYSICAL RECORD: n_fields 60; compact format; info bits 0
 0: len=4; bufptr=0x2b9aa005c400; hex= 80e1e102; asc     ;;
 1: len=6; bufptr=0x2b9aa005c404; hex= 00027d065785; asc   } W ;;
 2: len=7; bufptr=0x2b9aa005c40a; hex= 43000008052f6e; asc C    /n;;
 3: len=4; bufptr=0x2b9aa005c411; hex= 81d9a12f; asc    /;;
 4: SQL NULL;
 5: len=4; bufptr=0x2b9aa005c415; hex= 800019d7; asc     ;;
 6: len=4; bufptr=0x2b9aa005c419; hex= 8000000f; asc     ;;
 7: SQL NULL;
 8: len=25; bufptr=0x2b9aa005c41d; hex= 535f323431313237393638355f4f5f32343131323739313231; asc S_2411279685_O_2411279121;;
 9: len=10; bufptr=0x2b9aa005c436; hex= 32343131323739363835; asc 2411279685;;
 10: len=5; bufptr=0x2b9aa005c440; hex= 99a5a00000; asc      ;;
 11: len=16; bufptr=0x2b9aa005c445; hex= 70656e64696e675f6261746368696e67; asc pending_batching;;
 12: SQL NULL;
 13: len=22; bufptr=0x2b9aa005c455; hex= 732e726565733140626c75656d6172626c652e6e6574; asc s.rees1@bluemarble.net;;
 14: len=8; bufptr=0x2b9aa005c46b; hex= 0000000000c04240; asc       B@;;
 15: SQL NULL;
 16: len=4; bufptr=0x2b9aa005c473; hex= 6e6f6e65; asc none;;
 17: len=8; bufptr=0x2b9aa005c477; hex= 0000000000000000; asc         ;;
 18: len=8; bufptr=0x2b9aa005c47f; hex= 0000000000000000; asc         ;;
 19: len=4; bufptr=0x2b9aa005c487; hex= 800000df; asc     ;;
 20: len=5; bufptr=0x2b9aa005c48b; hex= 99a490a0e8; asc      ;;
 21: len=5; bufptr=0x2b9aa005c490; hex= 99a5aa7aeb; asc    z ;;
 22: len=8; bufptr=0x2b9aa005c495; hex= 0000000000c04240; asc       B@;;
 23: len=1; bufptr=0x2b9aa005c49d; hex= 80; asc  ;;
 24: SQL NULL;
 25: SQL NULL;
 26: len=1; bufptr=0x2b9aa005c49e; hex= 81; asc  ;;
 27: SQL NULL;
 28: len=6; bufptr=0x2b9aa005c49f; hex= 613a303a7b7d; asc a:0:{};;
 29: len=8; bufptr=0x2b9aa005c4a5; hex= 726567756c6c6172; asc regullar;;
 30: len=4; bufptr=0x2b9aa005c4ad; hex= 8000d066; asc    f;;
 31: len=1; bufptr=0x2b9aa005c4b1; hex= 80; asc  ;;
 32: len=7; bufptr=0x2b9aa005c4b2; hex= 62617463686564; asc batched;;
 33: len=4; bufptr=0x2b9aa005c4b9; hex= 80000000; asc     ;;
 34: SQL NULL;
 35: SQL NULL;
 36: len=1; bufptr=0x2b9aa005c4bd; hex= 80; asc  ;;
 37: len=4; bufptr=0x2b9aa005c4be; hex= 80e2e153; asc    S;;
 38: len=1; bufptr=0x2b9aa005c4c2; hex= 80; asc  ;;
 39: SQL NULL;
 40: SQL NULL;
 41: len=1; bufptr=0x2b9aa005c4c3; hex= 80; asc  ;;
 42: len=1; bufptr=0x2b9aa005c4c4; hex= 81; asc  ;;
 43: SQL NULL;
 44: len=1; bufptr=0x2b9aa005c4c5; hex= 80; asc  ;;
 45: len=4; bufptr=0x2b9aa005c4c6; hex= 80001095; asc     ;;
 46: SQL NULL;
 47: len=4; bufptr=0x2b9aa005c4ca; hex= 80000001; asc     ;;
 48: len=1; bufptr=0x2b9aa005c4ce; hex= 80; asc  ;;
 49: SQL NULL;
 50: len=4; bufptr=0x2b9aa005c4cf; hex= 8074e969; asc  t i;;
 51: len=2; bufptr=0x2b9aa005c4d3; hex= 3132; asc 12;;
 52: len=29; bufptr=0x2b9aa005c4d5; hex= 42617463682030322f30312f32303230202d2030332f30312f32303230; asc Batch 02/01/2020 - 03/01/2020;;
 53: len=13; bufptr=0x2b9aa005c4f2; hex= 53696e676c6573537761672829; asc SinglesSwag();;
 54: len=8; bufptr=0x2b9aa005c4ff; hex= 696d706f72746564; asc imported;;
 55: len=7; bufptr=0x2b9aa005c507; hex= 726567756c6172; asc regular;;
 56: SQL NULL;
 57: len=1; bufptr=0x2b9aa005c50e; hex= 80; asc  ;;
 58: SQL NULL;
 59: SQL NULL;

------------
TRANSACTIONS
------------
Trx id counter 10687939671
Purge done for trx's n:o < 10686496542 undo n:o < 0 state: running
History list length 681681
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (write thread)
I/O thread 7 state: waiting for i/o request (write thread)
I/O thread 8 state: waiting for i/o request (write thread)
I/O thread 9 state: waiting for i/o request (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
1492950 OS file reads, 1492966 OS file writes, 16 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 39 merges
merged operations:
 insert 0, delete mark 0, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 23803883, node heap has 0 buffer(s)
Hash table size 23803883, node heap has 0 buffer(s)
Hash table size 23803883, node heap has 0 buffer(s)
Hash table size 23803883, node heap has 0 buffer(s)
Hash table size 23803883, node heap has 0 buffer(s)
Hash table size 23803883, node heap has 0 buffer(s)
Hash table size 23803883, node heap has 0 buffer(s)
Hash table size 23803883, node heap has 0 buffer(s)
0.00 hash searches/s, 735968.34 non-hash searches/s
---
LOG
---
Log sequence number 8204
Log flushed up to   0
Pages flushed up to 8204
Last checkpoint at  8192
0 pending log flushes, 0 pending chkp writes
0 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 0
Dictionary memory allocated 2176588
Buffer pool size   5872416
Free buffers       16602
Database pages     5855814
Old database pages 2161296
Modified db pages  2434699
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 948023657, not young 6792275709
24.75 youngs/s, 1010.33 non-youngs/s
Pages read 211268265, created 129336868, written 111447242
19.00 reads/s, 4.67 creates/s, 5.33 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: 5855814, unzip_LRU len: 0
I/O sum[26784]:cur[64], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   367026
Free buffers       1049
Database pages     365977
Old database pages 135076
Modified db pages  141186
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 73245064, not young 475012276
1.42 youngs/s, 1.33 non-youngs/s
Pages read 14501845, created 8728830, written 7275254
1.33 reads/s, 0.83 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: 365977, unzip_LRU len: 0
I/O sum[1674]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   367026
Free buffers       1024
Database pages     366002
Old database pages 135086
Modified db pages  151683
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 60057657, not young 420674321
1.50 youngs/s, 1.17 non-youngs/s
Pages read 13367121, created 8057762, written 6963466
1.17 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: 366002, unzip_LRU len: 0
I/O sum[1674]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   367026
Free buffers       1057
Database pages     365969
Old database pages 135074
Modified db pages  152438
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 59797299, not young 428729085
2.33 youngs/s, 90.91 non-youngs/s
Pages read 13273443, created 8063775, written 6965154
1.17 reads/s, 0.50 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: 365969, unzip_LRU len: 0
I/O sum[1674]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   367026
Free buffers       1024
Database pages     366002
Old database pages 135086
Modified db pages  153656
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 56749324, not young 417561494
1.42 youngs/s, 0.75 non-youngs/s
Pages read 12851620, created 8012755, written 6912739
0.67 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: 366002, unzip_LRU len: 0
I/O sum[1674]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   367026
Free buffers       1023
Database pages     366003
Old database pages 135086
Modified db pages  152705
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 58784343, not young 450292737
1.58 youngs/s, 1.00 non-youngs/s
Pages read 13303286, created 8059204, written 6954118
1.00 reads/s, 0.67 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: 366003, unzip_LRU len: 0
I/O sum[1674]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   367026
Free buffers       1024
Database pages     366002
Old database pages 135086
Modified db pages  152770
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 58130595, not young 408425546
1.25 youngs/s, 2.33 non-youngs/s
Pages read 13153381, created 8025076, written 6923927
0.92 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: 366002, unzip_LRU len: 0
I/O sum[1674]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   367026
Free buffers       1042
Database pages     365984
Old database pages 135079
Modified db pages  153145
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 57543588, not young 410621977
1.58 youngs/s, 4.42 non-youngs/s
Pages read 13099537, created 8028014, written 6928875
1.58 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: 365984, unzip_LRU len: 0
I/O sum[1674]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   367026
Free buffers       1022
Database pages     366004
Old database pages 135088
Modified db pages  152840
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 58191925, not young 417350567
1.58 youngs/s, 2.50 non-youngs/s
Pages read 13090946, created 8005366, written 6946216
1.58 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: 366004, unzip_LRU len: 0
I/O sum[1674]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 8
Buffer pool size   367026
Free buffers       1023
Database pages     366003
Old database pages 135087
Modified db pages  152881
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 58270848, not young 406572935
1.75 youngs/s, 4.08 non-youngs/s
Pages read 12886937, created 8044227, written 6945479
1.25 reads/s, 0.08 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: 366003, unzip_LRU len: 0
I/O sum[1674]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 9
Buffer pool size   367026
Free buffers       1046
Database pages     365980
Old database pages 135078
Modified db pages  153160
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 57404148, not young 415603684
1.00 youngs/s, 1.00 non-youngs/s
Pages read 12901027, created 8035455, written 6939533
1.00 reads/s, 0.17 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: 365980, unzip_LRU len: 0
I/O sum[1674]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 10
Buffer pool size   367026
Free buffers       1023
Database pages     366003
Old database pages 135086
Modified db pages  152922
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 59667666, not young 436055904
1.67 youngs/s, 2.08 non-youngs/s
Pages read 13312576, created 8065365, written 6970345
0.83 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: 366003, unzip_LRU len: 0
I/O sum[1674]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 11
Buffer pool size   367026
Free buffers       1023
Database pages     366003
Old database pages 135087
Modified db pages  153042
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 57861726, not young 428313557
0.83 youngs/s, 1.83 non-youngs/s
Pages read 13300945, created 8063932, written 6965129
1.25 reads/s, 0.08 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: 366003, unzip_LRU len: 0
I/O sum[1674]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 12
Buffer pool size   367026
Free buffers       1072
Database pages     365954
Old database pages 135068
Modified db pages  152762
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 58189297, not young 411720426
1.67 youngs/s, 1.17 non-youngs/s
Pages read 12829415, created 8029490, written 6932369
0.75 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: 365954, unzip_LRU len: 0
I/O sum[1674]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 13
Buffer pool size   367026
Free buffers       1055
Database pages     365971
Old database pages 135075
Modified db pages  152910
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 59216007, not young 414074222
1.42 youngs/s, 876.26 non-youngs/s
Pages read 13093943, created 8049230, written 6950845
2.33 reads/s, 1.25 creates/s, 5.33 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 5 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 365971, unzip_LRU len: 0
I/O sum[1674]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 14
Buffer pool size   367026
Free buffers       1068
Database pages     365958
Old database pages 135069
Modified db pages  154207
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 57626891, not young 427939802
1.00 youngs/s, 1.08 non-youngs/s
Pages read 13210990, created 8029898, written 6933336
0.92 reads/s, 0.50 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: 365958, unzip_LRU len: 0
I/O sum[1674]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 15
Buffer pool size   367026
Free buffers       1027
Database pages     365999
Old database pages 135085
Modified db pages  152392
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 57287279, not young 423327176
2.75 youngs/s, 18.42 non-youngs/s
Pages read 13091253, created 8038489, written 6940457
1.25 reads/s, 0.58 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: 365999, unzip_LRU len: 0
I/O sum[1674]:cur[4], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
36 read views open inside InnoDB
Process ID=4191, Main thread ID=48004568762112, state: sleeping
Number of rows inserted 32307354375, updated 14823312543, deleted 13970056, read 4215076615898
427.71 inserts/s, 336.89 updates/s, 12.92 deletes/s, 795262.89 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================