SHOW ENGINE INNODB STATUS;

| InnoDB |      |
=====================================
2022-04-14 14:39:03 0x14666b86b700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 25 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 1227928 srv_active, 0 srv_shutdown, 205 srv_idle
srv_master_thread log flush and writes: 1228133
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1884739
OS WAIT ARRAY INFO: signal count 11171689
RW-shared spins 0, rounds 5184517, OS waits 612256
RW-excl spins 0, rounds 59122629, OS waits 964748
RW-sx spins 45445, rounds 628055, OS waits 14655
Spin rounds per wait: 5184517.00 RW-shared, 59122629.00 RW-excl, 13.82 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 10788570
Purge done for trx's n:o < 10788569 undo n:o < 0 state: running but idle
History list length 1
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 303910384574640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384545200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384315200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384539680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384426520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384367640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384317960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384307840, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384526800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384482640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384524960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384513920, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384501960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384414560, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384458720, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384443080, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384481720, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384474360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384342800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384467920, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384448600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384464240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384457800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384310600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384455040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384445840, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384444920, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384333600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384372240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384432960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384363040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384444000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384419160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384408120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384344640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384309680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384429280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384358440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384352920, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384348320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384311520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384386960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384313360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384335440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384308760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384334520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384639040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384637200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384636280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384635360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384634440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384633520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384632600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384631680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384630760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384629840, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384626160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384618800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384616040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384615120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384613280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384612360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384385120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384386040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384455960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384604080, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384378680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384361200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384498280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384492760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384575560, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384484480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384368560, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384409960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384418240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384564520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384325320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384628000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384625240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384624320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384620640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384607760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384603160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384601320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384595800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384594880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384593960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384592120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384589360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384587520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384586600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384584760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384583840, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384582920, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384582000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384581080, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384580160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384579240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384578320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384577400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384573720, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384571880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384570960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384570040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384568200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384567280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384469760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384566360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384565440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384563600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384562680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384561760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384560840, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384559920, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384558080, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384557160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384554400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384553480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384552560, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384551640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384550720, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384549800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384547960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384542440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384547040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384544280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384541520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384536000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384537840, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384535080, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384534160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384533240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384528640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384525880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384524040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384522200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384520360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384519440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384518520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384517600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384424680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384513000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384510240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384509320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384506560, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384505640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384504720, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384503800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384502880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384501040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384500120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384497360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384496440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384499200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384493680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384491840, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384435720, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384332680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384490920, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384490000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384488160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384487240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384486320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384485400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384483560, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384479880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384446760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384380520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384403520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384391560, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384388800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384478040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384477120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384476200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384343720, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384319800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384475280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384473440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384468840, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384462400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384460560, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384459640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384383280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384454120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384453200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384452280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384362120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384450440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384389720, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384449520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384442160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384381440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384341880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384407200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384375920, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384402600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384363960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384360280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384441240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384420080, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384350160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384398000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384409040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384437560, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384340040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384406280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384394320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384356600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384336360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384351080, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384316120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384410880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384392480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384329000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384364880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384359360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384398920, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384314280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384436640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384331760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384321640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384434800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384432040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384431120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384340960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384357520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384415480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384339120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384337280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384427440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384421920, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384399840, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384355680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384390640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384374080, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384370400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384395240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384379600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384328080, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384317040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384377760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384369480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384371320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384423760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384373160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384330840, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384354760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384417320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384375000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384548880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384543360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384531400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384521280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384507480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384494600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384312440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384489080, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384466080, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384471600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384467000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384465160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384438480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384430200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384318880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384428360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384422840, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384396160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384404440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384382360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384353840, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384352000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384324400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384401680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384530480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384413640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384397080, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384461480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384411800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384515760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384349240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384329920, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384511160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384470680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384326240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384529560, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384365800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384421000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384527720, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384480800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384347400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384523120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384508400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384425600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384433880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384478960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384447680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384393400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384387880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384366720, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384463320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384327160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384439400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384556240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384512080, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384495520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384546120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384514840, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384472520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384605000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384384200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384610520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384602240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384516680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384376840, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384346480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384451360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384540600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384345560, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384405360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384440320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384400760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384538760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384323480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384536920, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384322560, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384559000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384532320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384591200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384572800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384338200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384416400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384456880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384412720, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384555320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384617880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384616960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384306920, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 303910384306000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
 ibuf aio reads:, log i/o's:, sync i/o's:
