=====================================
2021-04-09 09:00:32 0x2af38eda1700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 1 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 12661353 srv_active, 0 srv_shutdown, 9906 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1569447883
--Thread 47259869796096 has waited at log0write.cc line 1985 for 1 seconds the semaphore:
Mutex at 0x2aee17e6df10, Mutex LOG_WRITER created log0log.cc:525, lock var 1

OS WAIT ARRAY INFO: signal count 1301802063
RW-shared spins 620014138, rounds 1174186229, OS waits 554625693
RW-excl spins 823355661, rounds 37366992987, OS waits 952474597
RW-sx spins 7254583, rounds 21957269, OS waits 221033
Spin rounds per wait: 1.89 RW-shared, 45.38 RW-excl, 3.03 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2021-04-02 10:35:48  <section-erased>
------------------------
LATEST DETECTED DEADLOCK
------------------------
2021-04-09 07:21:56 <section-erased>
------------
TRANSACTIONS
------------
Trx id counter 20194029634
Purge done for trx's n:o < 20194029598 undo n:o < 0 state: running but idle
History list length 4
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 328677059626520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059571400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059568856, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059562072, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059506952, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059558680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059554440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059552744, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059534936, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059498472, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059548504, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059544264, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059541720, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059532392, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059530696, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059505256, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059519672, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059481512, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059467096, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059508648, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059506104, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059489992, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059501864, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059529000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059524760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059465400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059517976, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059503560, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059495080, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059492536, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059488296, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059621432, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059586664, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059512888, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059607016, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059595144, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059625672, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059624824, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059623976, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059614648, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059484904, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059623128, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059620584, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059619736, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059579880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059595992, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059565464, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059622280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059592600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059615496, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059470488, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059607864, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059591752, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059573944, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059516280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059500168, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059611256, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059608712, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059596840, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059570552, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059568008, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059547656, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059553592, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059501016, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059513736, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059537480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059545112, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059514584, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059478968, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059467944, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059618888, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059618040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059617192, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059616344, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059602776, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059600232, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059593448, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059575640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059566312, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059551048, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059560376, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059540872, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059474728, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059613800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059494232, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059597688, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059589208, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059585816, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059574792, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059536632, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059534088, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059518824, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059512040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059487448, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059504408, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059497624, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059464552, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059485752, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059483208, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059531544, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059525608, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059604472, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059603624, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059562920, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059584968, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059594296, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059590056, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059507800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059477272, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059588360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059578184, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059559528, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059556136, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059484056, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059584120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059583272, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059582424, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059545960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059579032, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059577336, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059572248, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059576488, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059495928, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059567160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059564616, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059538328, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059527304, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059509496, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059475576, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059557832, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059550200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059491688, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059523912, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059515432, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059499320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059551896, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059473032, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059546808, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059599384, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059612104, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059526456, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059502712, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059473880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059489144, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059468792, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059469640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059471336, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059539176, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059486600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059510344, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059463704, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059462008, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 20194029633, ACTIVE 0 sec
1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1
MySQL thread id 2647047, OS thread handle 47231396554496, query id 132838107858 172.31.64.160 backend-server
---TRANSACTION 20194029632, ACTIVE (PREPARED) 0 sec
1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1
MySQL thread id 2647212, OS thread handle 47210053306112, query id 132838107826 172.31.18.170 backend-server waiting for handler commit
commit
---TRANSACTION 20194029630, ACTIVE (PREPARED) 0 sec
3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 2
MySQL thread id 2647215, OS thread handle 47202686277376, query id 132838107765 172.31.00.001 backend-server waiting for handler commit
commit
---TRANSACTION 20194029629, ACTIVE (PREPARED) 0 sec
5 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 2
MySQL thread id 2647213, OS thread handle 47234970101504, query id 132838107659 172.31.00.001 backend-server waiting for handler commit
commit
---TRANSACTION 20194029628, ACTIVE (PREPARED) 0 sec
1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1
MySQL thread id 2647086, OS thread handle 47269232985856, query id 132838107620 172.31.00.004 backend-server waiting for handler commit
commit
---TRANSACTION 20194029627, ACTIVE (PREPARED) 0 sec
5 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 2
MySQL thread id 2647191, OS thread handle 47238526404352, query id 132838107601 172.31.00.001 backend-server waiting for handler commit
commit
---TRANSACTION 20194029626, ACTIVE 0 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 4 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 2647118, OS thread handle 47223582299904, query id 132838107244 172.31.00.003 backend-server statistics
SELECT m1.ID AS id, m1.CREATED AS created....
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 5702 page no 73994 n bits 128 index PRIMARY of table `messages_bucket_201910`.`THREAD_HEADER` trx id 20194029626 lock_mode X locks rec but not gap waiting
Record lock, heap no 56 PHYSICAL RECORD: n_fields 24; compact format; info bits 0
 0: len 30; hex 313537343831393339363336362d3032343230346138636335372d303030; asc 1574819396366-024204a8cc57-000; (total 31 bytes);
 1: len 30; hex 313631373934313932333631332d3032343230393266383130352d303030; asc 1617941923613-0242092f8105-000; (total 31 bytes);
 2: len 6; hex 0004b3a87031; asc     p1;;
 3: len 7; hex 01000085ab25c0; asc      % ;;
 4: len 30; hex 313631373935383833323238342d3032343230363961303762382d303030; asc 1617958832284-0242069a07b8-000; (total 32 bytes);
 5: len 6; hex 607017b00b2c; asc `p   ,;;
 6: len 6; hex 607017b00b2c; asc `p   ,;;
 7: len 30; hex 6a6520746520646974206465207072656e647265206c6573203230e282ac; asc <some-text-of-a-message> 20   ; (total 69 bytes);
 8: len 1; hex 00; asc  ;;
 9: len 1; hex 01; asc  ;;
 10: len 30; hex 313537343834333133363132312d3032343238323866383534322d303030; asc 1574843136121-0242828f8542-000; (total 31 bytes);
 11: len 11; hex 3333363434363838383635; asc 33644688865;;
 12: SQL NULL;
 13: SQL NULL;
 14: len 11; hex 3333373636363830333631; asc 33766680361;;
 15: len 1; hex 80; asc  ;;
 16: len 1; hex 80; asc  ;;
 17: SQL NULL;
 18: len 1; hex 01; asc  ;;
 19: SQL NULL;
 20: len 0; hex ; asc ;;
 21: len 1; hex 00; asc  ;;
 22: len 1; hex 00; asc  ;;
 23: len 1; hex 00; asc  ;;

