*************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2014-09-18 08:00:47 7ff5e0ff9700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 29 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 617213 srv_active, 0 srv_shutdown, 130389 srv_idle srv_master_thread log flush and writes: 747506 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 14064468 OS WAIT ARRAY INFO: signal count 14088855 Mutex spin waits 13340210, rounds 333556873, OS waits 10978925 RW-shared spins 2997974, rounds 85574510, OS waits 2790450 RW-excl spins 348058, rounds 10227449, OS waits 236582 Spin rounds per wait: 25.00 mutex, 28.54 RW-shared, 29.38 RW-excl ------------ TRANSACTIONS ------------ Trx id counter 9963127579 Purge done for trx's n:o < 9963127579 undo n:o < 0 state: running but idle History list length 2763 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 131465, OS thread handle 0x7ff5e0ff9700, query id 42061424 localhost root init SHOW ENGINE INNODB STATUS ---TRANSACTION 9963127577, not started MySQL thread id 32, OS thread handle 0x7ff5e80c6700, query id 42061350 Slave has read all relay log; waiting for the slave I/O thread to update it -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 13859872 OS file reads, 40886931 OS file writes, 2476450 OS fsyncs 0.07 reads/s, 16384 avg bytes/read, 159.44 writes/s, 10.72 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 636, seg size 638, 127799 merges merged operations: insert 112130, delete mark 465751, delete 147088 discarded operations: insert 0, delete mark 0, delete 0 152.99 hash searches/s, 1051.24 non-hash searches/s --- LOG --- Log sequence number 1868483845041 Log flushed up to 1868483811774 Pages flushed up to 1868413113833 Last checkpoint at 1868412939682 Max checkpoint age 634409719 Checkpoint age target 614584416 Modified age 70731208 Checkpoint age 70905359 0 pending log writes, 0 pending chkp writes 21023612 log i/o's done, 146.10 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 30769414144; in additional pool allocated 0 Total memory allocated by read views 200 Internal hash tables (constant factor + variable factor) Adaptive hash index 715450224 (475993864 + 239456360) Page hash 3719512 (buffer pool 0 only) Dictionary cache 119372192 (118999856 + 372336) File system 826408 (812272 + 14136) Lock system 74375864 (74375144 + 720) Recovery system 0 (0 + 0) Dictionary memory allocated 372336 Buffer pool size 1835000 Buffer pool size, bytes 30064640000 Free buffers 8193 Database pages 1812192 Old database pages 668791 Modified db pages 5290 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2328310, not young 1890548596 0.17 youngs/s, 0.21 non-youngs/s Pages read 13080076, created 6230021, written 18344458 0.07 reads/s, 1.48 creates/s, 9.83 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: 1812192, unzip_LRU len: 0 I/O sum[3440]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 229375 Buffer pool size, bytes 3758080000 Free buffers 1024 Database pages 226529 Old database pages 83601 Modified db pages 690 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 292146, not young 238372559 0.00 youngs/s, 0.00 non-youngs/s Pages read 1635758, created 780911, written 2984067 0.00 reads/s, 0.00 creates/s, 1.79 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: 226529, unzip_LRU len: 0 I/O sum[430]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 229375 Buffer pool size, bytes 3758080000 Free buffers 1024 Database pages 226510 Old database pages 83594 Modified db pages 737 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 305935, not young 225290878 0.00 youngs/s, 0.00 non-youngs/s Pages read 1610693, created 774057, written 2113594 0.00 reads/s, 0.14 creates/s, 1.17 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: 226510, unzip_LRU len: 0 I/O sum[430]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 229375 Buffer pool size, bytes 3758080000 Free buffers 1024 Database pages 226505 Old database pages 83592 Modified db pages 637 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 288566, not young 238835047 0.07 youngs/s, 0.00 non-youngs/s Pages read 1643961, created 779420, written 1777124 0.00 reads/s, 0.17 creates/s, 1.03 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: 226505, unzip_LRU len: 0 I/O sum[430]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 229375 Buffer pool size, bytes 3758080000 Free buffers 1024 Database pages 226558 Old database pages 83611 Modified db pages 704 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 293617, not young 238774540 0.00 youngs/s, 0.00 non-youngs/s Pages read 1647650, created 781880, written 1967920 0.00 reads/s, 0.10 creates/s, 1.55 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: 226558, unzip_LRU len: 0 I/O sum[430]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 229375 Buffer pool size, bytes 3758080000 Free buffers 1024 Database pages 226551 Old database pages 83609 Modified db pages 674 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 288164, not young 238440667 0.03 youngs/s, 0.00 non-youngs/s Pages read 1641162, created 781420, written 2407961 0.00 reads/s, 0.17 creates/s, 1.03 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: 226551, unzip_LRU len: 0 I/O sum[430]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 229375 Buffer pool size, bytes 3758080000 Free buffers 1024 Database pages 226514 Old database pages 83595 Modified db pages 600 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 283441, not young 235218652 0.03 youngs/s, 0.00 non-youngs/s Pages read 1631190, created 775210, written 2777240 0.00 reads/s, 0.34 creates/s, 0.90 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: 226514, unzip_LRU len: 0 I/O sum[430]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 229375 Buffer pool size, bytes 3758080000 Free buffers 1024 Database pages 226523 Old database pages 83598 Modified db pages 639 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 291511, not young 236851302 0.00 youngs/s, 0.00 non-youngs/s Pages read 1631183, created 776929, written 2232442 0.00 reads/s, 0.48 creates/s, 1.31 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: 226523, unzip_LRU len: 0 I/O sum[430]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 229375 Buffer pool size, bytes 3758080000 Free buffers 1025 Database pages 226502 Old database pages 83591 Modified db pages 609 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 284930, not young 238764951 0.03 youngs/s, 0.21 non-youngs/s Pages read 1638479, created 780194, written 2084110 0.07 reads/s, 0.07 creates/s, 1.03 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: 226502, unzip_LRU len: 0 I/O sum[430]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB 0 RW transactions active inside InnoDB 0 RO transactions active inside InnoDB 0 out of 1000 descriptors used Main thread process no. 14579, id 140694145767168, state: sleeping Number of rows inserted 421002245, updated 13712152, deleted 7646183, read 2574442266 215.41 inserts/s, 97.76 updates/s, 1.24 deletes/s, 99.34 reads/s ------------ TRANSACTIONS ------------ Trx id counter 9963127579 Purge done for trx's n:o < 9963127579 undo n:o < 0 state: running but idle History list length 2763 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 131465, OS thread handle 0x7ff5e0ff9700, query id 42061424 localhost root init SHOW ENGINE INNODB STATUS ---TRANSACTION 9963127577, not started MySQL thread id 32, OS thread handle 0x7ff5e80c6700, query id 42061350 Slave has read all relay log; waiting for the slave I/O thread to update it ---------------------------- END OF INNODB MONITOR OUTPUT ============================