Pending flushes (fsync) log: 0; buffer pool: 0
1480032 OS file reads, 18351462 OS file writes, 1201886 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.16 writes/s, 0.16 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 42911, seg size 42913, 269267 merges
merged operations:
 insert 939502, delete mark 117178516, delete 3147032
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 1328213, node heap has 9 buffer(s)
Hash table size 1328213, node heap has 2 buffer(s)
Hash table size 1328213, node heap has 16 buffer(s)
Hash table size 1328213, node heap has 5 buffer(s)
Hash table size 1328213, node heap has 2 buffer(s)
Hash table size 1328213, node heap has 10447 buffer(s)
Hash table size 1328213, node heap has 68 buffer(s)
Hash table size 1328213, node heap has 9207 buffer(s)
0.12 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 3820212676968
Log flushed up to   3820212676968
Pages flushed up to 3820212607137
Last checkpoint at  3820212607128
0 pending log flushes, 0 pending chkp writes
257779 log i/o's done, 0.16 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 5497159680
Dictionary memory allocated 725676
Buffer pool size   327680
Free buffers       65999
Database pages     241925
Old database pages 89160
Modified db pages  174
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1866571, not young 1376687066
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1479901, created 708186, written 17564409
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 241925, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   40960
Free buffers       8347
Database pages     30181
Old database pages 11122
Modified db pages  84
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 240330, not young 203181115
0.00 youngs/s, 0.00 non-youngs/s
Pages read 209903, created 89176, written 2461867
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30181, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   40960
Free buffers       8276
Database pages     30241
Old database pages 11150
Modified db pages  1
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 230726, not young 176032332
0.00 youngs/s, 0.00 non-youngs/s
Pages read 187172, created 89414, written 2050430
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30241, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   40960
Free buffers       8291
Database pages     30225
Old database pages 11139
Modified db pages  6
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 229334, not young 170960464
0.00 youngs/s, 0.00 non-youngs/s
Pages read 184718, created 90135, written 1868589
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30225, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   40960
Free buffers       8189
Database pages     30277
Old database pages 11158
Modified db pages  26
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 233366, not young 177215263
0.00 youngs/s, 0.00 non-youngs/s
Pages read 191056, created 89788, written 2521045
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30277, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   40960
Free buffers       8310
Database pages     30249
Old database pages 11147
Modified db pages  28
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 235293, not young 173729909
0.00 youngs/s, 0.00 non-youngs/s
Pages read 190568, created 85940, written 2391820
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30249, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   40960
Free buffers       8102
Database pages     30320
Old database pages 11172
Modified db pages  4
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 237477, not young 145284964
0.00 youngs/s, 0.00 non-youngs/s
Pages read 168072, created 87004, written 1876599
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30320, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   40960
Free buffers       8290
Database pages     30211
Old database pages 11132
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 231148, not young 179659550
0.00 youngs/s, 0.00 non-youngs/s
Pages read 182471, created 88014, written 2283899
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30211, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   40960
Free buffers       8194
Database pages     30221
Old database pages 11140
Modified db pages  25
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 228897, not young 150623469
0.00 youngs/s, 0.00 non-youngs/s
Pages read 165941, created 88715, written 2110160
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30221, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
2 read views open inside InnoDB
Process ID=18854, Main thread ID=22429342619392, state: sleeping
Number of rows inserted 583726868, updated 8144, deleted 140104586, read 1833333581
375.46 inserts/s, 0.04 updates/s, 0.00 deletes/s, 378.02 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================