------------------
---TRANSACTION 20194029625, ACTIVE 0 sec
6 lock struct(s), heap size 1136, 4 row lock(s)
MySQL thread id 2647205, OS thread handle 47232689964800, query id 132838107090 172.31.00.003 backend-server
---TRANSACTION 20194029624, ACTIVE (PREPARED) 0 sec
3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 2
MySQL thread id 2647303, OS thread handle 47203244312320, query id 132838107077 172.31.00.002 backend-server waiting for handler commit
commit
---TRANSACTION 20194029622, ACTIVE (PREPARED) 0 sec
3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 2
MySQL thread id 2647225, OS thread handle 47215757559552, query id 132838106729 172.31.00.002 backend-server waiting for handler commit
commit
---TRANSACTION 20194029620, ACTIVE (PREPARED) 0 sec
5 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 2
MySQL thread id 2647089, OS thread handle 47243220162304, query id 132838106497 172.31.00.003 backend-server waiting for handler commit
commit
---TRANSACTION 20194029619, ACTIVE (PREPARED) 0 sec
1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 2
MySQL thread id 2647102, OS thread handle 47220006786816, query id 132838106493 172.31.00.001 backend-server waiting for handler commit
commit
---TRANSACTION 20194029617, ACTIVE (PREPARED) 0 sec
3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 2
MySQL thread id 2647196, OS thread handle 47230406166272, query id 132838106382 172.31.00.002 backend-server waiting for handler commit
commit
---TRANSACTION 20194029616, ACTIVE (PREPARED) 0 sec
3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1
MySQL thread id 2647150, OS thread handle 47214763575040, query id 132838106299 172.31.00.002 backend-server waiting for handler commit
commit
---TRANSACTION 20194029615, ACTIVE (PREPARED) 0 sec
5 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 2
MySQL thread id 2647067, OS thread handle 47227554236160, query id 132838106287 172.31.00.002 backend-server waiting for handler commit
commit
---TRANSACTION 20194029613, ACTIVE (PREPARED) 0 sec
1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1
MySQL thread id 2647235, OS thread handle 47215453734656, query id 132838105965 172.31.00.002 backend-server waiting for handler commit
commit
---TRANSACTION 20194029612, ACTIVE (PREPARED) 0 sec
1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1
MySQL thread id 2647207, OS thread handle 47203678029568, query id 132838105889 172.31.00.003 backend-server waiting for handler commit
commit
---TRANSACTION 20194029611, ACTIVE (PREPARED) 0 sec
3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 2
MySQL thread id 2647059, OS thread handle 47202546161408, query id 132838105552 172.31.00.002 backend-server waiting for handler commit
commit
---TRANSACTION 20194029610, ACTIVE (PREPARED) 0 sec
2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 2
MySQL thread id 2647123, OS thread handle 47212767151872, query id 132838105498 172.31.00.001 backend-server waiting for handler commit
commit
---TRANSACTION 20194029608, ACTIVE (PREPARED) 0 sec
3 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 2647178, OS thread handle 47209634404096, query id 132838105312 172.31.00.003 backend-server waiting for handler commit
commit
---TRANSACTION 20194029607, ACTIVE (PREPARED) 0 sec
3 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 2647146, OS thread handle 47219025188608, query id 132838105214 172.31.00.002 backend-server waiting for handler commit
commit
---TRANSACTION 20194029606, ACTIVE (PREPARED) 0 sec
1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1
MySQL thread id 2647105, OS thread handle 47220007053056, query id 132838105157 172.31.00.006 backend-server waiting for handler commit
commit
---TRANSACTION 20194029605, ACTIVE (PREPARED) 0 sec
1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1
MySQL thread id 2647214, OS thread handle 47215454000896, query id 132838105051 172.31.00.001 backend-server waiting for handler commit
commit
---TRANSACTION 20194029604, ACTIVE (PREPARED) 0 sec
3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 2
MySQL thread id 2647124, OS thread handle 47213344003840, query id 132838104930 172.31.00.001 backend-server waiting for handler commit
commit
---TRANSACTION 20194029603, ACTIVE (PREPARED) 0 sec
1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1
MySQL thread id 2647251, OS thread handle 47221302961920, query id 132838104837 172.31.00.005 backend-server waiting for handler commit
commit
---TRANSACTION 20194029602, ACTIVE (PREPARED) 0 sec
5 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1
MySQL thread id 2647060, OS thread handle 47202826520320, query id 132838104809 172.31.00.002 backend-server waiting for handler commit
commit
---TRANSACTION 20194029601, ACTIVE (PREPARED) 0 sec
1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1
MySQL thread id 2647204, OS thread handle 47204093458176, query id 132838104740 172.31.00.005 backend-server waiting for handler commit
commit
---TRANSACTION 20194029600, ACTIVE (PREPARED) 0 sec
3 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 2647239, OS thread handle 47225562343168, query id 132838104719 172.31.00.005 backend-server waiting for handler commit
commit
---TRANSACTION 20194029599, ACTIVE (PREPARED) 0 sec
3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 2
MySQL thread id 2647066, OS thread handle 47233393043200, query id 132838104698 172.31.00.002 backend-server waiting for handler commit
commit
---TRANSACTION 20194029598, ACTIVE (PREPARED) 0 sec
3 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 2647294, OS thread handle 47230117357312, query id 132838104676 52.16.20.7 backend-server waiting for handler commit
commit
---TRANSACTION 20194029586, ACTIVE (PREPARED) 0 sec
2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1
MySQL thread id 2647125, OS thread handle 47212188804864, query id 132838104686 172.31.00.001 backend-server waiting for handler commit
commit
---TRANSACTION 20194029547, ACTIVE (PREPARED) 1 sec
1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1
MySQL thread id 2647258, OS thread handle 47228837762816, query id 132838104677 52.16.20.7 backend-server waiting for handler commit
commit
---TRANSACTION 20194029505, ACTIVE (PREPARED) 1 sec
1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1
MySQL thread id 2647203, OS thread handle 47230827960064, query id 132838104718 172.31.00.005 backend-server waiting for handler commit
commit
---TRANSACTION 20194029465, ACTIVE (PREPARED) 1 sec
3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 2
MySQL thread id 2647052, OS thread handle 47232535373568, query id 132838104735 172.31.00.003 backend-server waiting for handler commit
commit
---TRANSACTION 20194029432, ACTIVE (PREPARED) 1 sec
1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 2
MySQL thread id 2647129, OS thread handle 47212351784704, query id 132838104713 172.31.00.001 backend-server waiting for handler commit
commit
---TRANSACTION 20194029430, ACTIVE (PREPARED) 1 sec
2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 2
MySQL thread id 2647119, OS thread handle 47211356169984, query id 132838104701 172.31.00.001 backend-server waiting for handler commit
commit
---TRANSACTION 20194029427, ACTIVE (PREPARED) 1 sec
1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1
MySQL thread id 2647174, OS thread handle 47212352317184, query id 132838104662 172.31.00.001 backend-server waiting for handler commit
commit
---TRANSACTION 20194029409, ACTIVE (PREPARED) 1 sec
2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 2
MySQL thread id 2647038, OS thread handle 47203244046080, query id 132838104679 172.31.00.002 backend-server waiting for handler commit
commit
---TRANSACTION 20194029372, ACTIVE (PREPARED) 1 sec
1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1
MySQL thread id 2647035, OS thread handle 47211909482240, query id 132838104663 172.31.00.003 backend-server waiting for handler commit
commit
---TRANSACTION 20194029371, ACTIVE (PREPARED) 1 sec
2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1
MySQL thread id 2647206, OS thread handle 47228554979072, query id 132838104693 172.31.18.170 backend-server waiting for handler commit
commit
---TRANSACTION 20194029367, ACTIVE (PREPARED) 1 sec
4 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 3
MySQL thread id 2647039, OS thread handle 47216037078784, query id 132838104700 172.31.00.003 backend-server waiting for handler commit
commit
---TRANSACTION 20194029360, ACTIVE (PREPARED) 1 sec
1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1
MySQL thread id 2647093, OS thread handle 47213488707328, query id 132838104660 172.31.00.003 backend-server waiting for handler commit
commit
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (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, 1, 0] ,
 ibuf aio reads:, log i/o's:, sync i/o's:
