Monitor output is: ===================================== 2018-05-22 13:20:37 0x7f7e5cbad700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 2343 srv_active, 0 srv_shutdown, 54 srv_idle srv_master_thread log flush and writes: 0 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 53236804 --Thread 140221749032704 has waited at buf0buf.cc line 3163 for 950.00 seconds the semaphore: S-lock on RW-latch at 0x7f82370313f0 created in file buf0buf.cc line 775 a writer (thread id 140221749032704) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0buf.cc line 3163 Last time write locked in file /data/users/mcallaghan/mysql.me/orig8011/storage/innobase/buf/buf0buf.cc line 4287 --Thread 140222405121792 has waited at buf0buf.cc line 3163 for 950.00 seconds the semaphore: S-lock on RW-latch at 0x7f877d4cad98 created in file buf0buf.cc line 775 a writer (thread id 140222405121792) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0buf.cc line 3163 Last time write locked in file /data/users/mcallaghan/mysql.me/orig8011/storage/innobase/buf/buf0buf.cc line 4287 --Thread 140180841031424 has waited at mtr0mtr.ic line 142 for 3.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x7f87ec5b1760 created in file buf0buf.cc line 775 a writer (thread id 140180841031424) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file ibuf0ibuf.cc line 4122 Last time write locked in file /data/users/mcallaghan/mysql.me/orig8011/storage/innobase/btr/btr0btr.cc line 163 --Thread 140180849424128 has waited at btr0cur.cc line 200 for 3.00 seconds the semaphore: X-lock on RW-latch at 0x7f852f1a1720 created in file buf0buf.cc line 775 a writer (thread id 140221963298560) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.cc line 200 Last time write locked in file /data/users/mcallaghan/mysql.me/orig8011/storage/innobase/btr/btr0cur.cc line 200 OS WAIT ARRAY INFO: signal count 90230941 RW-shared spins 58408456, rounds 90619485, OS waits 32464972 RW-excl spins 38996322, rounds 51246615, OS waits 265582 RW-sx spins 7356687, rounds 30189747, OS waits 17059 Spin rounds per wait: 1.55 RW-shared, 1.31 RW-excl, 4.10 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 6019139 Purge done for trx's n:o < 5966005 undo n:o < 0 state: running but idle History list length 18 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 6019138, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 12 MySQL thread id 105, OS thread handle 140221929146112, query id 6019787 localhost 127.0.0.1 root update insert into pi23 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",645,86062,6835,862.46,"aaaaaaaZ/db"), ("2018-05-22 13:04:47",45,6354,7624,67.00,"aaaaaaactzc"), ("2018-05-22 13:04:47",673,49160,9910,494.21,"aaaaaaaaaaOCc5h"), ("2018-05-22 13:04:47",526,1893,4260,22.15,"aaaaaaaaa1opPG"), ("2018-05-22 13:04:47",490,66412,9599,666.53,"aaaaaaaaaOlYY9"), ("2018-05-22 13:04:47",756,62667,5380,630.46,"aaaaaaaGN5"), ("2018-05-22 13:04:47",889,34817,3326,350.34,"aaaaaaaaaaOQMkOp"), ("2018-05-22 13:04:47",105,9676,6268,98.00,"aaaaaaaammdw"), ("2018-05-22 13:04: ---TRANSACTION 6019136, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 52 MySQL thread id 139, OS thread handle 140221749032704, query id 6019785 localhost 127.0.0.1 root update insert into pi32 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",898,71642,315,718.93,"aaaaaaaaazgtIQ"), ("2018-05-22 13:04:47",699,19239,6277,193.85,"aaaaaaaS7pb"), ("2018-05-22 13:04:47",374,87133,3193,875.74,"aaaaaaaIycc"), ("2018-05-22 13:04:47",177,47903,8182,483.58,"aaaaaaaanhoa"), ("2018-05-22 13:04:47",62,59468,2702,594.99,"aaaaaaaOwQV"), ("2018-05-22 13:04:47",344,88498,3950,886.78,"aaaaaaaaaaDpvuRJ"), ("2018-05-22 13:04:47",862,87156,1515,875.21,"aaaaaaaaaaaaS5ZYQc"), ("2018-05-22 13:04:47",424,8044,1434,84.48,"aaaaaaaaaaaaHFiQCVI"), ("2018- ---TRANSACTION 6019135, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 43 MySQL thread id 43, OS thread handle 140222405121792, query id 6019784 localhost 127.0.0.1 root update insert into pi6 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",594,34743,3520,348.98,"aaaaaaaaaaaaaw9zdm"), ("2018-05-22 13:04:47",553,55031,5407,553.75,"aaaaaaaaaLxTW4"), ("2018-05-22 13:04:47",437,26993,2963,274.59,"aaaaaaaaaaupaSD"), ("2018-05-22 13:04:47",248,58568,3536,587.88,"aaaaaaaaaaZDddX"), ("2018-05-22 13:04:47",171,5020,9814,53.28,"aaaaaaaaaaaacVvrKE"), ("2018-05-22 13:04:47",4,94706,4888,950.26,"aaaaaaaaaaaaVVNKi5b"), ("2018-05-22 13:04:47",326,11611,9998,119.07,"aaaaaaazJxj"), ("2018-05-22 13:04:47",66,12632,4896,126.66,"aaaaaaaaaaaalYH ---TRANSACTION 6019134, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 84, OS thread handle 140221992834816, query id 6019783 localhost 127.0.0.1 root update insert into pi17 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",817,72788,558,732.67,"aaaaaaaaas79n"), ("2018-05-22 13:04:47",273,1208,4884,15.49,"aaaaaaaaaamD5T0"), ("2018-05-22 13:04:47",454,57174,1531,576.61,"aaaaaaaaaaBMb2y"), ("2018-05-22 13:04:47",745,83503,8638,836.49,"aaaaaaaaa+YO+"), ("2018-05-22 13:04:47",263,80926,9056,809.80,"aaaaaaaaNtDA"), ("2018-05-22 13:04:47",734,11228,4703,116.08,"aaaaaaaaayZ9g"), ("2018-05-22 13:04:47",81,99335,9423,994.50,"aaaaaaaaaaaaacfCGCbh"), ("2018-05-22 13:04:47",770,2529,3096,26.07,"aaaaaaaaaaaaDV708r"), (" ---TRANSACTION 6019131, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 53 MySQL thread id 73, OS thread handle 140221993707264, query id 6019780 localhost 127.0.0.1 root update insert into pi14 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",430,60933,2341,611.41,"aaaaaaa04J"), ("2018-05-22 13:04:47",230,58677,5292,588.73,"aaaaaaaaaa3TNYQ"), ("2018-05-22 13:04:47",426,78257,5118,786.57,"aaaaaaabDDD"), ("2018-05-22 13:04:47",419,39518,7716,397.49,"aaaaaaaaaaZFAZV3"), ("2018-05-22 13:04:47",601,27395,3021,278.06,"aaaaaaaaajGBl"), ("2018-05-22 13:04:47",585,83434,8065,838.55,"aaaaaaaaaaaaa9L0HDvX"), ("2018-05-22 13:04:47",188,36363,8000,366.68,"aaaaaaa3o4i"), ("2018-05-22 13:04:47",381,8906,3058,92.89,"aaaaaaaaaaKz76n"), ("2018 ---TRANSACTION 6019129, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 6 MySQL thread id 70, OS thread handle 140222008739584, query id 6019778 localhost 127.0.0.1 root update insert into pi13 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",561,91770,5803,920.66,"aaaaaaaaaaaaaNX998e8"), ("2018-05-22 13:04:47",281,88491,6295,886.43,"aaaaaaaaaaaaaTMUcMYF"), ("2018-05-22 13:04:47",636,34311,4793,345.42,"aaaaaaaaaaaatExJw1u"), ("2018-05-22 13:04:47",998,75151,3154,755.06,"aaaaaaaaaaagOkxHj"), ("2018-05-22 13:04:47",429,49713,6506,502.10,"aaaaaaa3/aI"), ("2018-05-22 13:04:47",162,91570,9396,918.94,"aaaaaaaaaaaa0d9ezh"), ("2018-05-22 13:04:47",878,90578,8271,909.21,"aaaaaaaaaaaasEgDON"), ("2018-05-22 13:04:47",411,77975,9419,782. ---TRANSACTION 6019128, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 28 MySQL thread id 25, OS thread handle 140222406575872, query id 6019777 localhost 127.0.0.1 root update insert into pi1 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",415,49837,4375,500.26,"aaaaaaaaa6SmV"), ("2018-05-22 13:04:47",366,75943,3521,762.99,"aaaaaaaaaaaaTTBZ/d"), ("2018-05-22 13:04:47",685,42056,4534,422.86,"aaaaaaaaa0Fuk"), ("2018-05-22 13:04:47",349,42279,1273,425.15,"aaaaaaaaahUPw"), ("2018-05-22 13:04:47",866,53660,8083,539.31,"aaaaaaaaaaNsBGn"), ("2018-05-22 13:04:47",495,90905,4778,912.01,"aaaaaaaaaJoq0"), ("2018-05-22 13:04:47",843,3994,8051,40.82,"aaaaaaaaaaaaaI0ZpV2F"), ("2018-05-22 13:04:47",466,9597,4983,97.44,"aaaaaaaaaaah65/lp") ---TRANSACTION 6019127, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 46 MySQL thread id 135, OS thread handle 140221749323520, query id 6019776 localhost 127.0.0.1 root update insert into pi31 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",963,78451,7385,788.79,"aaaaaaaaaa/8b/Wx"), ("2018-05-22 13:04:47",456,18432,2654,184.96,"aaaaaaaaaaZD63hb"), ("2018-05-22 13:04:47",132,40652,3077,406.59,"aaaaaaaBEC"), ("2018-05-22 13:04:47",392,36220,6841,363.20,"aaaaaaaI8vw"), ("2018-05-22 13:04:47",856,18050,2526,184.47,"aaaaaaaaaaaaHpbXAnY"), ("2018-05-22 13:04:47",913,42150,7356,421.79,"aaaaaaaaaail47R"), ("2018-05-22 13:04:47",440,77337,8568,775.06,"aaaaaaaaaVSTXY"), ("2018-05-22 13:04:47",318,58224,1184,587.08,"aaaaaaaiYX"), ("20 ---TRANSACTION 6019124, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 23 MySQL thread id 124, OS thread handle 140221900556032, query id 6019773 localhost 127.0.0.1 root update insert into pi28 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",632,63619,7644,640.13,"aaaaaaaaaaOLzdf"), ("2018-05-22 13:04:47",810,13446,6766,135.58,"aaaaaaaa2AfG"), ("2018-05-22 13:04:47",54,46468,4010,466.48,"aaaaaaaaaalPrgK"), ("2018-05-22 13:04:47",472,70600,8360,708.09,"aaaaaaaaaaaaash/CK5f"), ("2018-05-22 13:04:47",89,99587,1456,997.53,"aaaaaaaaaaaaaTHL89BP"), ("2018-05-22 13:04:47",10,31791,8829,322.56,"aaaaaaa3kvn"), ("2018-05-22 13:04:47",899,15610,2687,158.07,"aaaaaaaaaaaa1nj+xe"), ("2018-05-22 13:04:47",73,19699,3420,200.00,"aaaaaaaaaaaa ---TRANSACTION 6019123, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 15 MySQL thread id 121, OS thread handle 140221900265216, query id 6019772 localhost 127.0.0.1 root update insert into pi27 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",123,1146,5936,15.60,"aaaaaaaaaaaarbReAJ8"), ("2018-05-22 13:04:47",678,80398,870,808.48,"aaaaaaaUYP"), ("2018-05-22 13:04:47",905,82432,4423,824.90,"aaaaaaaaP3Ir"), ("2018-05-22 13:04:47",983,15134,715,152.12,"aaaaaaaaaaaai3Wklx"), ("2018-05-22 13:04:47",920,89488,2699,898.92,"aaaaaaaaaaaahjbZ9Q"), ("2018-05-22 13:04:47",564,47480,9884,475.17,"aaaaaaaE2bP"), ("2018-05-22 13:04:47",522,56845,5003,571.09,"aaaaaaaaaaaaaHasc8Ih"), ("2018-05-22 13:04:47",641,97744,7442,980.82,"aaaaaaaaaaaaaVg ---TRANSACTION 6019122, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 36 MySQL thread id 102, OS thread handle 140221929436928, query id 6019771 localhost 127.0.0.1 root update insert into pi22 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",80,12956,3225,132.26,"aaaaaaaaaaaaf7XIBl"), ("2018-05-22 13:04:47",558,37709,7125,377.18,"aaaaaaaaa+hug"), ("2018-05-22 13:04:47",30,2156,7514,24.47,"aaaaaaaaRc+X"), ("2018-05-22 13:04:47",92,30380,1727,305.93,"aaaaaaaaaaVn9XS"), ("2018-05-22 13:04:47",76,33462,2073,339.30,"aaaaaaa2MAz"), ("2018-05-22 13:04:47",665,4696,3942,48.18,"aaaaaaaaG0zp"), ("2018-05-22 13:04:47",848,50971,8985,511.56,"aaaaaaaDoRu"), ("2018-05-22 13:04:47",972,19256,5951,194.14,"aaaaaaaaaaaaaWSNhmIq"), ("2018-05-2 ---TRANSACTION 6019121, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 51 MySQL thread id 54, OS thread handle 140222009902848, query id 6019770 localhost 127.0.0.1 root update insert into pi9 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",361,47616,3916,480.32,"aaaaaaaOCQr"), ("2018-05-22 13:04:47",943,27029,9272,273.50,"aaaaaaaaaaaaJfWQXV"), ("2018-05-22 13:04:47",836,10617,9819,110.46,"aaaaaaaaHpur"), ("2018-05-22 13:04:47",152,23681,8613,241.37,"aaaaaaaa6sC+"), ("2018-05-22 13:04:47",992,21875,5968,221.71,"aaaaaaaaaaxQfoL"), ("2018-05-22 13:04:47",681,34688,3046,351.41,"aaaaaaaaaaaaaeLXcg4b"), ("2018-05-22 13:04:47",307,1539,7904,16.73,"aaaaaaaaa1G+Iv"), ("2018-05-22 13:04:47",899,60491,9745,608.88,"aaaaaaaaaaaagZkkKh9" ---TRANSACTION 6019117, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 19 MySQL thread id 28, OS thread handle 140222406285056, query id 6019766 localhost 127.0.0.1 root update insert into pi2 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",191,10124,3964,102.81,"aaaaaaaaaajOzaj"), ("2018-05-22 13:04:47",281,39499,7535,397.40,"aaaaaaaaaaaBVmzbQ"), ("2018-05-22 13:04:47",32,85401,9197,858.84,"aaaaaaaaaPTuj"), ("2018-05-22 13:04:47",947,72046,3172,723.65,"aaaaaaaaaaaaWNYnBu"), ("2018-05-22 13:04:47",11,98117,8832,983.64,"aaaaaaaaaavHCXtO"), ("2018-05-22 13:04:47",379,69151,1751,694.46,"aaaaaaaDBe"), ("2018-05-22 13:04:47",866,97422,7687,974.80,"aaaaaaaaaaaaa8PLF4Au"), ("2018-05-22 13:04:47",715,56588,9363,569.76,"aaaaaaaaafSug ---TRANSACTION 6019113, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 58 MySQL thread id 51, OS thread handle 140222010193664, query id 6019762 localhost 127.0.0.1 root update insert into pi8 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",94,36763,9646,368.62,"aaaaaaaaaaMrPK8"), ("2018-05-22 13:04:47",401,33322,9245,333.54,"aaaaaaaaaaKUaWs"), ("2018-05-22 13:04:47",714,76504,2457,766.16,"aaaaaaaaaT6pqe"), ("2018-05-22 13:04:47",361,83590,7224,840.17,"aaaaaaahJ3B"), ("2018-05-22 13:04:47",572,99277,69,995.45,"aaaaaaaalWBa"), ("2018-05-22 13:04:47",301,14157,89,141.61,"aaaaaaaaMeLs"), ("2018-05-22 13:04:47",143,6978,6477,72.84,"aaaaaaaaa3NC+q"), ("2018-05-22 13:04:47",765,69945,7233,699.74,"aaaaaaaaaZ5tG9"), ("2018-05-22 13: ---TRANSACTION 6019112, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 30 MySQL thread id 66, OS thread handle 140222009030400, query id 6019761 localhost 127.0.0.1 root update insert into pi12 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",126,48882,6355,492.30,"aaaaaaaaaaaaPZQ5YoQ"), ("2018-05-22 13:04:47",872,84939,5793,851.14,"aaaaaaaaaQwjGd"), ("2018-05-22 13:04:47",161,43615,9588,437.42,"aaaaaaagxOF"), ("2018-05-22 13:04:47",870,51147,8500,511.54,"aaaaaaaaahaam"), ("2018-05-22 13:04:47",10,91458,3386,917.44,"aaaaaaaaaaaapUFYZ/Y"), ("2018-05-22 13:04:47",530,4429,2808,45.56,"aaaaaaaaaaaajRzr3T"), ("2018-05-22 13:04:47",97,75201,2346,755.55,"aaaaaaaYlbI"), ("2018-05-22 13:04:47",765,17480,9449,177.74,"aaaaaaaaaaaanDWXHm ---TRANSACTION 6019110, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 12 MySQL thread id 95, OS thread handle 140221991962368, query id 6019759 localhost 127.0.0.1 root update insert into pi20 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",404,13547,4743,136.10,"aaaaaaaaKQPE"), ("2018-05-22 13:04:47",816,43394,9851,438.02,"aaaaaaaaaaaB/Vn0T"), ("2018-05-22 13:04:47",307,58182,588,586.48,"aaaaaaaaa5EeaM"), ("2018-05-22 13:04:47",789,80950,7166,813.04,"aaaaaaaaaaaaVySfSc"), ("2018-05-22 13:04:47",303,55684,1552,561.20,"aaaaaaaaaaaaiPMs2B"), ("2018-05-22 13:04:47",253,68272,4922,686.71,"aaaaaaaaaaaaKeEnu/"), ("2018-05-22 13:04:47",188,7388,193,77.07,"aaaaaaaa0Vra"), ("2018-05-22 13:04:47",440,51968,4586,523.64,"aaaaaaaah+MC") ---TRANSACTION 6019109, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 52 MySQL thread id 128, OS thread handle 140221899974400, query id 6019758 localhost 127.0.0.1 root update insert into pi29 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",383,213,8533,5.30,"aaaaaaaaaaaah6JQUra"), ("2018-05-22 13:04:47",795,20984,8782,211.88,"aaaaaaaaaaaaz06CtI"), ("2018-05-22 13:04:47",313,89123,3697,895.46,"aaaaaaaaaabJldK"), ("2018-05-22 13:04:47",152,12608,9975,130.93,"aaaaaaaaaa3Yko+"), ("2018-05-22 13:04:47",685,89505,1136,895.63,"aaaaaaaaaaaajhMHoBx"), ("2018-05-22 13:04:47",141,76558,529,769.61,"aaaaaaaaaaaqwep2l"), ("2018-05-22 13:04:47",893,47125,669,472.45,"aaaaaaaaaaaa9T3IXA"), ("2018-05-22 13:04:47",250,20765,8404,208.45,"aaaa ---TRANSACTION 6019108, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 83 MySQL thread id 109, OS thread handle 140221901428480, query id 6019757 localhost 127.0.0.1 root update insert into pi24 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",490,23058,6383,234.10,"aaaaaaaaaaaaZbwqybG"), ("2018-05-22 13:04:47",308,66965,3785,673.73,"aaaaaaaaaBeWi"), ("2018-05-22 13:04:47",615,67877,3019,680.23,"aaaaaaaaaaaakwthE1u"), ("2018-05-22 13:04:47",906,93244,9969,932.81,"aaaaaaaaaaaWwTlU4"), ("2018-05-22 13:04:47",766,8971,1786,92.90,"aaaaaaaaaaaaRqzj89c"), ("2018-05-22 13:04:47",171,56857,3751,572.30,"aaaaaaaaaUOfYi"), ("2018-05-22 13:04:47",38,8467,664,85.21,"aaaaaaaaa5n88J"), ("2018-05-22 13:04:47",935,57440,9785,575.73,"aaaaaaaaaa ---TRANSACTION 6019107, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 7 MySQL thread id 80, OS thread handle 140221993125632, query id 6019756 localhost 127.0.0.1 root update insert into pi16 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",623,97960,2403,979.74,"aaaaaaaaaa5vFeoZ"), ("2018-05-22 13:04:47",924,56805,3674,570.64,"aaaaaaaaaaaaaB1a4Ggy"), ("2018-05-22 13:04:47",195,82537,9558,828.34,"aaaaaaaaaRCgD"), ("2018-05-22 13:04:47",43,19585,7870,198.74,"aaaaaaaaaaUiOb0"), ("2018-05-22 13:04:47",169,6887,120,72.44,"aaaaaaa5e1R"), ("2018-05-22 13:04:47",427,16945,4425,171.12,"aaaaaaaaaaaBnCJBy"), ("2018-05-22 13:04:47",823,93330,7208,933.90,"aaaaaaaaaaIIGAZ"), ("2018-05-22 13:04:47",887,28444,8901,286.11,"aaaaaaaaaOO0N"), ---TRANSACTION 6019103, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 44 MySQL thread id 32, OS thread handle 140222405994240, query id 6019752 localhost 127.0.0.1 root update insert into pi3 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",555,95385,8983,958.58,"aaaaaaaaaTuzZ"), ("2018-05-22 13:04:47",395,49398,9484,495.72,"aaaaaaaaaaajzDJ8y"), ("2018-05-22 13:04:47",865,93552,2446,938.68,"aaaaaaaaaai8EO+"), ("2018-05-22 13:04:47",505,19370,7389,193.80,"aaaaaaaaG+li"), ("2018-05-22 13:04:47",574,39600,8385,398.16,"aaaaaaaaaalulUW"), ("2018-05-22 13:04:47",158,22729,7526,230.75,"aaaaaaaaaaKCkhKE"), ("2018-05-22 13:04:47",743,96720,673,967.95,"aaaaaaaaaaqGSko"), ("2018-05-22 13:04:47",352,29544,8724,296.17,"aaaaaaaaaaaawXgr4m ---TRANSACTION 6019100, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 12 MySQL thread id 58, OS thread handle 140222009612032, query id 6019749 localhost 127.0.0.1 root update insert into pi10 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",528,3866,9031,42.37,"aaaaaaaFo22"), ("2018-05-22 13:04:47",536,31327,8690,315.17,"aaaaaaaaacL8NP"), ("2018-05-22 13:04:47",522,58826,6277,589.59,"aaaaaaaaaCMa7"), ("2018-05-22 13:04:47",992,82306,7338,825.89,"aaaaaaaaaa8mLSf"), ("2018-05-22 13:04:47",160,64316,8194,646.14,"aaaaaaaaaaaaS8EqhE2"), ("2018-05-22 13:04:47",843,4757,7262,48.48,"aaaaaaaaaafhWIAx"), ("2018-05-22 13:04:47",957,13141,4674,135.72,"aaaaaaaaaaaaaGbOXEdl"), ("2018-05-22 13:04:47",460,23816,257,238.68,"aaaaaaaaaaaaaE8c ---TRANSACTION 6019099, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 41 MySQL thread id 39, OS thread handle 140222405412608, query id 6019748 localhost 127.0.0.1 root update insert into pi5 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",847,93395,2647,936.45,"aaaaaaaagprJ"), ("2018-05-22 13:04:47",804,37856,5962,380.86,"aaaaaaaJr+w"), ("2018-05-22 13:04:47",833,88128,9167,882.40,"aaaaaaaaaaq08KT"), ("2018-05-22 13:04:47",624,86925,6422,872.44,"aaaaaaaa0gtu"), ("2018-05-22 13:04:47",447,17287,3609,173.14,"aaaaaaaaasyvj"), ("2018-05-22 13:04:47",554,59812,2135,602.95,"aaaaaaa4MH"), ("2018-05-22 13:04:47",89,95901,6902,962.11,"aaaaaaaaa9V36b"), ("2018-05-22 13:04:47",150,41023,8020,410.49,"aaaaaaaaaaMWFxjQ"), ("2018-05-22 1 ---TRANSACTION 6019097, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 74 MySQL thread id 116, OS thread handle 140221901137664, query id 6019746 localhost 127.0.0.1 root update insert into pi26 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",875,27261,1002,276.01,"aaaaaaaaaaaTtfMbo"), ("2018-05-22 13:04:47",40,8782,8871,88.52,"aaaaaaaaaaaaHcdZvc8"), ("2018-05-22 13:04:47",525,36858,8780,372.75,"aaaaaaaaaaaaaLujF4Ft"), ("2018-05-22 13:04:47",169,83886,227,839.37,"aaaaaaaaaaaaDeXqUOx"), ("2018-05-22 13:04:47",787,39587,4003,396.06,"aaaaaaaaaaaaa7YIVYuv"), ("2018-05-22 13:04:47",96,69042,9782,692.46,"aaaaaaa8x4"), ("2018-05-22 13:04:47",949,40885,1005,411.60,"aaaaaaaaanZmBs"), ("2018-05-22 13:04:47",545,76219,1729,767.18,"aaaaa ---TRANSACTION 6019091, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 72 MySQL thread id 47, OS thread handle 140222010484480, query id 6019740 localhost 127.0.0.1 root update insert into pi7 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",685,37944,9206,379.78,"aaaaaaaLQI8"), ("2018-05-22 13:04:47",3,89203,2656,895.78,"aaaaaaaaURFU"), ("2018-05-22 13:04:47",655,64724,6498,650.80,"aaaaaaaa7e7G"), ("2018-05-22 13:04:47",680,25627,8265,259.79,"aaaaaaaSwv"), ("2018-05-22 13:04:47",864,52326,3224,527.16,"aaaaaaaaaaakiJp4t"), ("2018-05-22 13:04:47",55,56666,9135,568.57,"aaaaaaacHWD"), ("2018-05-22 13:04:47",631,23067,3195,234.92,"aaaaaaaaaaynDUh"), ("2018-05-22 13:04:47",798,8911,7038,93.39,"aaaaaaaaaaaag6kjBz"), ("2018-05-22 13 ---TRANSACTION 6019090, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 58 MySQL thread id 91, OS thread handle 140221992253184, query id 6019739 localhost 127.0.0.1 root update insert into pi19 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",349,69522,5154,699.08,"aaaaaaa4R8i"), ("2018-05-22 13:04:47",714,39135,971,395.99,"aaaaaaaaaaaaa9kPRIKX"), ("2018-05-22 13:04:47",26,60025,6887,604.74,"aaaaaaajC0v"), ("2018-05-22 13:04:47",28,98111,3772,981.32,"aaaaaaaaaaENea2"), ("2018-05-22 13:04:47",473,60549,2998,607.01,"aaaaaaaT1HM"), ("2018-05-22 13:04:47",475,41535,5665,417.77,"aaaaaaaaWQaJ"), ("2018-05-22 13:04:47",771,25470,8786,259.08,"aaaaaaaaQrb2"), ("2018-05-22 13:04:47",103,26265,1261,265.29,"aaaaaaaTc/7"), ("2018-05-22 13 ---TRANSACTION 6019087, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 80 MySQL thread id 61, OS thread handle 140222009321216, query id 6019736 localhost 127.0.0.1 root update insert into pi11 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",413,82688,3878,827.91,"aaaaaaaaaaasqLaXI"), ("2018-05-22 13:04:47",514,75250,6336,755.68,"aaaaaaaaaaaa1HAKLh"), ("2018-05-22 13:04:47",550,19645,119,196.60,"aaaaaaaaaKEDbL"), ("2018-05-22 13:04:47",62,3266,530,35.30,"aaaaaaaJvfB"), ("2018-05-22 13:04:47",835,8005,1354,82.49,"aaaaaaaa83Mr"), ("2018-05-22 13:04:47",671,5326,1396,56.34,"aaaaaaaadDtA"), ("2018-05-22 13:04:47",494,69411,6472,696.62,"aaaaaaaaaaaI1XS+5"), ("2018-05-22 13:04:47",235,28436,2941,289.21,"aaaaaaaguP"), ("2018-05-22 ---TRANSACTION 6019085, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 51 MySQL thread id 35, OS thread handle 140222405703424, query id 6019734 localhost 127.0.0.1 root update insert into pi4 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",361,53040,2726,531.02,"aaaaaaaaavvNb"), ("2018-05-22 13:04:47",132,79097,434,792.04,"aaaaaaaaaoVgd"), ("2018-05-22 13:04:47",811,9555,8774,100.47,"aaaaaaaaaaaaS+k5ngl"), ("2018-05-22 13:04:47",91,32104,9851,325.98,"aaaaaaaaaaUdmBw"), ("2018-05-22 13:04:47",813,74350,6885,747.51,"aaaaaaaaaa9vsEsw"), ("2018-05-22 13:04:47",503,17257,3011,175.61,"aaaaaaaaaaZEDfX"), ("2018-05-22 13:04:47",401,85720,2762,859.89,"aaaaaaaaaaaazFuHh0I"), ("2018-05-22 13:04:47",98,78587,688,786.68,"aaaaaaaTWw"), ( ---TRANSACTION 6019079, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 3 MySQL thread id 77, OS thread handle 140221993416448, query id 6019728 localhost 127.0.0.1 root update insert into pi15 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",657,54160,9777,544.20,"aaaaaaaaaaaanczrlgK"), ("2018-05-22 13:04:47",233,18990,1536,192.00,"aaaaaaaaaanPuWoO"), ("2018-05-22 13:04:47",314,85550,5892,857.01,"aaaaaaaaaaaaZU3VIu/"), ("2018-05-22 13:04:47",193,3053,6638,32.38,"aaaaaaaaaaaaOhkir10"), ("2018-05-22 13:04:47",326,66848,3122,671.32,"aaaaaaaaaag8CCb"), ("2018-05-22 13:04:47",143,80784,5017,808.26,"aaaaaaaaGBw6"), ("2018-05-22 13:04:47",605,75379,7603,754.41,"aaaaaaaaa8XOSY"), ("2018-05-22 13:04:47",994,34534,5332,345.35,"aaaaaaa ---TRANSACTION 6019072, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 37 MySQL thread id 113, OS thread handle 140221900846848, query id 6019721 localhost 127.0.0.1 root update insert into pi25 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",7,90767,895,910.01,"aaaaaaacsNF"), ("2018-05-22 13:04:47",810,45185,5641,456.35,"aaaaaaaaaaaaa0XTQW4d"), ("2018-05-22 13:04:47",791,70773,8928,709.55,"aaaaaaaaaaaaWAgoxA+"), ("2018-05-22 13:04:47",499,38915,2324,390.42,"aaaaaaaAkdX"), ("2018-05-22 13:04:47",672,37070,1970,373.81,"aaaaaaaaaaaaA708Db"), ("2018-05-22 13:04:47",780,92573,2797,929.49,"aaaaaaaaaaaaoz7aYu"), ("2018-05-22 13:04:47",968,34306,4946,347.61,"aaaaaaaaaaldae"), ("2018-05-22 13:04:47",321,19376,322,198.01,"aaaaaaafuus" ---TRANSACTION 6019070, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 37 MySQL thread id 98, OS thread handle 140221929727744, query id 6019719 localhost 127.0.0.1 root update insert into pi21 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",500,26669,5666,267.93,"aaaaaaayrr6"), ("2018-05-22 13:04:47",884,58817,4111,592.43,"aaaaaaaaaaaaiQFCKe"), ("2018-05-22 13:04:47",878,97286,5160,976.76,"aaaaaaaaV0M6"), ("2018-05-22 13:04:47",922,18758,2465,189.28,"aaaaaaaaaaaaeU3rll"), ("2018-05-22 13:04:47",112,23600,8735,239.83,"aaaaaaaa7UXC"), ("2018-05-22 13:04:47",454,55266,667,554.26,"aaaaaaaaaa7PLrS"), ("2018-05-22 13:04:47",74,17398,2941,174.34,"aaaaaaaaaaiCQxxh"), ("2018-05-22 13:04:47",636,32407,7629,327.13,"aaaaaaaaaaaDCrpDe") ---TRANSACTION 6019069, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 72 MySQL thread id 131, OS thread handle 140221899683584, query id 6019718 localhost 127.0.0.1 root update insert into pi30 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",183,9333,9704,95.09,"aaaaaaaaaaaaTNBQ68l"), ("2018-05-22 13:04:47",135,47524,697,479.36,"aaaaaaaaaxGkp"), ("2018-05-22 13:04:47",520,72096,1522,723.29,"aaaaaaa/8J"), ("2018-05-22 13:04:47",939,56903,8251,573.67,"aaaaaaaaaaAmq+N7"), ("2018-05-22 13:04:47",477,88838,6655,889.61,"aaaaaaaaaaVilV6"), ("2018-05-22 13:04:47",456,43091,7369,433.91,"aaaaaaa943c"), ("2018-05-22 13:04:47",337,62922,6252,633.05,"aaaaaaaaaaaaIs9/c6"), ("2018-05-22 13:04:47",58,50365,8434,507.14,"aaaaaaaaaaaaazJhwK9G" ---TRANSACTION 6019067, ACTIVE 950 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 67 MySQL thread id 87, OS thread handle 140221992544000, query id 6019716 localhost 127.0.0.1 root update insert into pi18 (dateandtime,cashregisterid,customerid,productid,price,data) values ("2018-05-22 13:04:47",413,1425,234,14.71,"aaaaaaaaaenhV7"), ("2018-05-22 13:04:47",456,26737,2399,271.15,"aaaaaaaaaajIvVN"), ("2018-05-22 13:04:47",711,80722,438,807.26,"aaaaaaaXdqO"), ("2018-05-22 13:04:47",174,22982,1663,231.25,"aaaaaaaGCKY"), ("2018-05-22 13:04:47",768,32367,1954,326.99,"aaaaaaaaJ4Ga"), ("2018-05-22 13:04:47",523,30279,9439,303.73,"aaaaaaaaayezq"), ("2018-05-22 13:04:47",612,45955,5146,463.27,"aaaaaaacCNo"), ("2018-05-22 13:04:47",153,39466,9214,395.87,"aaaaaaaaaaaanpQIqM"), ("2018-05-22 1 -------- 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: complete io for buf page (read thread) I/O thread 4 state: complete io for buf page (read thread) I/O thread 5 state: complete io for buf page (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) Pending normal aio reads: [0, 24, 24, 27] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 1205 3779143 OS file reads, 643710949 OS file writes, 24233396 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 1.00 writes/s, 1.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- 2018-05-22T20:20:37.535720Z 0 [Warning] [MY-013060] [InnoDB] InnoDB: Log writer is waiting for checkpointer to to catch up lag: 3865952768 bytes, checkpoint LSN: 199802707456 2018-05-22T20:20:37.635829Z 0 [Warning] [MY-013060] [InnoDB] InnoDB: Log writer is waiting for checkpointer to to catch up lag: 3865952768 bytes, checkpoint LSN: 199802707456 2018-05-22T20:20:37.735937Z 0 [ERROR] [MY-013059] [InnoDB] InnoDB: Log writer overwriting data after checkpoint - waited too long (1 second), lag: 3865952768 bytes, checkpoint LSN: 199802707456 2018-05-22T20:20:37.735987Z 0 [Warning] [MY-013060] [InnoDB] InnoDB: Log writer is waiting for checkpointer to to catch up lag: 3865953280 bytes, checkpoint LSN: 199802707456 2018-05-22T20:20:37.836093Z 0 [Warning] [MY-013060] [InnoDB] InnoDB: Log writer is waiting for checkpointer to to catch up lag: 3865953280 bytes, checkpoint LSN: 199802707456 2018-05-22T20:20:37.936201Z 0 [Warning] [MY-013060] [InnoDB] InnoDB: Log writer is waiting for checkpointer to to catch up lag: 3865953280 bytes, checkpoint LSN: 199802707456 2018-05-22T20:20:38.036317Z 0 [Warning] [MY-013060] [InnoDB] InnoDB: Log writer is waiting for checkpointer to to catch up lag: 3865953280 bytes, checkpoint LSN: 199802707456 2018-05-22T20:20:38.136427Z 0 [Warning] [MY-013060] [InnoDB] InnoDB: Log writer is waiting for checkpointer to to catch up lag: 3865953280 bytes, checkpoint LSN: 199802707456 2018-05-22T20:20:38.236533Z 0 [Warning] [MY-013060] [InnoDB] InnoDB: Log writer is waiting for checkpointer to to catch up lag: 3865953280 bytes, checkpoint LSN: 199802707456 2018-05-22T20:20:38.336646Z 0 [Warning] [MY-013060] [InnoDB] InnoDB: Log writer is waiting for checkpointer to to catch up lag: 3865953280 bytes, checkpoint LSN: 199802707456 2018-05-22T20:20:38.436760Z 0 [Warning] [MY-013060] [InnoDB] InnoDB: Log writer is waiting for checkpointer to to catch up lag: 3865953280 bytes, checkpoint LSN: 199802707456 2018-05-22T20:20:38.536870Z 0 [Warning] [MY-013060] [InnoDB] InnoDB: Log writer is waiting for checkpointer to to catch up lag: 3865953280 bytes, checkpoint LSN: 199802707456 2018-05-22T20:20:38.636976Z 0 [Warning] [MY-013060] [InnoDB] InnoDB: Log writer is waiting for checkpointer to to catch up lag: 3865953280 bytes, checkpoint LSN: 199802707456 2018-05-22T20:20:38.737083Z 0 [ERROR] [MY-013059] [InnoDB] InnoDB: Log writer overwriting data after checkpoint - waited too long (1 second), lag: 3865953280 bytes, checkpoint LSN: 199802707456 2018-05-22T20:20:38.737122Z 0 [Warning] [MY-013060] [InnoDB] InnoDB: Log writer is waiting for checkpointer to to catch up lag: 3865953792 bytes, checkpoint LSN: 199802707456 Ibuf: size 362097, free list len 182064, seg size 544162, 2890601 merges merged operations: insert 95453439, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 9296893, node heap has 120 buffer(s) Hash table size 9296893, node heap has 216 buffer(s) Hash table size 9296893, node heap has 107 buffer(s) Hash table size 9296893, node heap has 110 buffer(s) Hash table size 9296893, node heap has 227 buffer(s) Hash table size 9296893, node heap has 103 buffer(s) Hash table size 9296893, node heap has 116 buffer(s) Hash table size 9296893, node heap has 147 buffer(s) 0.00 hash searches/s, 0.80 non-hash searches/s --- LOG --- Log sequence number 203669713527 Log buffer assigned up to 203669713527 Log buffer completed up to 203668664766 Log written up to 203668660736 Log flushed up to 203668660224 Added dirty pages up to 203669711381 Pages flushed up to 200069626230 Last checkpoint at 199802707735 548507707 log i/o's done, 1.05 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 38480117760 Dictionary memory allocated 926751 Buffer pool size 2293746 Free buffers 15458 Database pages 2277142 Old database pages 840504 Modified db pages 2035218 Pending reads 78 Pending writes: LRU 0, flush list 6, single page 0 Pages made young 320397941, not young 7706343 0.00 youngs/s, 0.00 non-youngs/s Pages read 3779175, created 7256337, written 93456020 0.14 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 972 / 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: 2277142, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 573437 Free buffers 3898 Database pages 569252 Old database pages 210114 Modified db pages 509180 Pending reads 25 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 79655128, not young 2024328 0.00 youngs/s, 0.00 non-youngs/s Pages read 957717, created 1811460, written 23326635 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 569252, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 573437 Free buffers 3712 Database pages 569443 Old database pages 210184 Modified db pages 509895 Pending reads 30 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 81469729, not young 2194662 0.00 youngs/s, 0.00 non-youngs/s Pages read 972210, created 1820041, written 23486671 0.14 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 834 / 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: 569443, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 573436 Free buffers 3886 Database pages 569262 Old database pages 210117 Modified db pages 505236 Pending reads 14 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 80008520, not young 1785859 0.00 youngs/s, 0.00 non-youngs/s Pages read 938459, created 1809279, written 23363936 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 569262, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 573436 Free buffers 3962 Database pages 569185 Old database pages 210089 Modified db pages 510907 Pending reads 9 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 79264564, not young 1701494 0.00 youngs/s, 0.00 non-youngs/s Pages read 910789, created 1815557, written 23278778 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 569185, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=1110101, Main thread ID=140180681570048 , state=doing insert buffer merge Number of rows inserted 601238926, updated 961, deleted 835, read 8649 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================