Advertisement
roozgar

SHOW ENGINE INNODB STATUS;

Jun 15th, 2019
201
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 26.08 KB | None | 0 0
  1. Type Name Status
  2. InnoDB \n=====================================\n2019-06-15 11:13:01 1660 INNODB MONITOR OUTPUT\n=====================================\nPer second averages calculated from the last 26 seconds\n-----------------\nBACKGROUND THREAD\n-----------------\nsrv_master_thread loops: 63047 srv_active, 0 srv_shutdown, 169852 srv_idle\nsrv_master_thread log flush and writes: 232789\n----------\nSEMAPHORES\n----------\nOS WAIT ARRAY INFO: reservation count 901650\nOS WAIT ARRAY INFO: signal count 842886\nMutex spin waits 2082468, rounds 22480520, OS waits 714337\nRW-shared spins 108567, rounds 2185094, OS waits 64727\nRW-excl spins 828792, rounds 7135494, OS waits 118368\nSpin rounds per wait: 10.80 mutex, 20.13 RW-shared, 8.61 RW-excl\n------------\nTRANSACTIONS\n------------\nTrx id counter 15136116\nPurge done for trx's n:o < 15136114 undo n:o < 0 state: running but idle\nHistory list length 13\nLIST OF TRANSACTIONS FOR EACH SESSION:\n---TRANSACTION 0, not started\nMySQL thread id 1684985, OS thread handle 0x1660, query id 8105247 localhost ::1 root init\nSHOW ENGINE INNODB STATUS\n---TRANSACTION 11983363, not started\nMySQL thread id 1, OS thread handle 0x870, query id 0 Reading from net\n--------\nFILE I/O\n--------\nI/O thread 0 state: native aio handle (insert buffer thread)\nI/O thread 1 state: native aio handle (log thread)\nI/O thread 2 state: native aio handle (read thread)\nI/O thread 3 state: native aio handle (read thread)\nI/O thread 4 state: native aio handle (read thread)\nI/O thread 5 state: native aio handle (read thread)\nI/O thread 6 state: native aio handle (read thread)\nI/O thread 7 state: native aio handle (read thread)\nI/O thread 8 state: native aio handle (read thread)\nI/O thread 9 state: native aio handle (read thread)\nI/O thread 10 state: native aio handle (read thread)\nI/O thread 11 state: native aio handle (read thread)\nI/O thread 12 state: native aio handle (read thread)\nI/O thread 13 state: native aio handle (read thread)\nI/O thread 14 state: native aio handle (read thread)\nI/O thread 15 state: native aio handle (read thread)\nI/O thread 16 state: native aio handle (read thread)\nI/O thread 17 state: native aio handle (read thread)\nI/O thread 18 state: native aio handle (read thread)\nI/O thread 19 state: native aio handle (read thread)\nI/O thread 20 state: native aio handle (read thread)\nI/O thread 21 state: native aio handle (read thread)\nI/O thread 22 state: native aio handle (read thread)\nI/O thread 23 state: native aio handle (read thread)\nI/O thread 24 state: native aio handle (read thread)\nI/O thread 25 state: native aio handle (read thread)\nI/O thread 26 state: native aio handle (read thread)\nI/O thread 27 state: native aio handle (read thread)\nI/O thread 28 state: native aio handle (read thread)\nI/O thread 29 state: native aio handle (read thread)\nI/O thread 30 state: native aio handle (read thread)\nI/O thread 31 state: native aio handle (read thread)\nI/O thread 32 state: native aio handle (read thread)\nI/O thread 33 state: native aio handle (read thread)\nI/O thread 34 state: native aio handle (read thread)\nI/O thread 35 state: native aio handle (read thread)\nI/O thread 36 state: native aio handle (read thread)\nI/O thread 37 state: native aio handle (read thread)\nI/O thread 38 state: native aio handle (read thread)\nI/O thread 39 state: native aio handle (read thread)\nI/O thread 40 state: native aio handle (read thread)\nI/O thread 41 state: native aio handle (read thread)\nI/O thread 42 state: native aio handle (read thread)\nI/O thread 43 state: native aio handle (read thread)\nI/O thread 44 state: native aio handle (read thread)\nI/O thread 45 state: native aio handle (read thread)\nI/O thread 46 state: native aio handle (read thread)\nI/O thread 47 state: native aio handle (read thread)\nI/O thread 48 state: native aio handle (read thread)\nI/O thread 49 state: native aio handle (read thread)\nI/O thread 50 state: native aio handle (read thread)\nI/O thread 51 state: native aio handle (read thread)\nI/O thread 52 state: native aio handle (read thread)\nI/O thread 53 state: native aio handle (read thread)\nI/O thread 54 state: native aio handle (read thread)\nI/O thread 55 state: native aio handle (read thread)\nI/O thread 56 state: native aio handle (read thread)\nI/O thread 57 state: native aio handle (read thread)\nI/O thread 58 state: native aio handle (read thread)\nI/O thread 59 state: native aio handle (read thread)\nI/O thread 60 state: native aio handle (read thread)\nI/O thread 61 state: native aio handle (read thread)\nI/O thread 62 state: native aio handle (read thread)\nI/O thread 63 state: native aio handle (read thread)\nI/O thread 64 state: native aio handle (read thread)\nI/O thread 65 state: native aio handle (read thread)\nI/O thread 66 state: native aio handle (write thread)\nI/O thread 67 state: native aio handle (write thread)\nI/O thread 68 state: native aio handle (write thread)\nI/O thread 69 state: native aio handle (write thread)\nI/O thread 70 state: native aio handle (write thread)\nI/O thread 71 state: native aio handle (write thread)\nI/O thread 72 state: native aio handle (write thread)\nI/O thread 73 state: native aio handle (write thread)\nI/O thread 74 state: native aio handle (write thread)\nI/O thread 75 state: native aio handle (write thread)\nI/O thread 76 state: native aio handle (write thread)\nI/O thread 77 state: native aio handle (write thread)\nI/O thread 78 state: native aio handle (write thread)\nI/O thread 79 state: native aio handle (write thread)\nI/O thread 80 state: native aio handle (write thread)\nI/O thread 81 state: native aio handle (write thread)\nI/O thread 82 state: native aio handle (write thread)\nI/O thread 83 state: native aio handle (write thread)\nI/O thread 84 state: native aio handle (write thread)\nI/O thread 85 state: native aio handle (write thread)\nI/O thread 86 state: native aio handle (write thread)\nI/O thread 87 state: native aio handle (write thread)\nI/O thread 88 state: native aio handle (write thread)\nI/O thread 89 state: native aio handle (write thread)\nI/O thread 90 state: native aio handle (write thread)\nI/O thread 91 state: native aio handle (write thread)\nI/O thread 92 state: native aio handle (write thread)\nI/O thread 93 state: native aio handle (write thread)\nI/O thread 94 state: native aio handle (write thread)\nI/O thread 95 state: native aio handle (write thread)\nI/O thread 96 state: native aio handle (write thread)\nI/O thread 97 state: native aio handle (write thread)\nI/O thread 98 state: native aio handle (write thread)\nI/O thread 99 state: native aio handle (write thread)\nI/O thread 100 state: native aio handle (write thread)\nI/O thread 101 state: native aio handle (write thread)\nI/O thread 102 state: native aio handle (write thread)\nI/O thread 103 state: native aio handle (write thread)\nI/O thread 104 state: native aio handle (write thread)\nI/O thread 105 state: native aio handle (write thread)\nI/O thread 106 state: native aio handle (write thread)\nI/O thread 107 state: native aio handle (write thread)\nI/O thread 108 state: native aio handle (write thread)\nI/O thread 109 state: native aio handle (write thread)\nI/O thread 110 state: native aio handle (write thread)\nI/O thread 111 state: native aio handle (write thread)\nI/O thread 112 state: native aio handle (write thread)\nI/O thread 113 state: native aio handle (write thread)\nI/O thread 114 state: native aio handle (write thread)\nI/O thread 115 state: native aio handle (write thread)\nI/O thread 116 state: native aio handle (write thread)\nI/O thread 117 state: native aio handle (write thread)\nI/O thread 118 state: native aio handle (write thread)\nI/O thread 119 state: native aio handle (write thread)\nI/O thread 120 state: native aio handle (write thread)\nI/O thread 121 state: native aio handle (write thread)\nI/O thread 122 state: native aio handle (write thread)\nI/O thread 123 state: native aio handle (write thread)\nI/O thread 124 state: native aio handle (write thread)\nI/O thread 125 state: native aio handle (write thread)\nI/O thread 126 state: native aio handle (write thread)\nI/O thread 127 state: native aio handle (write thread)\nI/O thread 128 state: native aio handle (write thread)\nI/O thread 129 state: native aio handle (write thread)\nPending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] ,\n ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0\nPending flushes (fsync) log: 0; buffer pool: 0\n9153 OS file reads, 2448150 OS file writes, 1258003 OS fsyncs\n0.00 reads/s, 0 avg bytes/read, 55.07 writes/s, 38.23 fsyncs/s\n-------------------------------------\nINSERT BUFFER AND ADAPTIVE HASH INDEX\n-------------------------------------\nIbuf: size 1, free list len 72, seg size 74, 1592 merges\nmerged operations:\n insert 3841, delete mark 0, delete 0\ndiscarded operations:\n insert 0, delete mark 0, delete 0\n3713.51 hash searches/s, 1695.40 non-hash searches/s\n---\nLOG\n---\nLog sequence number 9528038488\nLog flushed up to 9528038471\nPages flushed up to 9517107028\nLast checkpoint at 9517095596\nMax checkpoint age 80826164\nCheckpoint age target 78300347\nModified age 10931460\nCheckpoint age 10942892\n0 pending log writes, 0 pending chkp writes\n1066146 log i/o's done, 35.27 log i/o's/second\n----------------------\nBUFFER POOL AND MEMORY\n----------------------\nTotal memory allocated 22366126080; in additional pool allocated 0\nTotal memory allocated by read views 9170088\nInternal hash tables (constant factor + variable factor)\n Adaptive hash index 342896032 \t(339991864 + 140694541586536)\n Page hash 1107208 (buffer pool 0 only)\n Dictionary cache 85169968 \t(84999472 + 170496)\n File system 868920 \t(812272 + 56648)\n Lock system 53125976 \t(53125256 + 720)\n Recovery system 0 \t(0 + 0)\nDictionary memory allocated 170496\nBuffer pool size 1310700\nBuffer pool size, bytes 21474508800\nFree buffers 1117108\nDatabase pages 193415\nOld database pages 70988\nModified db pages 1678\nPercent of dirty pages(LRU & free pages): 0.128\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1695, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 8881, created 184534, written 1305101\n0.00 reads/s, 5.38 creates/s, 18.85 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 193415, unzip_LRU len: 0\nI/O sum[0]:cur[480], unzip sum[0]:cur[0]\n----------------------\nINDIVIDUAL BUFFER POOL INFO\n----------------------\n---BUFFER POOL 0\nBuffer pool size 65535\nBuffer pool size, bytes 1073725440\nFree buffers 55408\nDatabase pages 10116\nOld database pages 3714\nModified db pages 22\nPercent of dirty pages(LRU & free pages): 0.034\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 75, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 448, created 9668, written 101730\n0.00 reads/s, 0.00 creates/s, 0.00 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 10116, unzip_LRU len: 0\nI/O sum[0]:cur[24], unzip sum[0]:cur[0]\n---BUFFER POOL 1\nBuffer pool size 65535\nBuffer pool size, bytes 1073725440\nFree buffers 56183\nDatabase pages 9343\nOld database pages 3428\nModified db pages 72\nPercent of dirty pages(LRU & free pages): 0.110\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 80, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 346, created 8997, written 59985\n0.00 reads/s, 0.00 creates/s, 1.50 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 9343, unzip_LRU len: 0\nI/O sum[0]:cur[24], unzip sum[0]:cur[0]\n---BUFFER POOL 2\nBuffer pool size 65535\nBuffer pool size, bytes 1073725440\nFree buffers 55888\nDatabase pages 9637\nOld database pages 3537\nModified db pages 54\nPercent of dirty pages(LRU & free pages): 0.082\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 48, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 588, created 9049, written 49049\n0.00 reads/s, 1.38 creates/s, 0.00 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 9637, unzip_LRU len: 0\nI/O sum[0]:cur[24], unzip sum[0]:cur[0]\n---BUFFER POOL 3\nBuffer pool size 65535\nBuffer pool size, bytes 1073725440\nFree buffers 56012\nDatabase pages 9515\nOld database pages 3492\nModified db pages 62\nPercent of dirty pages(LRU & free pages): 0.095\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 125, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 392, created 9123, written 101330\n0.00 reads/s, 0.00 creates/s, 0.96 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 9515, unzip_LRU len: 0\nI/O sum[0]:cur[24], unzip sum[0]:cur[0]\n---BUFFER POOL 4\nBuffer pool size 65535\nBuffer pool size, bytes 1073725440\nFree buffers 55561\nDatabase pages 9966\nOld database pages 3658\nModified db pages 158\nPercent of dirty pages(LRU & free pages): 0.241\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 43, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 386, created 9580, written 91649\n0.00 reads/s, 0.00 creates/s, 2.04 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 9966, unzip_LRU len: 0\nI/O sum[0]:cur[24], unzip sum[0]:cur[0]\n---BUFFER POOL 5\nBuffer pool size 65535\nBuffer pool size, bytes 1073725440\nFree buffers 55614\nDatabase pages 9913\nOld database pages 3639\nModified db pages 138\nPercent of dirty pages(LRU & free pages): 0.211\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 15, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 274, created 9639, written 73164\n0.00 reads/s, 1.15 creates/s, 1.69 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 9913, unzip_LRU len: 0\nI/O sum[0]:cur[24], unzip sum[0]:cur[0]\n---BUFFER POOL 6\nBuffer pool size 65535\nBuffer pool size, bytes 1073725440\nFree buffers 55453\nDatabase pages 10074\nOld database pages 3698\nModified db pages 47\nPercent of dirty pages(LRU & free pages): 0.072\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 117, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 685, created 9389, written 86273\n0.00 reads/s, 0.00 creates/s, 0.73 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 10074, unzip_LRU len: 0\nI/O sum[0]:cur[24], unzip sum[0]:cur[0]\n---BUFFER POOL 7\nBuffer pool size 65535\nBuffer pool size, bytes 1073725440\nFree buffers 55729\nDatabase pages 9798\nOld database pages 3596\nModified db pages 172\nPercent of dirty pages(LRU & free pages): 0.262\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 216, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 534, created 9264, written 81147\n0.00 reads/s, 0.19 creates/s, 1.58 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 9798, unzip_LRU len: 0\nI/O sum[0]:cur[24], unzip sum[0]:cur[0]\n---BUFFER POOL 8\nBuffer pool size 65535\nBuffer pool size, bytes 1073725440\nFree buffers 55773\nDatabase pages 9752\nOld database pages 3579\nModified db pages 102\nPercent of dirty pages(LRU & free pages): 0.156\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 44, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 284, created 9468, written 83167\n0.00 reads/s, 0.00 creates/s, 1.04 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 9752, unzip_LRU len: 0\nI/O sum[0]:cur[24], unzip sum[0]:cur[0]\n---BUFFER POOL 9\nBuffer pool size 65535\nBuffer pool size, bytes 1073725440\nFree buffers 55600\nDatabase pages 9926\nOld database pages 3644\nModified db pages 176\nPercent of dirty pages(LRU & free pages): 0.269\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 142, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 539, created 9387, written 49584\n0.00 reads/s, 0.00 creates/s, 2.08 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 9926, unzip_LRU len: 0\nI/O sum[0]:cur[24], unzip sum[0]:cur[0]\n---BUFFER POOL 10\nBuffer pool size 65535\nBuffer pool size, bytes 1073725440\nFree buffers 55565\nDatabase pages 9960\nOld database pages 3656\nModified db pages 39\nPercent of dirty pages(LRU & free pages): 0.060\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 92, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 573, created 9387, written 45137\n0.00 reads/s, 0.12 creates/s, 0.00 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 9960, unzip_LRU len: 0\nI/O sum[0]:cur[24], unzip sum[0]:cur[0]\n---BUFFER POOL 11\nBuffer pool size 65535\nBuffer pool size, bytes 1073725440\nFree buffers 55911\nDatabase pages 9612\nOld database pages 3528\nModified db pages 94\nPercent of dirty pages(LRU & free pages): 0.143\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 64, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 425, created 9187, written 71798\n0.00 reads/s, 0.12 creates/s, 2.12 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 9612, unzip_LRU len: 0\nI/O sum[0]:cur[24], unzip sum[0]:cur[0]\n---BUFFER POOL 12\nBuffer pool size 65535\nBuffer pool size, bytes 1073725440\nFree buffers 56359\nDatabase pages 9169\nOld database pages 3364\nModified db pages 78\nPercent of dirty pages(LRU & free pages): 0.119\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 117, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 406, created 8763, written 90034\n0.00 reads/s, 0.04 creates/s, 1.23 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 9169, unzip_LRU len: 0\nI/O sum[0]:cur[24], unzip sum[0]:cur[0]\n---BUFFER POOL 13\nBuffer pool size 65535\nBuffer pool size, bytes 1073725440\nFree buffers 56123\nDatabase pages 9404\nOld database pages 3451\nModified db pages 62\nPercent of dirty pages(LRU & free pages): 0.095\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 51, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 425, created 8979, written 48124\n0.00 reads/s, 0.00 creates/s, 0.23 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 9404, unzip_LRU len: 0\nI/O sum[0]:cur[24], unzip sum[0]:cur[0]\n---BUFFER POOL 14\nBuffer pool size 65535\nBuffer pool size, bytes 1073725440\nFree buffers 56307\nDatabase pages 9219\nOld database pages 3383\nModified db pages 96\nPercent of dirty pages(LRU & free pages): 0.147\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 88, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 164, created 9055, written 59076\n0.00 reads/s, 0.00 creates/s, 0.19 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 9219, unzip_LRU len: 0\nI/O sum[0]:cur[24], unzip sum[0]:cur[0]\n---BUFFER POOL 15\nBuffer pool size 65535\nBuffer pool size, bytes 1073725440\nFree buffers 56324\nDatabase pages 9204\nOld database pages 3377\nModified db pages 87\nPercent of dirty pages(LRU & free pages): 0.133\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 35, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 578, created 8626, written 39485\n0.00 reads/s, 0.00 creates/s, 1.46 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 9204, unzip_LRU len: 0\nI/O sum[0]:cur[24], unzip sum[0]:cur[0]\n---BUFFER POOL 16\nBuffer pool size 65535\nBuffer pool size, bytes 1073725440\nFree buffers 55738\nDatabase pages 9789\nOld database pages 3593\nModified db pages 12\nPercent of dirty pages(LRU & free pages): 0.018\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 24, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 517, created 9272, written 30442\n0.00 reads/s, 0.00 creates/s, 0.00 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 9789, unzip_LRU len: 0\nI/O sum[0]:cur[24], unzip sum[0]:cur[0]\n---BUFFER POOL 17\nBuffer pool size 65535\nBuffer pool size, bytes 1073725440\nFree buffers 56290\nDatabase pages 9235\nOld database pages 3389\nModified db pages 100\nPercent of dirty pages(LRU & free pages): 0.153\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 78, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 368, created 8867, written 50016\n0.00 reads/s, 2.31 creates/s, 0.00 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 9235, unzip_LRU len: 0\nI/O sum[0]:cur[24], unzip sum[0]:cur[0]\n---BUFFER POOL 18\nBuffer pool size 65535\nBuffer pool size, bytes 1073725440\nFree buffers 55764\nDatabase pages 9762\nOld database pages 3583\nModified db pages 39\nPercent of dirty pages(LRU & free pages): 0.060\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 90, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 578, created 9184, written 44190\n0.00 reads/s, 0.00 creates/s, 1.00 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 9762, unzip_LRU len: 0\nI/O sum[0]:cur[24], unzip sum[0]:cur[0]\n---BUFFER POOL 19\nBuffer pool size 65535\nBuffer pool size, bytes 1073725440\nFree buffers 55506\nDatabase pages 10021\nOld database pages 3679\nModified db pages 68\nPercent of dirty pages(LRU & free pages): 0.104\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 151, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 371, created 9650, written 49721\n0.00 reads/s, 0.08 creates/s, 1.00 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 10021, unzip_LRU len: 0\nI/O sum[0]:cur[24], unzip sum[0]:cur[0]\n--------------\nROW OPERATIONS\n--------------\n0 queries inside InnoDB, 0 queries in queue\n0 read views open inside InnoDB\n0 RW transactions active inside InnoDB\n0 RO transactions active inside InnoDB\n0 out of 1000 descriptors used\nMain thread id 6068, state: sleeping\nNumber of rows inserted 24127278, updated 223296, deleted 30850, read 1204286613\n794.93 inserts/s, 7.23 updates/s, 0.00 deletes/s, 29064.81 reads/s\nNumber of system rows inserted 0, updated 0, deleted 0, read 0\n0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s\n----------------------------\nEND OF INNODB MONITOR OUTPUT\n============================\n
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement