===================================== 2016-01-03 01:14:52 0x7f2b0cff9700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 2 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 4156 srv_active, 0 srv_shutdown, 37348 srv_idle srv_master_thread log flush and writes: 41504 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 61460 --Thread 139822877865728 has waited at buf0buf.cc line 4072 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x7f2c919a8e20 created in file buf0buf.cc line 1379 a writer (thread id 139822877865728) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file /export/home2/pb2/build/sb_0-17208442-1448825676.4/rpm/BUILD/mysql-5.7.10/mysql-5.7.10/storage/innobase/buf/buf0buf.cc line 5242 OS WAIT ARRAY INFO: signal count 86405 RW-shared spins 0, rounds 143363, OS waits 32188 RW-excl spins 0, rounds 459150, OS waits 11191 RW-sx spins 31614, rounds 618272, OS waits 12167 Spin rounds per wait: 143363.00 RW-shared, 459150.00 RW-excl, 19.56 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 7675144 Purge done for trx's n:o < 7675096 undo n:o < 0 state: running but idle History list length 720 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421307348247040, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421307348245216, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421307348244304, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 7675142, ACTIVE 11 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 27610, OS thread handle 139822996358912, query id 4598798 144.76.64.139 pkgs update INSERT INTO packages_filename_bin(value) VALUES ("brltty-5.3.1-1-i686.pkg.tar.xz") Trx read view will not see trx with id >= 7675142, sees < 7675093 ------- TRX HAS BEEN WAITING 10 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 340 page no 5567 n bits 344 index PRIMARY of table `pkgs`.`packages_filename_bin` trx id 7675142 lock_mode X insert intention waiting Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; hex 73757072656d756d; asc supremum;; ------------------ ---TRANSACTION 7675093, ACTIVE 415 sec rollback ROLLING BACK 9894 lock struct(s), heap size 1548496, 1361523 row lock(s), undo log entries 550013 MySQL thread id 27399, OS thread handle 139822877865728, query id 4598209 144.76.64.139 pkgs cleaning up Trx read view will not see trx with id >= 7675093, sees < 7675093 -------- 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, 1] , aio writes: [0, 0, 1, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 0 150937 OS file reads, 266301 OS file writes, 35660 OS fsyncs 57.47 reads/s, 16384 avg bytes/read, 140.43 writes/s, 1.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 39027, seg size 39029, 68773 merges merged operations: insert 724920, delete mark 1418160, delete 289931 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 2365241, node heap has 27 buffer(s) Hash table size 2365241, node heap has 397 buffer(s) Hash table size 2365241, node heap has 1842 buffer(s) Hash table size 2365241, node heap has 4700 buffer(s) Hash table size 2365241, node heap has 671 buffer(s) Hash table size 2365241, node heap has 806 buffer(s) Hash table size 2365241, node heap has 372 buffer(s) Hash table size 2365241, node heap has 1158 buffer(s) 858.57 hash searches/s, 1262.37 non-hash searches/s --- LOG --- Log sequence number 232835124630 Log flushed up to 232835061676 Pages flushed up to 232637913033 Last checkpoint at 232636394830 0 pending log flushes, 0 pending chkp writes 11000 log i/o's done, 1.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 8795455488 Dictionary memory allocated 2201662 Buffer pool size 524224 Free buffers 345775 Database pages 168382 Old database pages 62312 Modified db pages 65100 Pending reads 1 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 3090, not young 0 0.50 youngs/s, 0.00 non-youngs/s Pages read 150848, created 17533, written 255219 57.47 reads/s, 0.00 creates/s, 140.43 writes/s Buffer pool hit rate 994 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 168382, unzip_LRU len: 0 I/O sum[0]:cur[672], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 65528 Free buffers 44140 Database pages 20109 Old database pages 7443 Modified db pages 7737 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 342, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 17884, created 2225, written 28311 5.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 993 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 20109, unzip_LRU len: 0 I/O sum[0]:cur[84], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 65528 Free buffers 42408 Database pages 21893 Old database pages 8101 Modified db pages 8750 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 425, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 19802, created 2091, written 33706 8.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 986 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 21893, unzip_LRU len: 0 I/O sum[0]:cur[84], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 65528 Free buffers 43734 Database pages 20533 Old database pages 7599 Modified db pages 7767 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 352, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 18425, created 2107, written 31033 8.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 976 / 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: 20533, unzip_LRU len: 0 I/O sum[0]:cur[84], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 65528 Free buffers 42593 Database pages 21669 Old database pages 8018 Modified db pages 8666 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 374, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 19359, created 2310, written 30905 6.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 999 / 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: 21669, unzip_LRU len: 0 I/O sum[0]:cur[84], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 65528 Free buffers 42512 Database pages 21723 Old database pages 8038 Modified db pages 7959 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 436, not young 0 0.50 youngs/s, 0.00 non-youngs/s Pages read 19285, created 2438, written 32343 5.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 995 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 21723, unzip_LRU len: 0 I/O sum[0]:cur[84], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 65528 Free buffers 44163 Database pages 20118 Old database pages 7446 Modified db pages 7826 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 360, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 17968, created 2150, written 31515 8.00 reads/s, 0.00 creates/s, 102.45 writes/s Buffer pool hit rate 968 / 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: 20118, unzip_LRU len: 0 I/O sum[0]:cur[84], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 65528 Free buffers 42788 Database pages 21498 Old database pages 7955 Modified db pages 8058 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 389, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 19423, created 2075, written 38066 8.50 reads/s, 0.00 creates/s, 17.49 writes/s Buffer pool hit rate 994 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 21498, unzip_LRU len: 0 I/O sum[0]:cur[84], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 65528 Free buffers 43437 Database pages 20839 Old database pages 7712 Modified db pages 8337 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 412, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 18702, created 2137, written 29340 9.00 reads/s, 0.00 creates/s, 20.49 writes/s Buffer pool hit rate 994 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 20839, unzip_LRU len: 0 I/O sum[0]:cur[84], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Process ID=30531, Main thread ID=139823005017856, state: sleeping Number of rows inserted 2671024, updated 2215, deleted 1172634, read 164897001 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 39.98 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================