Pending flushes (fsync) log: 2; buffer pool: 727203
7183274512 OS file reads, 11005560994 OS file writes, 1050333670 OS fsyncs
1 pending preads, 2 pending pwrites
966.03 reads/s, 16384 avg bytes/read, 327.67 writes/s, 93.91 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1311, free list len 1078404, seg size 1079716, 307822669 merges
merged operations:
 insert 646577082, delete mark 1618789506, delete 505924997
discarded operations:
 insert 12124, delete mark 486, delete 477
Hash table size 13015603, node heap has 7691 buffer(s)
Hash table size 13015603, node heap has 7378 buffer(s)
Hash table size 13015603, node heap has 24013 buffer(s)
Hash table size 13015603, node heap has 33521 buffer(s)
Hash table size 13015603, node heap has 9205 buffer(s)
Hash table size 13015603, node heap has 4952 buffer(s)
Hash table size 13015603, node heap has 37541 buffer(s)
Hash table size 13015603, node heap has 7721 buffer(s)
833.17 hash searches/s, 1822.18 non-hash searches/s
---
LOG
---
Log sequence number          26361008926401
Log buffer assigned up to    26361008926401
Log buffer completed up to   26361008855335
Log written up to            26361008855335
Log flushed up to            26361008673352
Added dirty pages up to      26361008926401
Pages flushed up to          26360965380149
Last checkpoint at           26360965376037
7934309654 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 53872164864
Dictionary memory allocated 6838968
Buffer pool size   3211250
Free buffers       7201
Database pages     3072027
Old database pages 1134160
Modified db pages  30651
Pending reads      1
Pending writes: LRU 0, flush list 3, single page 0
Pages made young 13665072425, not young 90007511774
0.00 youngs/s, 0.00 non-youngs/s
Pages read 7183631415, created 75883052, written 2909537063
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 935 / 1000, young-making rate 2 / 1000 not 203 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 3072027, unzip_LRU len: 0
I/O sum[209872]:cur[7464], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   401407
Free buffers       905
Database pages     384058
Old database pages 141790
Modified db pages  3893
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1700549984, not young 11232709983
0.00 youngs/s, 0.00 non-youngs/s
Pages read 895971333, created 9461867, written 362350936
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 963 / 1000, young-making rate 1 / 1000 not 125 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 384058, unzip_LRU len: 0
I/O sum[26234]:cur[933], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   401406
Free buffers       914
Database pages     383917
Old database pages 141739
Modified db pages  3746
Pending reads      0
Pending writes: LRU 0, flush list 1, single page 0
Pages made young 1710953297, not young 11343323191
0.00 youngs/s, 0.00 non-youngs/s
Pages read 909131962, created 9522908, written 371453450
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 922 / 1000, young-making rate 3 / 1000 not 264 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 383917, unzip_LRU len: 0
I/O sum[26234]:cur[933], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   401404
Free buffers       900
Database pages     384065
Old database pages 141793
Modified db pages  3680
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1718041786, not young 11154572181
0.00 youngs/s, 0.00 non-youngs/s
Pages read 899208347, created 9462505, written 354238166
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 916 / 1000, young-making rate 3 / 1000 not 220 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 384065, unzip_LRU len: 0
I/O sum[26234]:cur[933], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   401408
Free buffers       904
Database pages     384062
Old database pages 141792
Modified db pages  4139
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1710784618, not young 11297954995
0.00 youngs/s, 0.00 non-youngs/s
Pages read 916286447, created 9464445, written 374736768
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 912 / 1000, young-making rate 4 / 1000 not 273 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 384062, unzip_LRU len: 0
I/O sum[26234]:cur[933], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   401406
Free buffers       901
Database pages     384124
Old database pages 141815
Modified db pages  3562
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1695980081, not young 11251574338
0.00 youngs/s, 0.00 non-youngs/s
Pages read 877978901, created 9491994, written 347535180
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 929 / 1000, young-making rate 3 / 1000 not 223 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 384124, unzip_LRU len: 0
I/O sum[26234]:cur[933], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   401406
Free buffers       883
Database pages     383855
Old database pages 141716
Modified db pages  3846
Pending reads      1
Pending writes: LRU 0, flush list 1, single page 0
Pages made young 1676872138, not young 11296909406
0.00 youngs/s, 0.00 non-youngs/s
Pages read 882846828, created 9489070, written 368125391
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 917 / 1000, young-making rate 4 / 1000 not 252 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 383855, unzip_LRU len: 0
I/O sum[26234]:cur[933], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   401407
Free buffers       957
Database pages     383997
Old database pages 141765
Modified db pages  3757
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1729486554, not young 11322768428
0.00 youngs/s, 0.00 non-youngs/s
Pages read 897603360, created 9494223, written 357575596
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 944 / 1000, young-making rate 2 / 1000 not 171 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 383997, unzip_LRU len: 0
I/O sum[26234]:cur[933], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   401406
Free buffers       837
Database pages     383949
Old database pages 141750
Modified db pages  4028
Pending reads      0
Pending writes: LRU 0, flush list 1, single page 0
Pages made young 1722403967, not young 11107699252
0.00 youngs/s, 0.00 non-youngs/s
Pages read 904604237, created 9496040, written 373521576
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 938 / 1000, young-making rate 1 / 1000 not 199 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 383949, unzip_LRU len: 0
I/O sum[26234]:cur[933], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Process ID=7637, Main thread ID=47259897046784 , state=sleeping
Number of rows inserted 3187043523, updated 1761657644, deleted 2446066710, read 1162215163723
30.97 inserts/s, 23.98 updates/s, 4.00 deletes/s, 25660.34 reads/s
Number of system rows inserted 10705, updated 62310, deleted 6922, read 67370864
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================