09_00_31

=====================================
2021-04-09 09:00:31 0x2af38eda1700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 1 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 12661352 srv_active, 0 srv_shutdown, 9906 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1569447873
--Thread 47202101638912 has waited at ibuf0ibuf.cc line 4169 for 0 seconds the semaphore:
S-lock on RW-latch at 0x2aee19e3eab0 created in file buf0buf.cc line 778
a writer (thread id 47202112112384) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file ibuf0ibuf.cc line 4169
Last time write locked in file /local/p4clients/pkgbuild-hIu0i/workspace/src/RDSMySQL/storage/innobase/include/mtr0mtr.ic line 142
--Thread 47216037078784 has waited at ibuf0ibuf.cc line 3146 for 0 seconds the semaphore:
S-lock on RW-latch at 0x2aee19e3eab0 created in file buf0buf.cc line 778
a writer (thread id 47202112112384) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file ibuf0ibuf.cc line 4169
Last time write locked in file /local/p4clients/pkgbuild-hIu0i/workspace/src/RDSMySQL/storage/innobase/include/mtr0mtr.ic line 142
--Thread 47212352317184 has waited at ibuf0ibuf.cc line 3146 for 0 seconds the semaphore:
S-lock on RW-latch at 0x2aee19e3eab0 created in file buf0buf.cc line 778
a writer (thread id 47202112112384) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file ibuf0ibuf.cc line 4169
Last time write locked in file /local/p4clients/pkgbuild-hIu0i/workspace/src/RDSMySQL/storage/innobase/include/mtr0mtr.ic line 142
--Thread 47202105837312 has waited at ibuf0ibuf.cc line 4169 for 0 seconds the semaphore:
S-lock on RW-latch at 0x2aee19e3eab0 created in file buf0buf.cc line 778
a writer (thread id 47202112112384) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file ibuf0ibuf.cc line 4169
Last time write locked in file /local/p4clients/pkgbuild-hIu0i/workspace/src/RDSMySQL/storage/innobase/include/mtr0mtr.ic line 142
--Thread 47230117357312 has waited at ibuf0ibuf.cc line 4169 for 0 seconds the semaphore:
S-lock on RW-latch at 0x2aee19e3eab0 created in file buf0buf.cc line 778
a writer (thread id 47202112112384) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file ibuf0ibuf.cc line 4169
Last time write locked in file /local/p4clients/pkgbuild-hIu0i/workspace/src/RDSMySQL/storage/innobase/include/mtr0mtr.ic line 142
--Thread 47228554979072 has waited at ibuf0ibuf.cc line 3146 for 0 seconds the semaphore:
S-lock on RW-latch at 0x2aee19e3eab0 created in file buf0buf.cc line 778
a writer (thread id 47202112112384) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file ibuf0ibuf.cc line 4169
Last time write locked in file /local/p4clients/pkgbuild-hIu0i/workspace/src/RDSMySQL/storage/innobase/include/mtr0mtr.ic line 142
--Thread 47202112112384 has waited at btr0cur.cc line 274 for 0 seconds the semaphore:
X-lock on RW-latch at 0x2af6258d9948 created in file buf0buf.cc line 778
a writer (thread id 47259506972416) has reserved it in mode SX
number of readers 0, waiters flag 1, lock_word: 10000000
Last time read locked in file btr0cur.cc line 206
Last time write locked in file /local/p4clients/pkgbuild-hIu0i/workspace/src/RDSMySQL/storage/innobase/buf/buf0flu.cc line 1330
--Thread 47211909482240 has waited at ibuf0ibuf.cc line 3146 for 0 seconds the semaphore:
S-lock on RW-latch at 0x2aee19e3eab0 created in file buf0buf.cc line 778
a writer (thread id 47202112112384) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file ibuf0ibuf.cc line 4169
Last time write locked in file /local/p4clients/pkgbuild-hIu0i/workspace/src/RDSMySQL/storage/innobase/include/mtr0mtr.ic line 142
--Thread 47213488707328 has waited at ibuf0ibuf.cc line 3146 for 0 seconds the semaphore:
S-lock on RW-latch at 0x2aee19e3eab0 created in file buf0buf.cc line 778
a writer (thread id 47202112112384) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file ibuf0ibuf.cc line 4169
Last time write locked in file /local/p4clients/pkgbuild-hIu0i/workspace/src/RDSMySQL/storage/innobase/include/mtr0mtr.ic line 142
--Thread 47211356169984 has waited at ibuf0ibuf.cc line 3146 for 0 seconds the semaphore:
S-lock on RW-latch at 0x2aee19e3eab0 created in file buf0buf.cc line 778
a writer (thread id 47202112112384) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file ibuf0ibuf.cc line 4169
Last time write locked in file /local/p4clients/pkgbuild-hIu0i/workspace/src/RDSMySQL/storage/innobase/include/mtr0mtr.ic line 142
--Thread 47203244046080 has waited at ibuf0ibuf.cc line 3146 for 0 seconds the semaphore:
S-lock on RW-latch at 0x2aee19e3eab0 created in file buf0buf.cc line 778
a writer (thread id 47202112112384) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file ibuf0ibuf.cc line 4169
Last time write locked in file /local/p4clients/pkgbuild-hIu0i/workspace/src/RDSMySQL/storage/innobase/include/mtr0mtr.ic line 142
--Thread 47212351784704 has waited at ibuf0ibuf.cc line 3146 for 0 seconds the semaphore:
S-lock on RW-latch at 0x2aee19e3eab0 created in file buf0buf.cc line 778
a writer (thread id 47202112112384) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file ibuf0ibuf.cc line 4169
Last time write locked in file /local/p4clients/pkgbuild-hIu0i/workspace/src/RDSMySQL/storage/innobase/include/mtr0mtr.ic line 142
OS WAIT ARRAY INFO: signal count 1301802058
RW-shared spins 620014129, rounds 1174186191, OS waits 554625675
RW-excl spins 823355661, rounds 37366992957, OS waits 952474596
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 20194029445
Purge done for trx's n:o < 20194029445 undo n:o < 0 state: running but idle
History list length 28
LIST OF TRANSACTIONS FOR EACH SESSION:
---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 328677059521368, not started estimating records in index range
mysql tables in use 1, locked 1
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 328677059476424, 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 328677059517128, 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 328677059480664, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059496776, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059511192, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059523064, 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 328677059478120, 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 328677059601928, 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 328677059601080, 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 328677059609560, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059555288, 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 328677059606168, 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 328677059533240, 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 328677059493384, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059549352, 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 328677059573096, 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 328677059561224, 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 328677059540024, 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 328677059466248, 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 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 328677059556984, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059529848, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 328677059522216, 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 328677059535784, 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 328677059479816, 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 328677059610408, 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 328677059605320, 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 328677059482360, 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 328677059587512, 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 328677059543416, 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 328677059581576, 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 328677059528152, 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 20194029432, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1
MySQL thread id 2647129, OS thread handle 47212351784704, query id 132838098137 172.31.00.001 backend-server update
INSERT INTO <some-table>..
---TRANSACTION 20194029430, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1
MySQL thread id 2647119, OS thread handle 47211356169984, query id 132838098101 172.31.00.001 backend-server update
INSERT INTO <some-table>..
---TRANSACTION 20194029427, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
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 132838098006 172.31.00.001 backend-server update
insert into <some-table>..
---TRANSACTION 20194029409, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1
MySQL thread id 2647038, OS thread handle 47203244046080, query id 132838097637 172.31.00.002 backend-server update
INSERT INTO <some-table>..
---TRANSACTION 20194029372, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
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 132838096007 172.31.00.003 backend-server update
INSERT INTO <some-table>..
---TRANSACTION 20194029371, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
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 132838095975 172.31.18.170 backend-server updating
UPDATE <some-table> WHERE ID = '1617958831190-0242777805df-0001i'
---TRANSACTION 20194029367, ACTIVE 0 sec updating or deleting
mysql tables in use 2, locked 2
2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1
MySQL thread id 2647039, OS thread handle 47216037078784, query id 132838095823 172.31.00.003 backend-server updating
UPDATE <some-table> WHERE c.ID in ('1617958831211-02427df8f28e-0001')
---TRANSACTION 20194029360, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
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 132838095741 172.31.00.003 backend-server update
INSERT INTO <some-table>..
--------
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: complete io for buf page (read thread)
I/O thread 3 state: complete io for buf page (read thread)
I/O thread 4 state: complete io for buf page (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: complete io for buf page (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: [6, 0, 0, 0] , aio writes: [3, 0, 19, 4] ,
 ibuf aio reads:, log i/o's:, sync i/o's:
Pending flushes (fsync) log: 0; buffer pool: 727201
7183273545 OS file reads, 11005560666 OS file writes, 1050333576 OS fsyncs
0 pending preads, 2 pending pwrites
289.71 reads/s, 16384 avg bytes/read, 952.05 writes/s, 9.99 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1314, free list len 1078401, seg size 1079716, 307822648 merges
merged operations:
 insert 646577035, delete mark 1618789480, delete 505924971
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)
29792.21 hash searches/s, 12385.61 non-hash searches/s
---
LOG
---
Log sequence number          26361008863425
Log buffer assigned up to    26361008863425
Log buffer completed up to   26361008855335
Log written up to            26361008855335
Log flushed up to            26361008673352
Added dirty pages up to      26361008855335
Pages flushed up to          26360965380149
Last checkpoint at           26360965376037
7934309654 log i/o's done, 506.50 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 53872164864
Dictionary memory allocated 6838968
Buffer pool size   3211250
Free buffers       8078
Database pages     3071150
Old database pages 1133560
Modified db pages  30582
Pending reads      10
Pending writes: LRU 0, flush list 6, single page 0
Pages made young 13665072390, not young 90007509025
0.00 youngs/s, 0.00 non-youngs/s
Pages read 7183630529, created 75883052, written 2909537060
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 1 / 1000 not 6 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 3071150, unzip_LRU len: 0
I/O sum[209872]:cur[504], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   401407
Free buffers       1014
Database pages     383949
Old database pages 141713
Modified db pages  3889
Pending reads      1
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1700549980, not young 11232709613
0.00 youngs/s, 0.00 non-youngs/s
Pages read 895971223, created 9461867, written 362350936
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 1 / 1000 not 3 / 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[63], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   401406
Free buffers       1006
Database pages     383825
Old database pages 141672
Modified db pages  3740
Pending reads      0
Pending writes: LRU 0, flush list 4, single page 0
Pages made young 1710953293, not young 11343322880
0.00 youngs/s, 0.00 non-youngs/s
Pages read 909131870, created 9522908, written 371453447
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 997 / 1000, young-making rate 1 / 1000 not 10 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 383825, unzip_LRU len: 0
I/O sum[26234]:cur[63], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   401404
Free buffers       1011
Database pages     383954
Old database pages 141715
Modified db pages  3668
Pending reads      1
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1718041782, not young 11154571889
0.00 youngs/s, 0.00 non-youngs/s
Pages read 899208235, created 9462505, written 354238166
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 997 / 1000, young-making rate 2 / 1000 not 11 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 383954, unzip_LRU len: 0
I/O sum[26234]:cur[63], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   401408
Free buffers       1010
Database pages     383956
Old database pages 141718
Modified db pages  4125
Pending reads      4
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1710784613, not young 11297954657
0.00 youngs/s, 0.00 non-youngs/s
Pages read 916286337, created 9464445, written 374736768
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 998 / 1000, young-making rate 1 / 1000 not 6 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 383956, unzip_LRU len: 0
I/O sum[26234]:cur[63], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   401406
Free buffers       1015
Database pages     384010
Old database pages 141735
Modified db pages  3556
Pending reads      1
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1695980075, not young 11251573977
0.00 youngs/s, 0.00 non-youngs/s
Pages read 877978786, created 9491994, written 347535180
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 998 / 1000, young-making rate 1 / 1000 not 6 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 384010, unzip_LRU len: 0
I/O sum[26234]:cur[63], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   401406
Free buffers       998
Database pages     383740
Old database pages 141643
Modified db pages  3834
Pending reads      3
Pending writes: LRU 0, flush list 1, single page 0
Pages made young 1676872132, not young 11296909050
0.00 youngs/s, 0.00 non-youngs/s
Pages read 882846711, created 9489070, written 368125391
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 996 / 1000, young-making rate 2 / 1000 not 12 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 383740, unzip_LRU len: 0
I/O sum[26234]:cur[63], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   401407
Free buffers       1017
Database pages     383937
Old database pages 141708
Modified db pages  3746
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1729486551, not young 11322768245
0.00 youngs/s, 0.00 non-youngs/s
Pages read 897603300, created 9494223, written 357575596
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 1 / 1000 not 8 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 383937, unzip_LRU len: 0
I/O sum[26234]:cur[63], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   401406
Free buffers       1007
Database pages     383779
Old database pages 141656
Modified db pages  4024
Pending reads      0
Pending writes: LRU 0, flush list 1, single page 0
Pages made young 1722403964, not young 11107698714
0.00 youngs/s, 0.00 non-youngs/s
Pages read 904604067, created 9496040, written 373521576
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 2 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 383779, unzip_LRU len: 0
I/O sum[26234]:cur[63], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=7637, Main thread ID=47259897046784 , state=sleeping
Number of rows inserted 3187043492, updated 1761657620, deleted 2446066706, read 1162215138037
798.20 inserts/s, 209.79 updates/s, 25.97 deletes/s, 38373.63 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, 5.99 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================