Created
February 10, 2015 16:14
-
-
Save janewang/9ae8e8da3875c4f267e0 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ===================================== | |
| 2015-02-10 16:14:20 2ad28e0c6700 INNODB MONITOR OUTPUT | |
| ===================================== | |
| Per second averages calculated from the last 37 seconds | |
| ----------------- | |
| BACKGROUND THREAD | |
| ----------------- | |
| srv_master_thread loops: 121769 srv_active, 0 srv_shutdown, 450748 srv_idle | |
| srv_master_thread log flush and writes: 572511 | |
| ---------- | |
| SEMAPHORES | |
| ---------- | |
| OS WAIT ARRAY INFO: reservation count 295989 | |
| OS WAIT ARRAY INFO: signal count 415150 | |
| Mutex spin waits 436643, rounds 807314, OS waits 14538 | |
| RW-shared spins 298749, rounds 8061025, OS waits 265223 | |
| RW-excl spins 6860, rounds 657558, OS waits 14861 | |
| Spin rounds per wait: 1.85 mutex, 26.98 RW-shared, 95.85 RW-excl | |
| ------------------------ | |
| LATEST DETECTED DEADLOCK | |
| ------------------------ | |
| 2015-02-10 16:11:51 2ad28e69d700 | |
| *** (1) TRANSACTION: | |
| TRANSACTION 464659454, ACTIVE 2 sec inserting | |
| mysql tables in use 1, locked 1 | |
| LOCK WAIT 4 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1 | |
| MySQL thread id 1238491, OS thread handle 0x2ad28eaee700, query id 109533215 10.0.101.170 admin update | |
| INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_is_multi_author', '0', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`) | |
| *** (1) WAITING FOR THIS LOCK TO BE GRANTED: | |
| RECORD LOCKS space id 47 page no 1697 n bits 344 index `option_name` of table `ebdb`.`wp_options` trx id 464659454 lock_mode X locks gap before rec insert intention waiting | |
| Record lock, heap no 212 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 | |
| 0: len 29; hex 5f7472616e7369656e745f6a65747061636b5f68747470735f74657374; asc _transient_jetpack_https_test;; | |
| 1: len 8; hex 000000000074facb; asc t ;; | |
| *** (2) TRANSACTION: | |
| TRANSACTION 464660063, ACTIVE 1 sec inserting | |
| mysql tables in use 1, locked 1 | |
| 4 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1 | |
| MySQL thread id 1238516, OS thread handle 0x2ad28e69d700, query id 109533853 10.0.101.170 admin update | |
| INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_is_multi_author', '0', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`) | |
| *** (2) HOLDS THE LOCK(S): | |
| RECORD LOCKS space id 47 page no 1697 n bits 344 index `option_name` of table `ebdb`.`wp_options` trx id 464660063 lock_mode X locks gap before rec | |
| Record lock, heap no 212 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 | |
| 0: len 29; hex 5f7472616e7369656e745f6a65747061636b5f68747470735f74657374; asc _transient_jetpack_https_test;; | |
| 1: len 8; hex 000000000074facb; asc t ;; | |
| *** (2) WAITING FOR THIS LOCK TO BE GRANTED: | |
| RECORD LOCKS space id 47 page no 1697 n bits 344 index `option_name` of table `ebdb`.`wp_options` trx id 464660063 lock_mode X locks gap before rec insert intention waiting | |
| Record lock, heap no 212 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 | |
| 0: len 29; hex 5f7472616e7369656e745f6a65747061636b5f68747470735f74657374; asc _transient_jetpack_https_test;; | |
| 1: len 8; hex 000000000074facb; asc t ;; | |
| *** WE ROLL BACK TRANSACTION (2) | |
| ------------ | |
| TRANSACTIONS | |
| ------------ | |
| Trx id counter 464698491 | |
| Purge done for trx's n:o < 464696068 undo n:o < 0 state: running but idle | |
| History list length 1167 | |
| LIST OF TRANSACTIONS FOR EACH SESSION: | |
| ---TRANSACTION 464698490, not started | |
| MySQL thread id 1238934, OS thread handle 0x2ad28d61c700, query id 109574856 10.0.101.170 admin cleaning up | |
| ---TRANSACTION 464698489, not started | |
| MySQL thread id 1238933, OS thread handle 0x2ad28f106700, query id 109574855 10.0.102.58 admin cleaning up | |
| ---TRANSACTION 0, not started | |
| MySQL thread id 1238896, OS thread handle 0x2ad28ecf6700, query id 109574858 10.0.1.118 admin cleaning up | |
| ---TRANSACTION 0, not started | |
| MySQL thread id 1238885, OS thread handle 0x2ad28d59a700, query id 109571629 10.0.1.118 admin cleaning up | |
| ---TRANSACTION 0, not started | |
| MySQL thread id 1233504, OS thread handle 0x2ad28e0c6700, query id 109574857 10.0.1.191 admin init | |
| SHOW ENGINE INNODB STATUS | |
| ---TRANSACTION 0, not started | |
| MySQL thread id 1233513, OS thread handle 0x2ad28d2cf700, query id 109566649 10.0.1.191 admin cleaning up | |
| ---TRANSACTION 464697947, not started | |
| MySQL thread id 3277, OS thread handle 0x2ad28c4b9700, query id 109574225 localhost 127.0.0.1 rdsadmin cleaning up | |
| -------- | |
| 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: 1 | |
| 10623 OS file reads, 3108022 OS file writes, 2127697 OS fsyncs | |
| 0.00 reads/s, 0 avg bytes/read, 2.30 writes/s, 2.16 fsyncs/s | |
| ------------------------------------- | |
| INSERT BUFFER AND ADAPTIVE HASH INDEX | |
| ------------------------------------- | |
| Ibuf: size 1, free list len 0, seg size 2, 24 merges | |
| merged operations: | |
| insert 25, delete mark 0, delete 0 | |
| discarded operations: | |
| insert 0, delete mark 0, delete 0 | |
| Hash table size 23009359, node heap has 1598 buffer(s) | |
| 2454.23 hash searches/s, 435.85 non-hash searches/s | |
| --- | |
| LOG | |
| --- | |
| Log sequence number 3901823801 | |
| Log flushed up to 3901823801 | |
| Pages flushed up to 3901823791 | |
| Last checkpoint at 3901823791 | |
| 0 pending log writes, 0 pending chkp writes | |
| 884168 log i/o's done, 0.97 log i/o's/second | |
| ---------------------- | |
| BUFFER POOL AND MEMORY | |
| ---------------------- | |
| Total memory allocated 11899109376; in additional pool allocated 0 | |
| Dictionary memory allocated 296321 | |
| Buffer pool size 709624 | |
| Free buffers 695931 | |
| Database pages 12095 | |
| Old database pages 4334 | |
| Modified db pages 1 | |
| Pending reads 0 | |
| Pending writes: LRU 0, flush list 1, single page 0 | |
| Pages made young 78, not young 0 | |
| 0.00 youngs/s, 0.00 non-youngs/s | |
| Pages read 10399, created 1696, written 1658402 | |
| 0.00 reads/s, 0.00 creates/s, 0.78 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: 12095, 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 88703 | |
| Free buffers 86816 | |
| Database pages 1681 | |
| Old database pages 600 | |
| Modified db pages 1 | |
| Pending reads 0 | |
| Pending writes: LRU 0, flush list 1, single page 0 | |
| Pages made young 4, not young 0 | |
| 0.00 youngs/s, 0.00 non-youngs/s | |
| Pages read 1344, created 337, written 359726 | |
| 0.00 reads/s, 0.00 creates/s, 0.62 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: 1681, unzip_LRU len: 0 | |
| I/O sum[0]:cur[0], unzip sum[0]:cur[0] | |
| ---BUFFER POOL 1 | |
| Buffer pool size 88703 | |
| Free buffers 86938 | |
| Database pages 1562 | |
| Old database pages 556 | |
| Modified db pages 0 | |
| Pending reads 0 | |
| Pending writes: LRU 0, flush list 0, single page 0 | |
| Pages made young 11, not young 0 | |
| 0.00 youngs/s, 0.00 non-youngs/s | |
| Pages read 1259, created 303, written 545102 | |
| 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: 1562, unzip_LRU len: 0 | |
| I/O sum[0]:cur[0], unzip sum[0]:cur[0] | |
| ---BUFFER POOL 2 | |
| Buffer pool size 88703 | |
| Free buffers 87165 | |
| Database pages 1340 | |
| Old database pages 474 | |
| Modified db pages 0 | |
| Pending reads 0 | |
| Pending writes: LRU 0, flush list 0, single page 0 | |
| Pages made young 4, not young 0 | |
| 0.00 youngs/s, 0.00 non-youngs/s | |
| Pages read 1151, created 189, written 33659 | |
| 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: 1340, unzip_LRU len: 0 | |
| I/O sum[0]:cur[0], unzip sum[0]:cur[0] | |
| ---BUFFER POOL 3 | |
| Buffer pool size 88703 | |
| Free buffers 87030 | |
| Database pages 1480 | |
| Old database pages 546 | |
| Modified db pages 0 | |
| Pending reads 0 | |
| Pending writes: LRU 0, flush list 0, single page 0 | |
| Pages made young 10, not young 0 | |
| 0.00 youngs/s, 0.00 non-youngs/s | |
| Pages read 1333, created 147, written 129699 | |
| 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: 1480, unzip_LRU len: 0 | |
| I/O sum[0]:cur[0], unzip sum[0]:cur[0] | |
| ---BUFFER POOL 4 | |
| Buffer pool size 88703 | |
| Free buffers 86897 | |
| Database pages 1597 | |
| Old database pages 582 | |
| Modified db pages 0 | |
| Pending reads 0 | |
| Pending writes: LRU 0, flush list 0, single page 0 | |
| Pages made young 9, not young 0 | |
| 0.00 youngs/s, 0.00 non-youngs/s | |
| Pages read 1430, created 167, written 128963 | |
| 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: 1597, unzip_LRU len: 0 | |
| I/O sum[0]:cur[0], unzip sum[0]:cur[0] | |
| ---BUFFER POOL 5 | |
| Buffer pool size 88703 | |
| Free buffers 86953 | |
| Database pages 1555 | |
| Old database pages 554 | |
| Modified db pages 0 | |
| Pending reads 0 | |
| Pending writes: LRU 0, flush list 0, single page 0 | |
| Pages made young 11, not young 0 | |
| 0.00 youngs/s, 0.00 non-youngs/s | |
| Pages read 1429, created 126, written 61347 | |
| 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: 1555, unzip_LRU len: 0 | |
| I/O sum[0]:cur[0], unzip sum[0]:cur[0] | |
| ---BUFFER POOL 6 | |
| Buffer pool size 88703 | |
| Free buffers 86992 | |
| Database pages 1517 | |
| Old database pages 539 | |
| Modified db pages 0 | |
| Pending reads 0 | |
| Pending writes: LRU 0, flush list 0, single page 0 | |
| Pages made young 6, not young 0 | |
| 0.00 youngs/s, 0.00 non-youngs/s | |
| Pages read 1302, created 215, written 119723 | |
| 0.00 reads/s, 0.00 creates/s, 0.11 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: 1517, unzip_LRU len: 0 | |
| I/O sum[0]:cur[0], unzip sum[0]:cur[0] | |
| ---BUFFER POOL 7 | |
| Buffer pool size 88703 | |
| Free buffers 87140 | |
| Database pages 1363 | |
| Old database pages 483 | |
| Modified db pages 0 | |
| Pending reads 0 | |
| Pending writes: LRU 0, flush list 0, single page 0 | |
| Pages made young 23, not young 0 | |
| 0.00 youngs/s, 0.00 non-youngs/s | |
| Pages read 1151, created 212, written 280183 | |
| 0.00 reads/s, 0.00 creates/s, 0.05 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: 1363, 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 | |
| Main thread process no. 16125, id 47083954534144, state: sleeping | |
| Number of rows inserted 114999, updated 209878, deleted 9367, read 2552458026 | |
| 0.00 inserts/s, 0.08 updates/s, 0.00 deletes/s, 2835.03 reads/s | |
| ---------------------------- | |
| END OF INNODB MONITOR OUTPUT | |
| ============================ |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment