*************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2017-11-06 20:52:13 0x7f19de4d2700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 35 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 392 srv_active, 0 srv_shutdown, 4 srv_idle srv_master_thread log flush and writes: 396 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 689881 --Thread 139753780819712 has waited at btr0cur.cc line 1010 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x7f1ad00156d0 created in file dict0dict.cc line 2598 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file btr0cur.cc line 1010 Last time write locked in file btr0cur.cc line 969 --Thread 139753646601984 has waited at btr0cur.cc line 1010 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x7f1ad00156d0 created in file dict0dict.cc line 2598 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file btr0cur.cc line 1010 Last time write locked in file btr0cur.cc line 969 OS WAIT ARRAY INFO: signal count 809218 RW-shared spins 0, rounds 1251680, OS waits 357904 RW-excl spins 0, rounds 15626579, OS waits 331085 RW-sx spins 7611, rounds 150456, OS waits 2411 Spin rounds per wait: 1251680.00 RW-shared, 15626579.00 RW-excl, 19.77 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 49010198591 Purge done for trx's n:o < 48977743302 undo n:o < 0 state: running History list length 4497348 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421430515006920, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515006016, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515003304, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430514996072, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515034040, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515026808, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515022288, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515020480, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515017768, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430514990648, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515002400, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515015960, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515014152, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430514994264, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515040368, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515018672, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515038560, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515037656, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515034944, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515032232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515009632, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515030424, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515013248, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515011440, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515025000, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430514989744, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515028616, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515023192, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430514998784, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430514993360, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515004208, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515012344, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430514999688, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515025904, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515001496, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430514996976, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515035848, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515033136, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515029520, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515005112, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515214840, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516983064, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516993008, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516951424, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430517065328, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430517011992, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430517009280, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430517005664, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516996624, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516981256, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515455304, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516966792, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516503040, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516738080, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515786168, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516932440, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516291504, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516087200, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515717464, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516814920, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516142344, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516390944, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516926112, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516914360, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516903512, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516476824, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516894472, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516890856, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516848368, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515531240, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515719272, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515797016, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516761584, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516576264, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516531064, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515838600, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515010536, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515024096, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515542088, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515703000, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516693784, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515954312, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515584576, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515059352, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515733736, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515070200, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516292408, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516712768, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515173256, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516293312, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516060080, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515697576, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515985952, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516073640, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515170544, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516441568, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516394560, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516389136, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515654184, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515842216, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515667744, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515931712, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516352976, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515861200, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516371960, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515608984, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516191160, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515124440, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516361112, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515914536, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516360208, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516359304, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515991376, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515900976, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515686728, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515526720, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515707520, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515911824, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516349360, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516154096, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430514997880, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516344840, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515665936, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516018496, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515949792, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516335800, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516329472, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515758144, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515737352, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516195680, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515409200, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515725600, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515590000, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515905496, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515862104, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515810576, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516313200, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515774416, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516279752, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516278848, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516277040, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516267096, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516266192, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516043808, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516254440, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515181392, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515201280, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516240880, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515689440, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516226416, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516179408, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515451688, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515744584, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516039288, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516217376, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515468864, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516209240, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516202008, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516134208, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516186640, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516182120, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515945272, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515439936, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516173984, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515834080, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515414624, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516155000, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515078336, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516151384, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515661416, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516147768, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515243768, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516140536, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515582768, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516133304, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516131496, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516123360, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515602656, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515476096, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515398352, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515593616, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515130768, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516098952, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516094432, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516070928, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515450784, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516065504, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516055560, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515840408, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515721984, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516028440, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430516023016, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515998608, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515996800, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515986856, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515787976, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515970584, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515216648, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515962448, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515950696, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515947080, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515942560, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515939848, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515926288, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515925384, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515517680, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515458016, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515913632, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515901880, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515899168, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515885608, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515881992, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515869336, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515863008, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515859392, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515258232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515834984, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515846736, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515841312, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515646048, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515839504, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515504120, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515752720, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515823232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515819616, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515031328, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515371232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515473384, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515393832, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515008728, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515796112, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515238344, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515086472, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515780744, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515453496, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515771704, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430515194048, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421430514988840, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 49010198586, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 2 row lock(s) MySQL thread id 220030, OS thread handle 0x7f19999b9700, query id 7615464 172.16.77.77 db_user_1 cleaning up ---TRANSACTION 49010198561, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 2 row lock(s) MySQL thread id 220021, OS thread handle 0x7f160ae5d700, query id 7615192 172.16.77.77 db_user_1 cleaning up Trx read view will not see trx with id >= 49010198569, sees < 49010170896 ---TRANSACTION 49010198516, ACTIVE 0 sec 6 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 4 MySQL thread id 220009, OS thread handle 0x7f19995ad700, query id 7615442 172.16.77.123 db_user_1 cleaning up Trx read view will not see trx with id >= 49010198528, sees < 49010170896 ---TRANSACTION 49010196292, ACTIVE 4 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 218318, OS thread handle 0x7f16f23ab700, query id 7554096 172.16.77.106 db_user_1 statistics select * from `table_4` where `id` = '155968185' limit 1 for update ------- TRX HAS BEEN WAITING 4 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 339 page no 7253841 n bits 112 index PRIMARY of table `db_1`.`table_4` trx id 49010196292 lock_mode X locks rec but not gap waiting Record lock, heap no 23 PHYSICAL RECORD: n_fields 47; compact format; info bits 0 0: len 4; hex 094be2b9; asc K ;; 1: len 6; hex 000b693bdc10; asc i; ;; 2: len 7; hex 440004776d2db8; asc D wm- ;; 3: len 4; hex 80862107; asc ! ;; 4: len 4; hex 8001e61d; asc ;; 5: len 8; hex 0a8d1656e0dd4140; asc V A@;; 6: len 8; hex e5af3500c0a94940; asc 5 I@;; 7: len 4; hex 80000000; asc ;; 8: len 0; hex ; asc ;; 9: len 30; hex d9bed8b1d8afdb8cd8b320d8b3db8cd986d985d8a7db8cdb8c20d8b2d986; asc ; (total 104 bytes); 10: len 8; hex ed1008ebd7dd4140; asc A@;; 11: len 8; hex 4f4c167f47ae4940; asc OL G I@;; 12: len 4; hex 80000000; asc ;; 13: len 0; hex ; asc ;; 14: len 30; hex d88c20d8aad987d8b1d8a7d986d88c20d8aad987d8b1d8a7d986d88c20d9; asc ; (total 79 bytes); 15: len 1; hex 80; asc ;; 16: len 1; hex 80; asc ;; 17: len 1; hex 80; asc ;; 18: len 1; hex 80; asc ;; 19: len 4; hex 80000000; asc ;; 20: len 4; hex 80000000; asc ;; 21: len 4; hex 800014dd; asc ;; 22: len 4; hex 80014c08; asc L ;; 23: len 4; hex 80012230; asc "0;; 24: len 1; hex 81; asc ;; 25: len 1; hex 80; asc ;; 26: len 14; hex 534e502d3935332d393535353633; asc XXXX153X91563;; 27: len 1; hex 81; asc ;; 28: len 4; hex 80000000; asc ;; 29: len 4; hex 80000000; asc ;; 30: len 8; hex 0000000000000000; asc ;; 31: len 8; hex 0000000000000000; asc ;; 32: len 1; hex 80; asc ;; 33: len 1; hex 80; asc ;; 34: len 1; hex 80; asc ;; 35: len 1; hex 80; asc ;; 36: len 0; hex ; asc ;; 37: len 8; hex 0000000000000000; asc ;; 38: len 8; hex 0000000000000000; asc ;; 39: len 4; hex 80000000; asc ;; 40: len 0; hex ; asc ;; 41: len 4; hex 80000000; asc ;; 42: len 4; hex 80000000; asc ;; 43: len 4; hex 80000000; asc ;; 44: len 1; hex 80; asc ;; 45: len 4; hex 5a009a0d; asc Z ;; 46: len 4; hex 5a009a15; asc Z ;; ------------------ ---TRANSACTION 49010188010, ACTIVE 17 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 211668, OS thread handle 0x7f19dc428700, query id 7321602 172.16.77.201 db_user_1 statistics select * from `table_4` where `id` = '11991185' limit 1 for update ------- TRX HAS BEEN WAITING 17 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 339 page no 7253841 n bits 112 index PRIMARY of table `db_1`.`table_4` trx id 49010188010 lock_mode X locks rec but not gap waiting Record lock, heap no 23 PHYSICAL RECORD: n_fields 47; compact format; info bits 0 0: len 4; hex 094be2b9; asc K ;; 1: len 6; hex 000b693bdc10; asc i; ;; 2: len 7; hex 440004776d2db8; asc D wm- ;; 3: len 4; hex 80862107; asc ! ;; 4: len 4; hex 8001e61d; asc ;; 5: len 8; hex 0a8d1656e0dd4140; asc V A@;; 6: len 8; hex e5af3500c0a94940; asc 5 I@;; 7: len 4; hex 80000000; asc ;; 8: len 0; hex ; asc ;; 9: len 30; hex d9bed8b1d8afdb8cd8b320d8b3db8cd986d985d8a7db8cdb8c20d8b2d986; asc ; (total 104 bytes); 10: len 8; hex ed1008ebd7dd4140; asc A@;; 11: len 8; hex 4f4c167f47ae4940; asc OL G I@;; 12: len 4; hex 80000000; asc ;; 13: len 0; hex ; asc ;; 14: len 30; hex d88c20d8aad987d8b1d8a7d986d88c20d8aad987d8b1d8a7d986d88c20d9; asc ; (total 79 bytes); 15: len 1; hex 80; asc ;; 16: len 1; hex 80; asc ;; 17: len 1; hex 80; asc ;; 18: len 1; hex 80; asc ;; 19: len 4; hex 80000000; asc ;; 20: len 4; hex 80000000; asc ;; 21: len 4; hex 800014dd; asc ;; 22: len 4; hex 80014c08; asc L ;; 23: len 4; hex 80012230; asc "0;; 24: len 1; hex 81; asc ;; 25: len 1; hex 80; asc ;; 26: len 14; hex 534e502d3935332d393535353633; asc XXXX153X915563;; 27: len 1; hex 81; asc ;; 28: len 4; hex 80000000; asc ;; 29: len 4; hex 80000000; asc ;; 30: len 8; hex 0000000000000000; asc ;; 31: len 8; hex 0000000000000000; asc ;; 32: len 1; hex 80; asc ;; 33: len 1; hex 80; asc ;; 34: len 1; hex 80; asc ;; 35: len 1; hex 80; asc ;; 36: len 0; hex ; asc ;; 37: len 8; hex 0000000000000000; asc ;; 38: len 8; hex 0000000000000000; asc ;; 39: len 4; hex 80000000; asc ;; 40: len 0; hex ; asc ;; 41: len 4; hex 80000000; asc ;; 42: len 4; hex 80000000; asc ;; 43: len 4; hex 80000000; asc ;; 44: len 1; hex 80; asc ;; 45: len 4; hex 5a009a0d; asc Z ;; 46: len 4; hex 5a009a15; asc Z ;; ------------------ ---TRANSACTION 49010182837, ACTIVE 27 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 207030, OS thread handle 0x7f19981bb700, query id 7163832 172.16.77.106 db_user_1 statistics select * from `table_4` where `id` = '155968185' limit 1 for update ------- TRX HAS BEEN WAITING 27 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 339 page no 7253841 n bits 112 index PRIMARY of table `db_1`.`table_4` trx id 49010182837 lock_mode X locks rec but not gap waiting Record lock, heap no 23 PHYSICAL RECORD: n_fields 47; compact format; info bits 0 0: len 4; hex 094be2b9; asc K ;; 1: len 6; hex 000b693bdc10; asc i; ;; 2: len 7; hex 440004776d2db8; asc D wm- ;; 3: len 4; hex 80862107; asc ! ;; 4: len 4; hex 8001e61d; asc ;; 5: len 8; hex 0a8d1656e0dd4140; asc V A@;; 6: len 8; hex e5af3500c0a94940; asc 5 I@;; 7: len 4; hex 80000000; asc ;; 8: len 0; hex ; asc ;; 9: len 30; hex d9bed8b1d8afdb8cd8b320d8b3db8cd986d985d8a7db8cdb8c20d8b2d986; asc ; (total 104 bytes); 10: len 8; hex ed1008ebd7dd4140; asc A@;; 11: len 8; hex 4f4c167f47ae4940; asc OL G I@;; 12: len 4; hex 80000000; asc ;; 13: len 0; hex ; asc ;; 14: len 30; hex d88c20d8aad987d8b1d8a7d986d88c20d8aad987d8b1d8a7d986d88c20d9; asc ; (total 79 bytes); 15: len 1; hex 80; asc ;; 16: len 1; hex 80; asc ;; 17: len 1; hex 80; asc ;; 18: len 1; hex 80; asc ;; 19: len 4; hex 80000000; asc ;; 20: len 4; hex 80000000; asc ;; 21: len 4; hex 800014dd; asc ;; 22: len 4; hex 80014c08; asc L ;; 23: len 4; hex 80012230; asc "0;; 24: len 1; hex 81; asc ;; 25: len 1; hex 80; asc ;; 26: len 14; hex 534e502d3935332d393535353633; asc XXXX913X953563;; 27: len 1; hex 81; asc ;; 28: len 4; hex 80000000; asc ;; 29: len 4; hex 80000000; asc ;; 30: len 8; hex 0000000000000000; asc ;; 31: len 8; hex 0000000000000000; asc ;; 32: len 1; hex 80; asc ;; 33: len 1; hex 80; asc ;; 34: len 1; hex 80; asc ;; 35: len 1; hex 80; asc ;; 36: len 0; hex ; asc ;; 37: len 8; hex 0000000000000000; asc ;; 38: len 8; hex 0000000000000000; asc ;; 39: len 4; hex 80000000; asc ;; 40: len 0; hex ; asc ;; 41: len 4; hex 80000000; asc ;; 42: len 4; hex 80000000; asc ;; 43: len 4; hex 80000000; asc ;; 44: len 1; hex 80; asc ;; 45: len 4; hex 5a009a0d; asc Z ;; 46: len 4; hex 5a009a15; asc Z ;; ------------------ ---TRANSACTION 49010181229, ACTIVE 29 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 205663, OS thread handle 0x7f16f29bd700, query id 7117051 172.16.77.121 db_user_1 statistics select * from `table_4` where `id` = '19596815' limit 1 for update ------- TRX HAS BEEN WAITING 29 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 339 page no 7253841 n bits 112 index PRIMARY of table `db_1`.`table_4` trx id 49010181229 lock_mode X locks rec but not gap waiting Record lock, heap no 23 PHYSICAL RECORD: n_fields 47; compact format; info bits 0 0: len 4; hex 094be2b9; asc K ;; 1: len 6; hex 000b693bdc10; asc i; ;; 2: len 7; hex 440004776d2db8; asc D wm- ;; 3: len 4; hex 80862107; asc ! ;; 4: len 4; hex 8001e61d; asc ;; 5: len 8; hex 0a8d1656e0dd4140; asc V A@;; 6: len 8; hex e5af3500c0a94940; asc 5 I@;; 7: len 4; hex 80000000; asc ;; 8: len 0; hex ; asc ;; 9: len 30; hex d9bed8b1d8afdb8cd8b320d8b3db8cd986d985d8a7db8cdb8c20d8b2d986; asc ; (total 104 bytes); 10: len 8; hex ed1008ebd7dd4140; asc A@;; 11: len 8; hex 4f4c167f47ae4940; asc OL G I@;; 12: len 4; hex 80000000; asc ;; 13: len 0; hex ; asc ;; 14: len 30; hex d88c20d8aad987d8b1d8a7d986d88c20d8aad987d8b1d8a7d986d88c20d9; asc ; (total 79 bytes); 15: len 1; hex 80; asc ;; 16: len 1; hex 80; asc ;; 17: len 1; hex 80; asc ;; 18: len 1; hex 80; asc ;; 19: len 4; hex 80000000; asc ;; 20: len 4; hex 80000000; asc ;; 21: len 4; hex 800014dd; asc ;; 22: len 4; hex 80014c08; asc L ;; 23: len 4; hex 80012230; asc "0;; 24: len 1; hex 81; asc ;; 25: len 1; hex 80; asc ;; 26: len 14; hex 534e502d3935332d393535353633; asc XXXX953X951563;; 27: len 1; hex 81; asc ;; 28: len 4; hex 80000000; asc ;; 29: len 4; hex 80000000; asc ;; 30: len 8; hex 0000000000000000; asc ;; 31: len 8; hex 0000000000000000; asc ;; 32: len 1; hex 80; asc ;; 33: len 1; hex 80; asc ;; 34: len 1; hex 80; asc ;; 35: len 1; hex 80; asc ;; 36: len 0; hex ; asc ;; 37: len 8; hex 0000000000000000; asc ;; 38: len 8; hex 0000000000000000; asc ;; 39: len 4; hex 80000000; asc ;; 40: len 0; hex ; asc ;; 41: len 4; hex 80000000; asc ;; 42: len 4; hex 80000000; asc ;; 43: len 4; hex 80000000; asc ;; 44: len 1; hex 80; asc ;; 45: len 4; hex 5a009a0d; asc Z ;; 46: len 4; hex 5a009a15; asc Z ;; ------------------ ---TRANSACTION 49010170896, ACTIVE 48 sec 8 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 4 MySQL thread id 196720, OS thread handle 0x7f1aed66c700, query id 6813858 172.16.77.116 db_user_1 insert into `table_2` (`status`, `x_id`, `updated_at`, `created_at`) values ('4', '124445', '2017-11-06 20:51:25', '2017-11-06 20:51:25') Trx read view will not see trx with id >= 49010170900, sees < 49010170898 -------- 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 (read thread) I/O thread 7 state: waiting for completed aio requests (read thread) I/O thread 8 state: waiting for completed aio requests (read thread) I/O thread 9 state: waiting for completed aio requests (read thread) I/O thread 10 state: waiting for completed aio requests (write thread) I/O thread 11 state: waiting for completed aio requests (write thread) I/O thread 12 state: waiting for completed aio requests (write thread) I/O thread 13 state: waiting for completed aio requests (write thread) I/O thread 14 state: waiting for completed aio requests (write thread) I/O thread 15 state: waiting for completed aio requests (write thread) I/O thread 16 state: waiting for completed aio requests (write thread) I/O thread 17 state: waiting for completed aio requests (write thread) Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 0 4806532 OS file reads, 227135 OS file writes, 189708 OS fsyncs 2 pending reads, 0 pending writes 4586.95 reads/s, 16384 avg bytes/read, 673.15 writes/s, 506.10 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 25, free list len 52511, seg size 52537, 47978 merges merged operations: insert 49489, delete mark 7931, delete 201 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 47812069, node heap has 508 buffer(s) Hash table size 47812069, node heap has 5578 buffer(s) Hash table size 47812069, node heap has 123987 buffer(s) Hash table size 47812069, node heap has 645 buffer(s) Hash table size 47812069, node heap has 367 buffer(s) Hash table size 47812069, node heap has 267 buffer(s) Hash table size 47812069, node heap has 1367 buffer(s) Hash table size 47812069, node heap has 253 buffer(s) 41419.67 hash searches/s, 81540.87 non-hash searches/s --- LOG --- Log sequence number 4451760621506 Log flushed up to 4451760604844 Pages flushed up to 4451246269166 Last checkpoint at 4451243348664 0 pending log flushes, 0 pending chkp writes 121113 log i/o's done, 279.49 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 198086492160 Dictionary memory allocated 2103029 Buffer pool size 11796480 Free buffers 6852578 Database pages 4810880 Old database pages 1776672 Modified db pages 571183 Percent of dirty pages(LRU & free pages): 4.897 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 8487, not young 0 26.80 youngs/s, 0.00 non-youngs/s Pages read 4809219, created 1661, written 85096 4584.18 reads/s, 3.26 creates/s, 333.70 writes/s Buffer pool hit rate 991 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 9.11/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 4810880, unzip_LRU len: 0 I/O sum[0]:cur[177760], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 294912 Free buffers 170428 Database pages 121145 Old database pages 44739 Modified db pages 13999 Percent of dirty pages(LRU & free pages): 4.801 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 144, not young 0 0.31 youngs/s, 0.00 non-youngs/s Pages read 121127, created 18, written 2125 108.88 reads/s, 0.03 creates/s, 8.34 writes/s Buffer pool hit rate 989 / 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: 121145, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 294912 Free buffers 171668 Database pages 119917 Old database pages 44286 Modified db pages 13776 Percent of dirty pages(LRU & free pages): 4.725 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 187, not young 0 0.43 youngs/s, 0.00 non-youngs/s Pages read 119904, created 13, written 2124 111.20 reads/s, 0.11 creates/s, 8.34 writes/s Buffer pool hit rate 982 / 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: 119917, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 294912 Free buffers 173137 Database pages 118446 Old database pages 43743 Modified db pages 15354 Percent of dirty pages(LRU & free pages): 5.266 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 227, not young 0 0.77 youngs/s, 0.00 non-youngs/s Pages read 118421, created 25, written 2124 116.63 reads/s, 0.03 creates/s, 8.34 writes/s Buffer pool hit rate 993 / 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: 118446, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 294912 Free buffers 171697 Database pages 119869 Old database pages 44268 Modified db pages 14041 Percent of dirty pages(LRU & free pages): 4.816 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 217, not young 0 0.57 youngs/s, 0.00 non-youngs/s Pages read 119862, created 7, written 2124 119.34 reads/s, 0.00 creates/s, 8.34 writes/s Buffer pool hit rate 998 / 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: 119869, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 294912 Free buffers 171457 Database pages 120121 Old database pages 44361 Modified db pages 13917 Percent of dirty pages(LRU & free pages): 4.773 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 212, not young 0 0.57 youngs/s, 0.00 non-youngs/s Pages read 120098, created 23, written 2124 109.03 reads/s, 0.06 creates/s, 8.34 writes/s Buffer pool hit rate 996 / 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: 120121, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 294912 Free buffers 171695 Database pages 119862 Old database pages 44265 Modified db pages 14766 Percent of dirty pages(LRU & free pages): 5.065 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 263, not young 0 0.63 youngs/s, 0.00 non-youngs/s Pages read 119850, created 12, written 2124 120.31 reads/s, 0.00 creates/s, 8.34 writes/s Buffer pool hit rate 992 / 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: 119862, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 294912 Free buffers 170418 Database pages 121150 Old database pages 44741 Modified db pages 13764 Percent of dirty pages(LRU & free pages): 4.721 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 266, not young 0 0.74 youngs/s, 0.00 non-youngs/s Pages read 121095, created 55, written 2124 114.17 reads/s, 0.03 creates/s, 8.34 writes/s Buffer pool hit rate 988 / 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: 121150, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 294912 Free buffers 171772 Database pages 119817 Old database pages 44249 Modified db pages 13360 Percent of dirty pages(LRU & free pages): 4.582 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 237, not young 0 1.43 youngs/s, 0.00 non-youngs/s Pages read 119809, created 8, written 2124 115.80 reads/s, 0.00 creates/s, 8.34 writes/s Buffer pool hit rate 990 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 1.83/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 119817, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 8 Buffer pool size 294912 Free buffers 171796 Database pages 119770 Old database pages 44231 Modified db pages 15396 Percent of dirty pages(LRU & free pages): 5.280 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 228, not young 0 1.23 youngs/s, 0.00 non-youngs/s Pages read 119763, created 7, written 2124 112.80 reads/s, 0.11 creates/s, 8.34 writes/s Buffer pool hit rate 990 / 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: 119770, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 9 Buffer pool size 294912 Free buffers 171503 Database pages 120085 Old database pages 44348 Modified db pages 14284 Percent of dirty pages(LRU & free pages): 4.899 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 185, not young 0 0.54 youngs/s, 0.00 non-youngs/s Pages read 120058, created 27, written 2124 110.83 reads/s, 0.06 creates/s, 8.34 writes/s Buffer pool hit rate 982 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 1.83/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 120085, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 10 Buffer pool size 294912 Free buffers 171134 Database pages 120418 Old database pages 44471 Modified db pages 13287 Percent of dirty pages(LRU & free pages): 4.557 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 229, not young 0 0.74 youngs/s, 0.00 non-youngs/s Pages read 120406, created 12, written 2124 107.88 reads/s, 0.00 creates/s, 8.34 writes/s Buffer pool hit rate 988 / 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: 120418, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 11 Buffer pool size 294912 Free buffers 170329 Database pages 121264 Old database pages 44783 Modified db pages 13890 Percent of dirty pages(LRU & free pages): 4.763 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 190, not young 0 0.37 youngs/s, 0.00 non-youngs/s Pages read 121212, created 52, written 2124 118.48 reads/s, 0.09 creates/s, 8.34 writes/s Buffer pool hit rate 983 / 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: 121264, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 12 Buffer pool size 294912 Free buffers 171737 Database pages 119834 Old database pages 44255 Modified db pages 15122 Percent of dirty pages(LRU & free pages): 5.186 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 231, not young 0 0.57 youngs/s, 0.00 non-youngs/s Pages read 119796, created 38, written 2124 112.57 reads/s, 0.03 creates/s, 8.34 writes/s Buffer pool hit rate 986 / 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: 119834, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 13 Buffer pool size 294912 Free buffers 169879 Database pages 121729 Old database pages 44955 Modified db pages 14216 Percent of dirty pages(LRU & free pages): 4.875 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 173, not young 0 0.60 youngs/s, 0.00 non-youngs/s Pages read 121677, created 52, written 2124 118.05 reads/s, 0.06 creates/s, 8.34 writes/s Buffer pool hit rate 982 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 1.83/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 121729, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 14 Buffer pool size 294912 Free buffers 170196 Database pages 121381 Old database pages 44826 Modified db pages 14517 Percent of dirty pages(LRU & free pages): 4.979 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 180, not young 0 0.29 youngs/s, 0.00 non-youngs/s Pages read 121361, created 20, written 2124 126.48 reads/s, 0.06 creates/s, 8.34 writes/s Buffer pool hit rate 987 / 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: 121381, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 15 Buffer pool size 294912 Free buffers 172165 Database pages 119399 Old database pages 44095 Modified db pages 14265 Percent of dirty pages(LRU & free pages): 4.893 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 214, not young 0 0.51 youngs/s, 0.00 non-youngs/s Pages read 119347, created 52, written 2124 110.17 reads/s, 0.11 creates/s, 8.34 writes/s Buffer pool hit rate 988 / 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: 119399, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 16 Buffer pool size 294912 Free buffers 170410 Database pages 121202 Old database pages 44760 Modified db pages 14311 Percent of dirty pages(LRU & free pages): 4.908 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 204, not young 0 0.43 youngs/s, 0.00 non-youngs/s Pages read 121157, created 45, written 2124 112.91 reads/s, 0.14 creates/s, 8.34 writes/s Buffer pool hit rate 983 / 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: 121202, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 17 Buffer pool size 294912 Free buffers 169374 Database pages 122219 Old database pages 45135 Modified db pages 14917 Percent of dirty pages(LRU & free pages): 5.116 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 226, not young 0 0.57 youngs/s, 0.00 non-youngs/s Pages read 122067, created 152, written 2124 115.97 reads/s, 0.26 creates/s, 8.34 writes/s Buffer pool hit rate 987 / 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: 122219, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 18 Buffer pool size 294912 Free buffers 170570 Database pages 121057 Old database pages 44707 Modified db pages 14402 Percent of dirty pages(LRU & free pages): 4.938 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 208, not young 0 0.71 youngs/s, 0.00 non-youngs/s Pages read 121041, created 16, written 2126 110.91 reads/s, 0.03 creates/s, 8.34 writes/s Buffer pool hit rate 993 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 1.80/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 121057, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 19 Buffer pool size 294912 Free buffers 171553 Database pages 120040 Old database pages 44331 Modified db pages 13839 Percent of dirty pages(LRU & free pages): 4.746 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 244, not young 0 0.83 youngs/s, 0.00 non-youngs/s Pages read 119979, created 61, written 2124 112.85 reads/s, 0.20 creates/s, 8.34 writes/s Buffer pool hit rate 991 / 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: 120040, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 20 Buffer pool size 294912 Free buffers 168363 Database pages 123235 Old database pages 45511 Modified db pages 14489 Percent of dirty pages(LRU & free pages): 4.969 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 198, not young 0 0.54 youngs/s, 0.00 non-youngs/s Pages read 123212, created 23, written 2124 125.88 reads/s, 0.06 creates/s, 8.34 writes/s Buffer pool hit rate 987 / 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: 123235, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 21 Buffer pool size 294912 Free buffers 170525 Database pages 121068 Old database pages 44711 Modified db pages 15631 Percent of dirty pages(LRU & free pages): 5.361 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 189, not young 0 0.51 youngs/s, 0.00 non-youngs/s Pages read 121043, created 25, written 2124 119.25 reads/s, 0.00 creates/s, 8.34 writes/s Buffer pool hit rate 987 / 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: 121068, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 22 Buffer pool size 294912 Free buffers 170531 Database pages 121092 Old database pages 44719 Modified db pages 14487 Percent of dirty pages(LRU & free pages): 4.968 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 194, not young 0 0.89 youngs/s, 0.00 non-youngs/s Pages read 120966, created 126, written 2187 124.85 reads/s, 0.17 creates/s, 8.34 writes/s Buffer pool hit rate 991 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 1.83/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 121092, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 23 Buffer pool size 294912 Free buffers 171499 Database pages 120114 Old database pages 44358 Modified db pages 14944 Percent of dirty pages(LRU & free pages): 5.125 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 264, not young 0 1.51 youngs/s, 0.00 non-youngs/s Pages read 119965, created 149, written 2188 122.23 reads/s, 0.00 creates/s, 8.34 writes/s Buffer pool hit rate 989 / 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: 120114, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 24 Buffer pool size 294912 Free buffers 171829 Database pages 119765 Old database pages 44230 Modified db pages 13982 Percent of dirty pages(LRU & free pages): 4.795 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 215, not young 0 0.74 youngs/s, 0.00 non-youngs/s Pages read 119716, created 49, written 2128 112.31 reads/s, 0.26 creates/s, 8.34 writes/s Buffer pool hit rate 988 / 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: 119765, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 25 Buffer pool size 294912 Free buffers 169772 Database pages 121777 Old database pages 44972 Modified db pages 14681 Percent of dirty pages(LRU & free pages): 5.035 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 224, not young 0 0.54 youngs/s, 0.00 non-youngs/s Pages read 121731, created 46, written 2124 116.03 reads/s, 0.17 creates/s, 8.34 writes/s Buffer pool hit rate 985 / 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: 121777, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 26 Buffer pool size 294912 Free buffers 175212 Database pages 116395 Old database pages 42986 Modified db pages 14125 Percent of dirty pages(LRU & free pages): 4.844 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 217, not young 0 0.51 youngs/s, 0.00 non-youngs/s Pages read 116386, created 9, written 2124 110.91 reads/s, 0.09 creates/s, 8.34 writes/s Buffer pool hit rate 995 / 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: 116395, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 27 Buffer pool size 294912 Free buffers 175409 Database pages 116164 Old database pages 42900 Modified db pages 13492 Percent of dirty pages(LRU & free pages): 4.627 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 177, not young 0 0.46 youngs/s, 0.00 non-youngs/s Pages read 116132, created 32, written 2124 108.31 reads/s, 0.11 creates/s, 8.34 writes/s Buffer pool hit rate 990 / 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: 116164, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 28 Buffer pool size 294912 Free buffers 171592 Database pages 120022 Old database pages 44324 Modified db pages 14588 Percent of dirty pages(LRU & free pages): 5.002 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 197, not young 0 0.57 youngs/s, 0.00 non-youngs/s Pages read 119992, created 30, written 2124 108.91 reads/s, 0.06 creates/s, 8.34 writes/s Buffer pool hit rate 990 / 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: 120022, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 29 Buffer pool size 294912 Free buffers 169176 Database pages 122410 Old database pages 45206 Modified db pages 14372 Percent of dirty pages(LRU & free pages): 4.929 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 185, not young 0 0.37 youngs/s, 0.00 non-youngs/s Pages read 122352, created 58, written 2124 114.31 reads/s, 0.06 creates/s, 8.34 writes/s Buffer pool hit rate 987 / 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: 122410, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 30 Buffer pool size 294912 Free buffers 172564 Database pages 119010 Old database pages 43951 Modified db pages 14245 Percent of dirty pages(LRU & free pages): 4.886 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 238, not young 0 0.49 youngs/s, 0.00 non-youngs/s Pages read 118968, created 42, written 2124 111.45 reads/s, 0.14 creates/s, 8.34 writes/s Buffer pool hit rate 991 / 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: 119010, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 31 Buffer pool size 294912 Free buffers 171078 Database pages 120541 Old database pages 44516 Modified db pages 13733 Percent of dirty pages(LRU & free pages): 4.709 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 169, not young 0 0.54 youngs/s, 0.00 non-youngs/s Pages read 120518, created 23, written 2124 116.94 reads/s, 0.11 creates/s, 8.34 writes/s Buffer pool hit rate 986 / 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: 120541, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 32 Buffer pool size 294912 Free buffers 172049 Database pages 119566 Old database pages 44156 Modified db pages 13760 Percent of dirty pages(LRU & free pages): 4.719 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 206, not young 0 1.14 youngs/s, 0.00 non-youngs/s Pages read 119520, created 46, written 2125 110.25 reads/s, 0.09 creates/s, 8.34 writes/s Buffer pool hit rate 990 / 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: 119566, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 33 Buffer pool size 294912 Free buffers 171247 Database pages 120305 Old database pages 44429 Modified db pages 14475 Percent of dirty pages(LRU & free pages): 4.965 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 233, not young 0 0.51 youngs/s, 0.00 non-youngs/s Pages read 120290, created 15, written 2124 108.43 reads/s, 0.06 creates/s, 8.34 writes/s Buffer pool hit rate 990 / 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: 120305, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 34 Buffer pool size 294912 Free buffers 169361 Database pages 122212 Old database pages 45133 Modified db pages 13667 Percent of dirty pages(LRU & free pages): 4.687 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 240, not young 0 0.80 youngs/s, 0.00 non-youngs/s Pages read 122198, created 14, written 2124 113.57 reads/s, 0.00 creates/s, 8.34 writes/s Buffer pool hit rate 988 / 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: 122212, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 35 Buffer pool size 294912 Free buffers 173731 Database pages 117828 Old database pages 43515 Modified db pages 14483 Percent of dirty pages(LRU & free pages): 4.967 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 200, not young 0 1.03 youngs/s, 0.00 non-youngs/s Pages read 117783, created 45, written 2125 111.65 reads/s, 0.06 creates/s, 8.34 writes/s Buffer pool hit rate 991 / 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: 117828, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 36 Buffer pool size 294912 Free buffers 169953 Database pages 121654 Old database pages 44927 Modified db pages 14277 Percent of dirty pages(LRU & free pages): 4.896 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 217, not young 0 0.77 youngs/s, 0.00 non-youngs/s Pages read 121556, created 98, written 2124 119.51 reads/s, 0.06 creates/s, 8.34 writes/s Buffer pool hit rate 985 / 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: 121654, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 37 Buffer pool size 294912 Free buffers 170105 Database pages 121499 Old database pages 44870 Modified db pages 13460 Percent of dirty pages(LRU & free pages): 4.616 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 244, not young 0 0.40 youngs/s, 0.00 non-youngs/s Pages read 121463, created 36, written 2124 117.20 reads/s, 0.26 creates/s, 8.34 writes/s Buffer pool hit rate 989 / 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: 121499, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 38 Buffer pool size 294912 Free buffers 174103 Database pages 117464 Old database pages 43380 Modified db pages 14184 Percent of dirty pages(LRU & free pages): 4.865 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 205, not young 0 1.09 youngs/s, 0.00 non-youngs/s Pages read 117438, created 26, written 2124 118.63 reads/s, 0.06 creates/s, 8.34 writes/s Buffer pool hit rate 994 / 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: 117464, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] ---BUFFER POOL 39 Buffer pool size 294912 Free buffers 171561 Database pages 120034 Old database pages 44329 Modified db pages 14685 Percent of dirty pages(LRU & free pages): 5.036 Max dirty pages percent: 70.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 210, not young 0 0.51 youngs/s, 0.00 non-youngs/s Pages read 119960, created 74, written 2124 108.31 reads/s, 0.06 creates/s, 8.34 writes/s Buffer pool hit rate 987 / 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: 120034, unzip_LRU len: 0 I/O sum[0]:cur[4444], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 3 read views open inside InnoDB Process ID=12143, Main thread ID=139753814390528, state: sleeping Number of rows inserted 117710, updated 77270, deleted 285, read 30395583 267.42 inserts/s, 164.77 updates/s, 0.80 deletes/s, 53886.52 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 1 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================