*************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2017-11-06 20:41:29 0x7fa487df9700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 30 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 92521 srv_active, 0 srv_shutdown, 18 srv_idle srv_master_thread log flush and writes: 92539 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3207805 OS WAIT ARRAY INFO: signal count 16070293 RW-shared spins 0, rounds 6071873, OS waits 1186326 RW-excl spins 0, rounds 55345247, OS waits 1110987 RW-sx spins 112303, rounds 1688072, OS waits 15461 Spin rounds per wait: 6071873.00 RW-shared, 55345247.00 RW-excl, 15.03 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 49009849361 Purge done for trx's n:o < 48960880509 undo n:o < 0 state: running but idle History list length 6903067 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 422038260455328, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260449904, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260446288, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260420072, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260407416, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260403800, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260364024, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260379392, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260391144, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260429112, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260427304, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260360408, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260443576, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260484256, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260392952, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260524032, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260468888, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260535784, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260477928, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260458040, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260500528, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260716584, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260711160, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260662344, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260706640, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260703024, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260698504, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260600872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260695792, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260652400, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260689464, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260687656, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260590024, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260630704, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260678616, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260673192, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260663248, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260650592, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260567424, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260646976, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260642456, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260638840, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260636128, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260628896, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260627992, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260627088, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260626184, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260493296, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260559288, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260570136, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260561096, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260419168, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260406512, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260433632, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260557480, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260562904, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260555672, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260593640, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260651496, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260647880, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260583696, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260542112, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260679520, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260445384, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260501432, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260664152, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260637936, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260624376, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260619856, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260596352, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260512280, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260511376, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260383912, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260444480, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260415552, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260390240, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260478832, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260528552, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260680424, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260631608, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260614432, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260482448, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260514992, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260461656, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260496912, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260551152, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260495104, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260639744, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260634320, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260566520, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260395664, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260618952, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260699408, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260720200, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260713872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260487872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260620760, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260608104, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260606296, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260448096, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260611720, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260641552, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260658728, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260668672, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260677712, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260622568, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260621664, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260423688, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260452616, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260656016, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260693984, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260527648, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260670480, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260514088, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260418264, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260408320, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260648784, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260477024, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260467080, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260454424, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260657824, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260420976, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260669576, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260422784, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260643360, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260571040, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260434536, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260431824, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260690368, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260428208, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260675000, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260654208, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260537592, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260693080, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260383008, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260588216, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260392048, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260538496, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260691272, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260646072, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260632512, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260665056, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260686752, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260363120, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260421880, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260439056, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260665960, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260367640, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260442672, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260439960, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260394760, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260599064, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260470696, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260412840, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260411032, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260681328, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260773536, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260729240, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260348656, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260613528, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260676808, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260645168, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260550248, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260432728, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260359504, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260616240, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260576464, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260530360, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260496008, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260436344, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260373968, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260371256, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260342328, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260430920, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260573752, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260597256, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260563808, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260416456, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260543920, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260609912, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260609008, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260451712, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260414648, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260387528, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260366736, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260373064, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260618048, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260615336, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260370352, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260481544, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260343232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260396568, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260424592, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260409224, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260404704, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260380296, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260413744, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260386624, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260372160, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260659632, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260589120, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260354984, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260388432, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260584600, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260625280, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260623472, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260601776, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260599968, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260362216, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260389336, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260385720, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260592736, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260578272, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260509568, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260569232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260351368, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260480640, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260447192, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260490584, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260572848, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260564712, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260441768, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260536688, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260517704, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260515896, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260503240, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260486064, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260483352, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260474312, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260437248, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260456232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260435440, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260425496, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260411936, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260399280, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260345040, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260405608, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260381200, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260384816, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260356792, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260400184, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260393856, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260352272, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260397472, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260467984, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260369448, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260358600, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260548440, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260426400, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260401088, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260476120, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260466176, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260350464, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260375776, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260341424, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260382104, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260374872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260457136, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260355888, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260438152, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260525840, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260519512, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260556576, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260506856, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260492392, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260450808, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260449000, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260417360, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260364928, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260376680, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260361312, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260377584, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260453520, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260378488, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260365832, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260368544, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260349560, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260346848, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260582792, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260541208, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260357696, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260354080, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260353176, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260505048, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260344136, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260430016, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260508664, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260345944, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260580984, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260610816, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422038260340520, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 49009849349, ACTIVE 0 sec 6 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 4 MySQL thread id 39643709, OS thread handle 0x7fa7c6929700, query id 1424882008 172.16.77.77 db_user_1 cleaning up Trx read view will not see trx with id >= 49009849359, sees < 48960880501 ---TRANSACTION 49009849242, ACTIVE 0 sec 6 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 4 MySQL thread id 39643304, OS thread handle 0x7fa758a1f700, query id 1424882056 172.16.77.116 db_user_1 cleaning up Trx read view will not see trx with id >= 49009849253, sees < 48960880501 ---TRANSACTION 49009849229, ACTIVE 0 sec 9 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 5 MySQL thread id 39643328, OS thread handle 0x7fa8705f2700, query id 1424881937 172.16.77.201 db_user_1 cleaning up Trx read view will not see trx with id >= 49009849257, sees < 48960880501 ---TRANSACTION 49009848696, ACTIVE 1 sec 7 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 5 MySQL thread id 39643034, OS thread handle 0x7fa758a1f700, query id 1424881985 172.16.77.201 db_user_1 cleaning up Trx read view will not see trx with id >= 49009848717, sees < 48960880501 ---TRANSACTION 49009840635, ACTIVE 15 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 39636326, OS thread handle 0x7fa8701e6700, query id 1424631350 172.16.77.123 db_user_1 statistics select * from `table_4` where `id` = '155932347' limit 1 for update ------- TRX HAS BEEN WAITING 15 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 339 page no 7337555 n bits 112 index PRIMARY of table `db_1`.`table_4` trx id 49009840635 lock_mode X locks rec but not gap waiting Record lock, heap no 13 PHYSICAL RECORD: n_fields 47; compact format; info bits 0 0: len 4; hex 094b56bb; asc KV ;; 1: len 6; hex 000b692bd5cd; asc i+ ;; 2: len 7; hex 500003d0ac0af3; asc P ;; 3: len 4; hex 806f1c67; asc o g;; 4: len 4; hex 80069b34; asc 4;; 5: len 8; hex 3fdcb92aff2d4240; asc ? * -B@;; 6: len 8; hex 3600501264c14d40; asc 6 P d M@;; 7: len 4; hex 80000000; asc ;; 8: len 0; hex ; asc ;; 9: len 30; hex d88c20d8aed8b1d8a7d8b3d8a7d98620d8b1d8b6d988db8cd88c20d985d8; asc ; (total 87 bytes); 10: len 8; hex 79ba328ed5264240; asc y 2 &B@;; 11: len 8; hex 0500d09f93cf4d40; asc M@;; 12: len 4; hex 80000000; asc ;; 13: len 0; hex ; asc ;; 14: len 30; hex d88c20d8aed8b1d8a7d8b3d8a7d98620d8b1d8b6d988db8cd88c20d985d8; asc ; (total 104 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 80004161; asc Aa;; 22: len 4; hex 800124f8; asc $ ;; 23: len 4; hex 80012389; asc # ;; 24: len 1; hex 81; asc ;; 25: len 1; hex 80; asc ;; 26: len 14; hex 534e502d3630342d343136383037; asc XXXX601X418807;; 27: len 1; hex 85; asc ;; 28: len 4; hex 80000000; asc ;; 29: len 4; hex 80000000; asc ;; 30: len 8; hex 0000000000000000; asc ;; 31: len 8; hex 000000000088b340; 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 5a008cf3; asc Z ;; 46: len 4; hex 5a009300; asc Z ;; ------------------ ---TRANSACTION 49009833906, 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 39630661, OS thread handle 0x7fa752d63700, query id 1424436604 172.16.77.77 db_user_1 statistics select * from `table_4` where `id` = '155915579' limit 1 for update ------- TRX HAS BEEN WAITING 27 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 339 page no 7335857 n bits 112 index PRIMARY of table `db_1`.`table_4` trx id 49009833906 lock_mode X locks rec but not gap waiting Record lock, heap no 11 PHYSICAL RECORD: n_fields 47; compact format; info bits 0 0: len 4; hex 094b153b; asc K ;;; 1: len 6; hex 000b692d0498; asc i- ;; 2: len 7; hex 320003d36327fc; asc 2 c' ;; 3: len 4; hex 8004f1ae; asc ;; 4: len 4; hex 80056e0e; asc n ;; 5: len 8; hex 98354ef891e14140; asc 5N A@;; 6: len 8; hex 0a002020bcbc4940; asc I@;; 7: len 4; hex 80000000; asc ;; 8: len 0; hex ; asc ;; 9: len 30; hex d88c20d8aad987d8b1d8a7d986d88c20d8aad987d8b1d8a7d986d88c20d9; asc ; (total 93 bytes); 10: len 8; hex d2124a1546dd4140; asc J F A@;; 11: len 8; hex 0400a02797a54940; asc ' I@;; 12: len 4; hex 8007440e; asc D ;; 13: len 0; hex ; asc ;; 14: len 30; hex d88c20d8aad987d8b1d8a7d986d88c20d8aad987d8b1d8a7d986d88c20d9; asc ; (total 64 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 80004fb7; asc O ;; 22: len 4; hex 80033450; asc 4P;; 23: len 4; hex 800279da; asc y ;; 24: len 1; hex 81; asc ;; 25: len 1; hex 80; asc ;; 26: len 14; hex 534e502d3832382d383533323536; asc XXXX818X153256;; 27: len 1; hex 85; 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 5a008761; asc Z a;; 46: len 4; hex 5a00937b; asc Z {;; ------------------ ---TRANSACTION 49009539303, ACTIVE 531 sec 3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 13 MySQL thread id 38373152, OS thread handle 0x7fa48565f700, query id 1424787856 172.16.77.112 db_user_1 cleaning up Trx read view will not see trx with id >= 49009539699, sees < 48960880501 ---TRANSACTION 49009198232, ACTIVE 1094 sec 5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 3 MySQL thread id 39093465, OS thread handle 0x7fa7153f1700, query id 1406249301 172.16.77.121 db_user_1 insert into `table_2` (`status`, `x_id`, `updated_at`, `created_at`) values ('1', '355854', '2017-11-06 20:23:15', '2017-11-06 20:23:15') Trx read view will not see trx with id >= 49009198246, sees < 48960880501 ---TRANSACTION 49009120717, ACTIVE 1217 sec 5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 3 MySQL thread id 39030959, OS thread handle 0x7fa87063c700, query id 1404058187 172.16.77.121 db_user_1 insert into `table_2` (`status`, `x_id`, `updated_at`, `created_at`) values ('1', '432948', '2017-11-06 20:21:12', '2017-11-06 20:21:12') Trx read view will not see trx with id >= 49009120718, sees < 48960880501 ---TRANSACTION 49004501950, ACTIVE 7607 sec 8 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 4 MySQL thread id 35342085, OS thread handle 0x7fa758379700, query id 1273503777 172.16.77.77 db_user_1 insert into `table_2` (`status`, `x_id`, `updated_at`, `created_at`) values ('4', '250502', '2017-11-06 18:34:43', '2017-11-06 18:34:43') Trx read view will not see trx with id >= 49004501961, sees < 48960880501 ---TRANSACTION 49001425637, ACTIVE 10871 sec 5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 3 MySQL thread id 33132982, OS thread handle 0x7fa7c59d7700, query id 1191422617 172.16.77.121 db_user_1 insert into `table_2` (`status`, `x_id`, `updated_at`, `created_at`) values ('1', '227164', '2017-11-06 17:40:18', '2017-11-06 17:40:18') ---TRANSACTION 48999811979, ACTIVE 12485 sec 8 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 4 MySQL thread id 31994509, OS thread handle 0x7fa486bc3700, query id 1148794016 172.16.77.123 db_user_1 insert into `table_2` (`status`, `x_id`, `updated_at`, `created_at`) values ('4', '65375', '2017-11-06 17:13:24', '2017-11-06 17:13:24') Trx read view will not see trx with id >= 48999811991, sees < 48960880501 ---TRANSACTION 48997270549, ACTIVE 15160 sec 8 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 4 MySQL thread id 30137264, OS thread handle 0x7fa487a37700, query id 1080347721 172.16.77.106 db_user_1 insert into `table_2` (`status`, `x_id`, `updated_at`, `created_at`) values ('4', '363238', '2017-11-06 16:28:49', '2017-11-06 16:28:49') Trx read view will not see trx with id >= 48997270600, sees < 48960880501 ---TRANSACTION 48994937827, ACTIVE 17698 sec 5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 3 MySQL thread id 28403063, OS thread handle 0x7fa85143d700, query id 1016666849 172.16.77.106 db_user_1 insert into `table_2` (`status`, `x_id`, `updated_at`, `created_at`) values ('1', '250103', '2017-11-06 15:46:31', '2017-11-06 15:46:31') Trx read view will not see trx with id >= 48994937838, sees < 48960880501 ---TRANSACTION 48991068402, ACTIVE 22113 sec 5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 3 MySQL thread id 25455613, OS thread handle 0x7fa7595af700, query id 910318695 172.16.77.116 db_user_1 insert into `table_2` (`status`, `x_id`, `updated_at`, `created_at`) values ('1', '439243', '2017-11-06 14:32:56', '2017-11-06 14:32:56') ---TRANSACTION 48986558351, ACTIVE 27493 sec 9 lock struct(s), heap size 1136, 5 row lock(s), undo log entries 4 MySQL thread id 22041625, OS thread handle 0x7fa75151b700, query id 785729812 172.16.77.121 db_user_1 insert into `table_2` (`status`, `x_id`, `updated_at`, `created_at`) values ('4', '111719', '2017-11-06 13:03:16', '2017-11-06 13:03:16') Trx read view will not see trx with id >= 48986558359, sees < 48960880501 ---TRANSACTION 48986203225, ACTIVE 27910 sec estimating records in index range mysql tables in use 1, locked 1 5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 2 MySQL thread id 21777317, OS thread handle 0x7fa852673700, query id 776062173 172.16.77.106 db_user_1 init update `table_1` set `status` = '1', `updated_at` = '2017-11-06 12:56:19' where `id` = '423826' and `status` != '1' Trx read view will not see trx with id >= 48986203233, sees < 48960880501 ---TRANSACTION 48983223116, ACTIVE 31512 sec 8 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 4 MySQL thread id 19484260, OS thread handle 0x7fa7c7b15700, query id 693355380 172.16.77.121 db_user_1 insert into `table_2` (`status`, `x_id`, `updated_at`, `created_at`) values ('4', '190748', '2017-11-06 11:56:18', '2017-11-06 11:56:18') Trx read view will not see trx with id >= 48983223141, sees < 48960880501 ---TRANSACTION 48983070794, ACTIVE 31703 sec mysql tables in use 1, locked 1 8 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 3 MySQL thread id 19366110, OS thread handle 0x7fa7517ff700, query id 689079824 172.16.77.121 db_user_1 init update `table_1` set `status` = '4', `updated_at` = '2017-11-06 11:53:06' where `id` = '93170' and `status` != '4' Trx read view will not see trx with id >= 48983070805, sees < 48960880501 ---TRANSACTION 48981266292, ACTIVE 33963 sec 3 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1 MySQL thread id 17971451, OS thread handle 0x7fa75a21d700, query id 638895723 172.16.77.201 db_user_1 init COMMIT ---TRANSACTION 48976313591, ACTIVE 40015 sec 9 lock struct(s), heap size 1136, 5 row lock(s), undo log entries 4 MySQL thread id 14248597, OS thread handle 0x7fa7c7ba9700, query id 501416474 172.16.77.123 db_user_1 insert into `table_2` (`status`, `x_id`, `updated_at`, `created_at`) values ('4', '280755', '2017-11-06 09:34:34', '2017-11-06 09:34:34') Trx read view will not see trx with id >= 48976313600, sees < 48960880501 ---TRANSACTION 48973353929, ACTIVE 44013 sec 5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 3 MySQL thread id 12072287, OS thread handle 0x7fa486c0d700, query id 419791939 172.16.77.123 db_user_1 insert into `table_2` (`status`, `x_id`, `updated_at`, `created_at`) values ('1', '76129', '2017-11-06 08:27:56', '2017-11-06 08:27:56') ---TRANSACTION 48971787935, ACTIVE 46096 sec mysql tables in use 1, locked 1 5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 3 MySQL thread id 11094692, OS thread handle 0x7fa75065d700, query id 381059861 172.16.77.116 db_user_1 query end update `table_1` set `status` = '1', `updated_at` = '2017-11-06 07:53:13' where `id` = '227551' and `status` != '1' Trx read view will not see trx with id >= 48971787943, sees < 48960880501 ---TRANSACTION 48971119228, ACTIVE 47152 sec mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 10646025, OS thread handle 0x7fa7508ad700, query id 363736304 172.16.77.123 db_user_1 init update `table_1` set `status` = '1', `updated_at` = '2017-11-06 07:35:37' where `id` = '85703' ---TRANSACTION 48970889463, ACTIVE 47527 sec estimating records in index range mysql tables in use 1, locked 1 5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 2 MySQL thread id 10490583, OS thread handle 0x7fa485c27700, query id 357772980 172.16.77.116 db_user_1 init update `table_1` set `status` = '1', `updated_at` = '2017-11-06 07:29:22' where `id` = '257693' and `status` != '1' Trx read view will not see trx with id >= 48970889469, sees < 48960880501 ---TRANSACTION 48970204051, ACTIVE 48757 sec mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 10024504, OS thread handle 0x7fa8508ad700, query id 339962116 172.16.77.123 db_user_1 init update `table_1` set `status` = '2', `updated_at` = '2017-11-06 07:08:52' where `id` = '113656' ---TRANSACTION 48969310099, ACTIVE 51014 sec mysql tables in use 1, locked 1 9 lock struct(s), heap size 1136, 5 row lock(s), undo log entries 4 MySQL thread id 9418135, OS thread handle 0x7fa7c6ae5700, query id 317467327 172.16.77.123 db_user_1 query end update `table_1` set `status` = '4', `updated_at` = '2017-11-06 06:31:15' where `id` = '413772' and `status` != '4' Trx read view will not see trx with id >= 48969310101, sees < 48960880501 ---TRANSACTION 48963876754, ACTIVE 84005 sec 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 4756326, OS thread handle 0x7fa48615b700, query id 164159006 172.16.77.201 db_user_1 init COMMIT ---TRANSACTION 48962945076, ACTIVE 85732 sec mysql tables in use 1, locked 1 5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 2 MySQL thread id 3972038, OS thread handle 0x7fa8509d5700, query id 137505327 172.16.77.121 db_user_1 init update `table_1` set `status` = '1', `updated_at` = '2017-11-05 20:52:37' where `id` = '298487' and `status` != '1' Trx read view will not see trx with id >= 48962945078, sees < 48960880501 ---TRANSACTION 48962409019, ACTIVE 86684 sec 4 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1 MySQL thread id 3521544, OS thread handle 0x7fa7145c7700, query id 122124217 172.16.77.121 db_user_1 init COMMIT ---TRANSACTION 48962212170, ACTIVE 87023 sec 10 lock struct(s), heap size 1136, 5 row lock(s), undo log entries 4 MySQL thread id 3351658, OS thread handle 0x7fa71432d700, query id 116347307 172.16.77.201 db_user_1 insert into `table_2` (`status`, `x_id`, `updated_at`, `created_at`) values ('4', '434420', '2017-11-05 20:31:06', '2017-11-05 20:31:06') Trx read view will not see trx with id >= 48962212173, sees < 48960880501 ---TRANSACTION 48961363908, ACTIVE 88394 sec 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 2644334, OS thread handle 0x7fa715563700, query id 92021366 172.16.77.106 db_user_1 init COMMIT ---TRANSACTION 48960880501, ACTIVE 89148 sec mysql tables in use 1, locked 1 5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 3 MySQL thread id 2239630, OS thread handle 0x7fa7157b3700, query id 78109022 172.16.77.121 db_user_1 Unlocking tables update `table_1` set `status` = '1', `updated_at` = '2017-11-05 19:55:42' where `id` = '64301' and `status` != '1' Trx read view will not see trx with id >= 48960880507, sees < 48960880067 -------- 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 17062248 OS file reads, 47164733 OS file writes, 41555726 OS fsyncs 70.20 reads/s, 16384 avg bytes/read, 1303.62 writes/s, 762.01 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 52535, seg size 52537, 1936307 merges merged operations: insert 1997562, delete mark 56960, delete 1042 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 47812069, node heap has 4483 buffer(s) Hash table size 47812069, node heap has 182272 buffer(s) Hash table size 47812069, node heap has 384678 buffer(s) Hash table size 47812069, node heap has 10738 buffer(s) Hash table size 47812069, node heap has 2293 buffer(s) Hash table size 47812069, node heap has 758 buffer(s) Hash table size 47812069, node heap has 16326 buffer(s) Hash table size 47812069, node heap has 188327 buffer(s) 133378.42 hash searches/s, 25307.36 non-hash searches/s --- LOG --- Log sequence number 4451160578960 Log flushed up to 4451160578142 Pages flushed up to 4451074840132 Last checkpoint at 4451071389711 0 pending log flushes, 0 pending chkp writes 24890470 log i/o's done, 279.13 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 198086492160 Dictionary memory allocated 2103029 Buffer pool size 11796480 Free buffers 40945 Database pages 10965660 Old database pages 4047052 Modified db pages 45191 Percent of dirty pages(LRU & free pages): 0.411 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 78128717, not young 52656785 1333.02 youngs/s, 583.08 non-youngs/s Pages read 17066435, created 471760, written 17709665 70.36 reads/s, 5.97 creates/s, 950.53 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 1 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 10965660, unzip_LRU len: 0 I/O sum[2092640]:cur[38640], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 294912 Free buffers 1024 Database pages 274012 Old database pages 101128 Modified db pages 1440 Percent of dirty pages(LRU & free pages): 0.524 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2024741, not young 1421280 36.93 youngs/s, 10.57 non-youngs/s Pages read 430295, created 11199, written 442700 1.80 reads/s, 0.03 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 3 / 1000 not 1 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274012, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 294912 Free buffers 1024 Database pages 274022 Old database pages 101132 Modified db pages 6 Percent of dirty pages(LRU & free pages): 0.002 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1956841, not young 1422486 32.87 youngs/s, 41.83 non-youngs/s Pages read 426401, created 11521, written 441233 1.73 reads/s, 0.00 creates/s, 14.57 writes/s Buffer pool hit rate 999 / 1000, young-making rate 3 / 1000 not 4 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274022, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 294912 Free buffers 1024 Database pages 274082 Old database pages 101154 Modified db pages 2718 Percent of dirty pages(LRU & free pages): 0.988 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1843804, not young 1394776 33.07 youngs/s, 15.60 non-youngs/s Pages read 424366, created 12265, written 445837 1.47 reads/s, 0.03 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 1 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274082, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 294912 Free buffers 1024 Database pages 274196 Old database pages 101196 Modified db pages 792 Percent of dirty pages(LRU & free pages): 0.288 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1840864, not young 1226769 34.70 youngs/s, 3.67 non-youngs/s Pages read 412331, created 11324, written 441070 2.03 reads/s, 0.00 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 1 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274196, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 294912 Free buffers 1024 Database pages 274128 Old database pages 101171 Modified db pages 497 Percent of dirty pages(LRU & free pages): 0.181 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1892680, not young 1378535 27.00 youngs/s, 2.13 non-youngs/s Pages read 419492, created 10655, written 441480 1.57 reads/s, 0.07 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 1 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274128, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 294912 Free buffers 1024 Database pages 274211 Old database pages 101202 Modified db pages 1795 Percent of dirty pages(LRU & free pages): 0.652 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1913585, not young 1347417 31.17 youngs/s, 8.20 non-youngs/s Pages read 426260, created 11948, written 443956 2.33 reads/s, 0.07 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274211, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 294912 Free buffers 1024 Database pages 274121 Old database pages 101169 Modified db pages 1666 Percent of dirty pages(LRU & free pages): 0.605 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2059030, not young 1572525 32.00 youngs/s, 41.87 non-youngs/s Pages read 440735, created 12111, written 442235 1.97 reads/s, 0.07 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 3 / 1000 not 4 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274121, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 294912 Free buffers 1023 Database pages 274175 Old database pages 101189 Modified db pages 405 Percent of dirty pages(LRU & free pages): 0.147 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1935740, not young 1223240 32.93 youngs/s, 1.87 non-youngs/s Pages read 416164, created 12530, written 441016 1.30 reads/s, 0.07 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 3 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274175, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 8 Buffer pool size 294912 Free buffers 1023 Database pages 274118 Old database pages 101168 Modified db pages 1359 Percent of dirty pages(LRU & free pages): 0.494 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1891042, not young 1266769 27.90 youngs/s, 4.83 non-youngs/s Pages read 427414, created 10912, written 444770 1.90 reads/s, 0.03 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274118, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 9 Buffer pool size 294912 Free buffers 1024 Database pages 274110 Old database pages 101165 Modified db pages 1054 Percent of dirty pages(LRU & free pages): 0.383 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2067524, not young 1301186 29.33 youngs/s, 43.13 non-youngs/s Pages read 445651, created 11954, written 443807 1.80 reads/s, 0.07 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 3 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274110, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 10 Buffer pool size 294912 Free buffers 1023 Database pages 274229 Old database pages 101209 Modified db pages 110 Percent of dirty pages(LRU & free pages): 0.040 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1816604, not young 935903 35.83 youngs/s, 2.00 non-youngs/s Pages read 404234, created 10416, written 440601 1.40 reads/s, 0.07 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 3 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274229, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 11 Buffer pool size 294912 Free buffers 1024 Database pages 274168 Old database pages 101186 Modified db pages 396 Percent of dirty pages(LRU & free pages): 0.144 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1988113, not young 1129197 34.73 youngs/s, 15.10 non-youngs/s Pages read 419619, created 12102, written 441599 1.50 reads/s, 0.10 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 3 / 1000 not 1 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274168, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 12 Buffer pool size 294912 Free buffers 1024 Database pages 274177 Old database pages 101189 Modified db pages 1854 Percent of dirty pages(LRU & free pages): 0.674 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1794781, not young 1164910 32.37 youngs/s, 2.63 non-youngs/s Pages read 422960, created 12295, written 443741 1.87 reads/s, 0.00 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274177, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 13 Buffer pool size 294912 Free buffers 1024 Database pages 274136 Old database pages 101174 Modified db pages 334 Percent of dirty pages(LRU & free pages): 0.121 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2155310, not young 1506221 36.13 youngs/s, 19.77 non-youngs/s Pages read 442530, created 11335, written 440871 1.93 reads/s, 0.23 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 3 / 1000 not 2 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274136, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 14 Buffer pool size 294912 Free buffers 1023 Database pages 274146 Old database pages 101178 Modified db pages 2215 Percent of dirty pages(LRU & free pages): 0.805 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2066662, not young 1491295 32.13 youngs/s, 2.47 non-youngs/s Pages read 434969, created 11990, written 447218 1.80 reads/s, 0.03 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274146, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 15 Buffer pool size 294912 Free buffers 1024 Database pages 274085 Old database pages 101155 Modified db pages 983 Percent of dirty pages(LRU & free pages): 0.357 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1910404, not young 1335304 31.43 youngs/s, 22.53 non-youngs/s Pages read 427202, created 11495, written 441650 2.03 reads/s, 0.17 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 1 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274085, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 16 Buffer pool size 294912 Free buffers 1024 Database pages 274181 Old database pages 101191 Modified db pages 1048 Percent of dirty pages(LRU & free pages): 0.381 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2006395, not young 1278960 35.20 youngs/s, 5.77 non-youngs/s Pages read 428248, created 12324, written 442574 1.70 reads/s, 0.17 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274181, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 17 Buffer pool size 294912 Free buffers 1024 Database pages 274110 Old database pages 101165 Modified db pages 1625 Percent of dirty pages(LRU & free pages): 0.591 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2074698, not young 1264791 30.50 youngs/s, 37.63 non-youngs/s Pages read 439013, created 11612, written 445307 1.93 reads/s, 0.23 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 3 / 1000 not 4 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274110, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 18 Buffer pool size 294912 Free buffers 1023 Database pages 274142 Old database pages 101176 Modified db pages 614 Percent of dirty pages(LRU & free pages): 0.223 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1917472, not young 1269203 30.53 youngs/s, 7.57 non-youngs/s Pages read 421904, created 11745, written 441927 1.80 reads/s, 0.23 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 1 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274142, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 19 Buffer pool size 294912 Free buffers 1024 Database pages 274140 Old database pages 101176 Modified db pages 153 Percent of dirty pages(LRU & free pages): 0.056 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1936396, not young 1241049 32.30 youngs/s, 73.13 non-youngs/s Pages read 418202, created 12106, written 440874 1.70 reads/s, 0.00 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 5 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274140, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 20 Buffer pool size 294912 Free buffers 1023 Database pages 274093 Old database pages 101159 Modified db pages 678 Percent of dirty pages(LRU & free pages): 0.246 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2205907, not young 1454551 37.73 youngs/s, 3.03 non-youngs/s Pages read 438427, created 12177, written 442851 1.83 reads/s, 0.00 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 3 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274093, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 21 Buffer pool size 294912 Free buffers 1023 Database pages 274188 Old database pages 101193 Modified db pages 1045 Percent of dirty pages(LRU & free pages): 0.380 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1962462, not young 1300858 32.00 youngs/s, 1.87 non-youngs/s Pages read 426331, created 11952, written 444809 1.30 reads/s, 0.23 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274188, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 22 Buffer pool size 294912 Free buffers 1024 Database pages 274163 Old database pages 101184 Modified db pages 1314 Percent of dirty pages(LRU & free pages): 0.477 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1900240, not young 1643315 31.97 youngs/s, 3.37 non-youngs/s Pages read 427767, created 12810, written 442431 1.50 reads/s, 0.20 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 1 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274163, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 23 Buffer pool size 294912 Free buffers 1021 Database pages 274109 Old database pages 101165 Modified db pages 2120 Percent of dirty pages(LRU & free pages): 0.771 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1951146, not young 1598566 34.40 youngs/s, 54.23 non-youngs/s Pages read 437433, created 12017, written 444918 1.67 reads/s, 0.00 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 4 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274109, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 24 Buffer pool size 294912 Free buffers 1024 Database pages 274176 Old database pages 101189 Modified db pages 1385 Percent of dirty pages(LRU & free pages): 0.503 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1994173, not young 1390454 38.80 youngs/s, 19.57 non-youngs/s Pages read 429250, created 11878, written 441975 1.53 reads/s, 0.03 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 4 / 1000 not 2 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274176, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 25 Buffer pool size 294912 Free buffers 1023 Database pages 274094 Old database pages 101159 Modified db pages 1212 Percent of dirty pages(LRU & free pages): 0.441 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1977300, not young 1353368 37.33 youngs/s, 3.30 non-youngs/s Pages read 433214, created 11459, written 442993 2.33 reads/s, 0.10 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 3 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274094, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 26 Buffer pool size 294912 Free buffers 1023 Database pages 274197 Old database pages 101197 Modified db pages 1321 Percent of dirty pages(LRU & free pages): 0.480 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1743812, not young 1008464 29.30 youngs/s, 2.80 non-youngs/s Pages read 410771, created 12128, written 442704 1.70 reads/s, 0.03 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274197, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 27 Buffer pool size 294912 Free buffers 1023 Database pages 274249 Old database pages 101216 Modified db pages 1235 Percent of dirty pages(LRU & free pages): 0.449 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1784844, not young 1024282 33.40 youngs/s, 41.70 non-youngs/s Pages read 413739, created 10967, written 440945 1.80 reads/s, 0.00 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 2 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274249, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 28 Buffer pool size 294912 Free buffers 1024 Database pages 274134 Old database pages 101173 Modified db pages 2044 Percent of dirty pages(LRU & free pages): 0.743 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1981824, not young 1254786 35.60 youngs/s, 38.93 non-youngs/s Pages read 432389, created 12788, written 445457 1.93 reads/s, 0.10 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 3 / 1000 not 3 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274134, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 29 Buffer pool size 294912 Free buffers 1024 Database pages 274205 Old database pages 101200 Modified db pages 201 Percent of dirty pages(LRU & free pages): 0.073 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2077821, not young 1354871 32.20 youngs/s, 3.30 non-youngs/s Pages read 435670, created 11658, written 441912 1.47 reads/s, 2.23 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274205, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 30 Buffer pool size 294912 Free buffers 1025 Database pages 274129 Old database pages 101172 Modified db pages 550 Percent of dirty pages(LRU & free pages): 0.200 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1874809, not young 1078253 29.47 youngs/s, 4.67 non-youngs/s Pages read 420219, created 12191, written 441833 1.43 reads/s, 0.03 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274129, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 31 Buffer pool size 294912 Free buffers 1024 Database pages 274143 Old database pages 101177 Modified db pages 545 Percent of dirty pages(LRU & free pages): 0.198 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1920450, not young 1128676 31.00 youngs/s, 3.03 non-youngs/s Pages read 421719, created 12514, written 441230 1.93 reads/s, 0.07 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 3 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274143, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 32 Buffer pool size 294912 Free buffers 1023 Database pages 274204 Old database pages 101200 Modified db pages 1433 Percent of dirty pages(LRU & free pages): 0.521 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1996639, not young 1370139 38.27 youngs/s, 4.73 non-youngs/s Pages read 426499, created 11035, written 442283 1.70 reads/s, 0.03 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274204, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 33 Buffer pool size 294912 Free buffers 1024 Database pages 274230 Old database pages 101209 Modified db pages 773 Percent of dirty pages(LRU & free pages): 0.281 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1950010, not young 1512800 33.07 youngs/s, 11.63 non-youngs/s Pages read 428988, created 10921, written 442636 2.10 reads/s, 0.00 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274230, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 34 Buffer pool size 294912 Free buffers 1024 Database pages 274160 Old database pages 101183 Modified db pages 782 Percent of dirty pages(LRU & free pages): 0.284 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2044187, not young 1330897 31.73 youngs/s, 3.80 non-youngs/s Pages read 419825, created 11822, written 441123 2.00 reads/s, 0.07 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 1 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274160, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 35 Buffer pool size 294912 Free buffers 1023 Database pages 274098 Old database pages 101160 Modified db pages 1976 Percent of dirty pages(LRU & free pages): 0.718 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1864278, not young 1245376 31.17 youngs/s, 2.40 non-youngs/s Pages read 425512, created 12245, written 442873 1.70 reads/s, 0.23 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274098, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 36 Buffer pool size 294912 Free buffers 1024 Database pages 274109 Old database pages 101164 Modified db pages 1834 Percent of dirty pages(LRU & free pages): 0.667 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2002483, not young 1354361 40.03 youngs/s, 3.37 non-youngs/s Pages read 431252, created 12065, written 443770 2.07 reads/s, 0.07 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 4 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274109, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 37 Buffer pool size 294912 Free buffers 1023 Database pages 274095 Old database pages 101159 Modified db pages 316 Percent of dirty pages(LRU & free pages): 0.115 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2016665, not young 1225284 39.10 youngs/s, 1.57 non-youngs/s Pages read 420258, created 11380, written 440550 1.13 reads/s, 0.53 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274095, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 38 Buffer pool size 294912 Free buffers 1024 Database pages 274109 Old database pages 101164 Modified db pages 1805 Percent of dirty pages(LRU & free pages): 0.656 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1837313, not young 1465316 33.40 youngs/s, 11.17 non-youngs/s Pages read 433756, created 11980, written 443930 2.17 reads/s, 0.03 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274109, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] ---BUFFER POOL 39 Buffer pool size 294912 Free buffers 1024 Database pages 274086 Old database pages 101156 Modified db pages 1558 Percent of dirty pages(LRU & free pages): 0.566 Max dirty pages percent: 0.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1949668, not young 1390352 34.03 youngs/s, 2.33 non-youngs/s Pages read 425426, created 11934, written 443976 1.50 reads/s, 0.30 creates/s, 24.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 274086, unzip_LRU len: 0 I/O sum[52316]:cur[966], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 20 read views open inside InnoDB Process ID=24580, Main thread ID=140361561831168, state: sleeping Number of rows inserted 23717489, updated 14460517, deleted 54823, read 17760074073 268.36 inserts/s, 164.13 updates/s, 0.60 deletes/s, 69168.49 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 ============================