qiyuxi
- 浏览: 26120 次
- 性别:
- 来自: 深圳
-
文章分类
最新评论
show engine innodb status
=====================================
2017-02-17 18:26:07 7f14a2411700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 8 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 2041789 srv_active, 0 srv_shutdown, 1482075 srv_idle
srv_master_thread log flush and writes: 3523864
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 2911377
OS WAIT ARRAY INFO: signal count 3438443
Mutex spin waits 2506762, rounds 49757768, OS waits 1623200
RW-shared spins 1952414, rounds 36771492, OS waits 1143636
RW-excl spins 433191, rounds 5164657, OS waits 117538
Spin rounds per wait: 19.85 mutex, 18.83 RW-shared, 11.92 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 523219377
Purge done for trx''s n:o < 523219377 undo n:o < 0 state: running but idle
History list length 1605
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 16339967, OS thread handle 0x7f14a2411700, query id 116330869 192.168.1.194 dev init
show engine innodb status
---TRANSACTION 523219374, not started
MySQL thread id 16340017, OS thread handle 0x7f14a379e700, query id 116330870 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219365, not started
MySQL thread id 16340015, OS thread handle 0x7f14a3aaa700, query id 116330837 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219375, not started
MySQL thread id 16340013, OS thread handle 0x7f14c84f5700, query id 116330873 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219344, not started
MySQL thread id 16340011, OS thread handle 0x7f14a1c32700, query id 116330820 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 0, not started
MySQL thread id 16339966, OS thread handle 0x7f14a3104700, query id 116330872 192.168.1.194 dev cleaning up
---TRANSACTION 523219217, not started
MySQL thread id 16339981, OS thread handle 0x7f14c85b8700, query id 116330457 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219213, not started
MySQL thread id 16339978, OS thread handle 0x7f14a2fbf700, query id 116330449 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219210, not started
MySQL thread id 16339975, OS thread handle 0x7f14a33cf700, query id 116330443 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219289, not started
MySQL thread id 16339974, OS thread handle 0x7f14a27e0700, query id 116330698 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219228, not started
MySQL thread id 16339433, OS thread handle 0x7f14a3000700, query id 116330602 node21.pp100.net 192.168.6.21 dev cleaning up
---TRANSACTION 523218361, not started
MySQL thread id 16339431, OS thread handle 0x7f14c822c700, query id 116328924 node21.pp100.net 192.168.6.21 dev cleaning up
---TRANSACTION 523219236, not started
MySQL thread id 16338308, OS thread handle 0x7f14a224a700, query id 116330563 node21.pp100.net 192.168.6.21 dev cleaning up
---TRANSACTION 523219239, not started
MySQL thread id 16338306, OS thread handle 0x7f14c8842700, query id 116330593 node21.pp100.net 192.168.6.21 dev cleaning up
---TRANSACTION 523219235, not started
MySQL thread id 16338300, OS thread handle 0x7f14a3618700, query id 116330554 node18.pp100.net 192.168.6.18 dev cleaning up
---TRANSACTION 523219241, not started
MySQL thread id 16338304, OS thread handle 0x7f14a271d700, query id 116330612 node21.pp100.net 192.168.6.21 dev cleaning up
---TRANSACTION 523219373, not started
MySQL thread id 16331847, OS thread handle 0x7f14c8169700, query id 116330855 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 0, not started
MySQL thread id 16331846, OS thread handle 0x7f14caea4700, query id 116326190 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219242, not started
MySQL thread id 16331742, OS thread handle 0x7f14c85f9700, query id 116330635 node18.pp100.net 192.168.6.18 dev cleaning up
---TRANSACTION 523218362, not started
MySQL thread id 16329108, OS thread handle 0x7f14c8577700, query id 116328920 node18.pp100.net 192.168.6.18 dev cleaning up
---TRANSACTION 523218854, not started
MySQL thread id 16324979, OS thread handle 0x7f14a30c3700, query id 116330411 node16.pp100.net 192.168.6.16 dev cleaning up
---TRANSACTION 523218255, not started
MySQL thread id 16324981, OS thread handle 0x7f14c8883700, query id 116330413 node16.pp100.net 192.168.6.16 dev cleaning up
---TRANSACTION 523217678, not started
MySQL thread id 16324980, OS thread handle 0x7f14c8801700, query id 116330412 node16.pp100.net 192.168.6.16 dev cleaning up
---TRANSACTION 523154476, not started
MySQL thread id 16321728, OS thread handle 0x7f14a2e7a700, query id 116124445 192.168.1.199 dev cleaning up
---TRANSACTION 0, not started
MySQL thread id 16321710, OS thread handle 0x7f14a2d76700, query id 116124093 192.168.1.199 dev cleaning up
---TRANSACTION 523206836, not started
MySQL thread id 16321461, OS thread handle 0x7f14a1fc0700, query id 116330415 node16.pp100.net 192.168.6.16 dev cleaning up
---TRANSACTION 523049437, not started
MySQL thread id 16292497, OS thread handle 0x7f14a3410700, query id 115808491 192.168.1.189 dev cleaning up
---TRANSACTION 523023325, not started
MySQL thread id 16284388, OS thread handle 0x7f14c8c93700, query id 115753515 192.168.1.191 root cleaning up
---TRANSACTION 0, not started
MySQL thread id 16190017, OS thread handle 0x7f14c80e7700, query id 116141937 192.168.1.141 dev cleaning up
---TRANSACTION 522986314, not started
MySQL thread id 16267723, OS thread handle 0x7f14a3c30700, query id 115654969 192.168.1.144 dev cleaning up
---TRANSACTION 0, not started
MySQL thread id 16267306, OS thread handle 0x7f14a1d36700, query id 115564249 192.168.1.144 dev cleaning up
---TRANSACTION 0, not started
MySQL thread id 16267289, OS thread handle 0x7f14a2c31700, query id 115563962 192.168.1.144 dev cleaning up
---TRANSACTION 523164504, not started
MySQL thread id 16221325, OS thread handle 0x7f14c8a8b700, query id 116330414 node16.pp100.net 192.168.6.16 dev cleaning up
---TRANSACTION 522807317, not started
MySQL thread id 16221955, OS thread handle 0x7f14c81aa700, query id 115181936 192.168.1.182 dev cleaning up
---TRANSACTION 0, not started
MySQL thread id 16193854, OS thread handle 0x7f14a3249700, query id 115753850 192.168.1.191 root cleaning up
---TRANSACTION 522984987, not started
MySQL thread id 16192830, OS thread handle 0x7f14c8905700, query id 115651993 192.168.1.145 dev cleaning up
---TRANSACTION 0, not started
MySQL thread id 16192765, OS thread handle 0x7f14a2b6e700, query id 115651778 192.168.1.145 dev cleaning up
---TRANSACTION 523166197, not started
MySQL thread id 16190073, OS thread handle 0x7f14a35d7700, query id 116149192 192.168.1.141 dev cleaning up
---TRANSACTION 0, not started
MySQL thread id 16186327, OS thread handle 0x7f14a3eba700, query id 115181921 192.168.1.182 dev cleaning up
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (write thread)
I/O thread 7 state: waiting for i/o request (write thread)
I/O thread 8 state: waiting for i/o request (write thread)
I/O thread 9 state: waiting for i/o request (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
126223 OS file reads, 29898157 OS file writes, 11754541 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 12.25 writes/s, 4.87 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7, 3278 merges
merged operations:
insert 6939, delete mark 2553, delete 1262
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 10624727, node heap has 3414 buffer(s)
194.73 hash searches/s, 105.74 non-hash searches/s
---
LOG
---
Log sequence number 170031549686
Log flushed up to 170031549189
Pages flushed up to 170031532814
Last checkpoint at 170031532814
0 pending log writes, 0 pending chkp writes
9743470 log i/o''s done, 4.38 log i/o''s/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 5494538240; in additional pool allocated 0
Dictionary memory allocated 9316456
Buffer pool size 327672
Free buffers 101527
Database pages 222731
Old database pages 82247
Modified db pages 23
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1043, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 181720, created 41011, written 21952933
0.00 reads/s, 0.00 creates/s, 8.12 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: 222731, 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 40959
Free buffers 12094
Database pages 28442
Old database pages 10481
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 150, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 23071, created 5371, written 3883250
0.00 reads/s, 0.00 creates/s, 0.75 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: 28442, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 40959
Free buffers 12546
Database pages 27990
Old database pages 10351
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 68, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22818, created 5172, written 1235821
0.00 reads/s, 0.00 creates/s, 0.12 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: 27990, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 40959
Free buffers 12452
Database pages 28080
Old database pages 10379
Modified db pages 3
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 160, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22652, created 5428, written 1489375
0.00 reads/s, 0.00 creates/s, 1.12 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: 28080, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 40959
Free buffers 12759
Database pages 27767
Old database pages 10267
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 118, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22900, created 4867, written 4474465
0.00 reads/s, 0.00 creates/s, 0.25 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: 27767, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 40959
Free buffers 12540
Database pages 28006
Old database pages 10356
Modified db pages 10
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 128, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22768, created 5238, written 4299446
0.00 reads/s, 0.00 creates/s, 2.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: 28006, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 40959
Free buffers 13349
Database pages 27176
Old database pages 10023
Modified db pages 1
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 112, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 21966, created 5210, written 1314134
0.00 reads/s, 0.00 creates/s, 1.12 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: 27176, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 40959
Free buffers 12334
Database pages 28194
Old database pages 10400
Modified db pages 6
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 221, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 23495, created 4699, written 3811952
0.00 reads/s, 0.00 creates/s, 1.75 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: 28194, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 40959
Free buffers 13453
Database pages 27076
Old database pages 9990
Modified db pages 3
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 86, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22050, created 5026, written 1444490
0.00 reads/s, 0.00 creates/s, 0.37 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: 27076, 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. 1493, id 139727345493760, state: sleeping
Number of rows inserted 576345, updated 7080840, deleted 226779, read 7819671243
0.00 inserts/s, 3.12 updates/s, 0.00 deletes/s, 1519.06 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
=====================================
2017-02-17 18:26:07 7f14a2411700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 8 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 2041789 srv_active, 0 srv_shutdown, 1482075 srv_idle
srv_master_thread log flush and writes: 3523864
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 2911377
OS WAIT ARRAY INFO: signal count 3438443
Mutex spin waits 2506762, rounds 49757768, OS waits 1623200
RW-shared spins 1952414, rounds 36771492, OS waits 1143636
RW-excl spins 433191, rounds 5164657, OS waits 117538
Spin rounds per wait: 19.85 mutex, 18.83 RW-shared, 11.92 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 523219377
Purge done for trx''s n:o < 523219377 undo n:o < 0 state: running but idle
History list length 1605
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 16339967, OS thread handle 0x7f14a2411700, query id 116330869 192.168.1.194 dev init
show engine innodb status
---TRANSACTION 523219374, not started
MySQL thread id 16340017, OS thread handle 0x7f14a379e700, query id 116330870 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219365, not started
MySQL thread id 16340015, OS thread handle 0x7f14a3aaa700, query id 116330837 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219375, not started
MySQL thread id 16340013, OS thread handle 0x7f14c84f5700, query id 116330873 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219344, not started
MySQL thread id 16340011, OS thread handle 0x7f14a1c32700, query id 116330820 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 0, not started
MySQL thread id 16339966, OS thread handle 0x7f14a3104700, query id 116330872 192.168.1.194 dev cleaning up
---TRANSACTION 523219217, not started
MySQL thread id 16339981, OS thread handle 0x7f14c85b8700, query id 116330457 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219213, not started
MySQL thread id 16339978, OS thread handle 0x7f14a2fbf700, query id 116330449 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219210, not started
MySQL thread id 16339975, OS thread handle 0x7f14a33cf700, query id 116330443 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219289, not started
MySQL thread id 16339974, OS thread handle 0x7f14a27e0700, query id 116330698 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219228, not started
MySQL thread id 16339433, OS thread handle 0x7f14a3000700, query id 116330602 node21.pp100.net 192.168.6.21 dev cleaning up
---TRANSACTION 523218361, not started
MySQL thread id 16339431, OS thread handle 0x7f14c822c700, query id 116328924 node21.pp100.net 192.168.6.21 dev cleaning up
---TRANSACTION 523219236, not started
MySQL thread id 16338308, OS thread handle 0x7f14a224a700, query id 116330563 node21.pp100.net 192.168.6.21 dev cleaning up
---TRANSACTION 523219239, not started
MySQL thread id 16338306, OS thread handle 0x7f14c8842700, query id 116330593 node21.pp100.net 192.168.6.21 dev cleaning up
---TRANSACTION 523219235, not started
MySQL thread id 16338300, OS thread handle 0x7f14a3618700, query id 116330554 node18.pp100.net 192.168.6.18 dev cleaning up
---TRANSACTION 523219241, not started
MySQL thread id 16338304, OS thread handle 0x7f14a271d700, query id 116330612 node21.pp100.net 192.168.6.21 dev cleaning up
---TRANSACTION 523219373, not started
MySQL thread id 16331847, OS thread handle 0x7f14c8169700, query id 116330855 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 0, not started
MySQL thread id 16331846, OS thread handle 0x7f14caea4700, query id 116326190 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219242, not started
MySQL thread id 16331742, OS thread handle 0x7f14c85f9700, query id 116330635 node18.pp100.net 192.168.6.18 dev cleaning up
---TRANSACTION 523218362, not started
MySQL thread id 16329108, OS thread handle 0x7f14c8577700, query id 116328920 node18.pp100.net 192.168.6.18 dev cleaning up
---TRANSACTION 523218854, not started
MySQL thread id 16324979, OS thread handle 0x7f14a30c3700, query id 116330411 node16.pp100.net 192.168.6.16 dev cleaning up
---TRANSACTION 523218255, not started
MySQL thread id 16324981, OS thread handle 0x7f14c8883700, query id 116330413 node16.pp100.net 192.168.6.16 dev cleaning up
---TRANSACTION 523217678, not started
MySQL thread id 16324980, OS thread handle 0x7f14c8801700, query id 116330412 node16.pp100.net 192.168.6.16 dev cleaning up
---TRANSACTION 523154476, not started
MySQL thread id 16321728, OS thread handle 0x7f14a2e7a700, query id 116124445 192.168.1.199 dev cleaning up
---TRANSACTION 0, not started
MySQL thread id 16321710, OS thread handle 0x7f14a2d76700, query id 116124093 192.168.1.199 dev cleaning up
---TRANSACTION 523206836, not started
MySQL thread id 16321461, OS thread handle 0x7f14a1fc0700, query id 116330415 node16.pp100.net 192.168.6.16 dev cleaning up
---TRANSACTION 523049437, not started
MySQL thread id 16292497, OS thread handle 0x7f14a3410700, query id 115808491 192.168.1.189 dev cleaning up
---TRANSACTION 523023325, not started
MySQL thread id 16284388, OS thread handle 0x7f14c8c93700, query id 115753515 192.168.1.191 root cleaning up
---TRANSACTION 0, not started
MySQL thread id 16190017, OS thread handle 0x7f14c80e7700, query id 116141937 192.168.1.141 dev cleaning up
---TRANSACTION 522986314, not started
MySQL thread id 16267723, OS thread handle 0x7f14a3c30700, query id 115654969 192.168.1.144 dev cleaning up
---TRANSACTION 0, not started
MySQL thread id 16267306, OS thread handle 0x7f14a1d36700, query id 115564249 192.168.1.144 dev cleaning up
---TRANSACTION 0, not started
MySQL thread id 16267289, OS thread handle 0x7f14a2c31700, query id 115563962 192.168.1.144 dev cleaning up
---TRANSACTION 523164504, not started
MySQL thread id 16221325, OS thread handle 0x7f14c8a8b700, query id 116330414 node16.pp100.net 192.168.6.16 dev cleaning up
---TRANSACTION 522807317, not started
MySQL thread id 16221955, OS thread handle 0x7f14c81aa700, query id 115181936 192.168.1.182 dev cleaning up
---TRANSACTION 0, not started
MySQL thread id 16193854, OS thread handle 0x7f14a3249700, query id 115753850 192.168.1.191 root cleaning up
---TRANSACTION 522984987, not started
MySQL thread id 16192830, OS thread handle 0x7f14c8905700, query id 115651993 192.168.1.145 dev cleaning up
---TRANSACTION 0, not started
MySQL thread id 16192765, OS thread handle 0x7f14a2b6e700, query id 115651778 192.168.1.145 dev cleaning up
---TRANSACTION 523166197, not started
MySQL thread id 16190073, OS thread handle 0x7f14a35d7700, query id 116149192 192.168.1.141 dev cleaning up
---TRANSACTION 0, not started
MySQL thread id 16186327, OS thread handle 0x7f14a3eba700, query id 115181921 192.168.1.182 dev cleaning up
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (write thread)
I/O thread 7 state: waiting for i/o request (write thread)
I/O thread 8 state: waiting for i/o request (write thread)
I/O thread 9 state: waiting for i/o request (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
126223 OS file reads, 29898157 OS file writes, 11754541 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 12.25 writes/s, 4.87 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7, 3278 merges
merged operations:
insert 6939, delete mark 2553, delete 1262
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 10624727, node heap has 3414 buffer(s)
194.73 hash searches/s, 105.74 non-hash searches/s
---
LOG
---
Log sequence number 170031549686
Log flushed up to 170031549189
Pages flushed up to 170031532814
Last checkpoint at 170031532814
0 pending log writes, 0 pending chkp writes
9743470 log i/o''s done, 4.38 log i/o''s/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 5494538240; in additional pool allocated 0
Dictionary memory allocated 9316456
Buffer pool size 327672
Free buffers 101527
Database pages 222731
Old database pages 82247
Modified db pages 23
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1043, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 181720, created 41011, written 21952933
0.00 reads/s, 0.00 creates/s, 8.12 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: 222731, 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 40959
Free buffers 12094
Database pages 28442
Old database pages 10481
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 150, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 23071, created 5371, written 3883250
0.00 reads/s, 0.00 creates/s, 0.75 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: 28442, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 40959
Free buffers 12546
Database pages 27990
Old database pages 10351
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 68, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22818, created 5172, written 1235821
0.00 reads/s, 0.00 creates/s, 0.12 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: 27990, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 40959
Free buffers 12452
Database pages 28080
Old database pages 10379
Modified db pages 3
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 160, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22652, created 5428, written 1489375
0.00 reads/s, 0.00 creates/s, 1.12 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: 28080, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 40959
Free buffers 12759
Database pages 27767
Old database pages 10267
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 118, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22900, created 4867, written 4474465
0.00 reads/s, 0.00 creates/s, 0.25 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: 27767, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 40959
Free buffers 12540
Database pages 28006
Old database pages 10356
Modified db pages 10
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 128, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22768, created 5238, written 4299446
0.00 reads/s, 0.00 creates/s, 2.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: 28006, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 40959
Free buffers 13349
Database pages 27176
Old database pages 10023
Modified db pages 1
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 112, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 21966, created 5210, written 1314134
0.00 reads/s, 0.00 creates/s, 1.12 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: 27176, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 40959
Free buffers 12334
Database pages 28194
Old database pages 10400
Modified db pages 6
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 221, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 23495, created 4699, written 3811952
0.00 reads/s, 0.00 creates/s, 1.75 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: 28194, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 40959
Free buffers 13453
Database pages 27076
Old database pages 9990
Modified db pages 3
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 86, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22050, created 5026, written 1444490
0.00 reads/s, 0.00 creates/s, 0.37 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: 27076, 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. 1493, id 139727345493760, state: sleeping
Number of rows inserted 576345, updated 7080840, deleted 226779, read 7819671243
0.00 inserts/s, 3.12 updates/s, 0.00 deletes/s, 1519.06 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
分享到：
发表评论
相关推荐
问题： 执行 show engine innodb status\G 时，显示的信息不全，DEADLOCK相关信息太多，后面的都没了 原因： 这是mysql客户端的一个bug：BUG#19825，交互式客户端限制了输出信息最大为 64KB，因此更多的信息无法显示...
8. **新的SQL语句**：添加了诸如ANALYZE TABLE、SHOW ENGINE INNODB STATUS等新SQL语句，便于用户进行性能分析和故障排查。 9. **兼容性**：MySQL 5.5与多种操作系统，包括Windows，有很好的兼容性，尤其是这个64位...
重启MySQL服务后，登录MySQL客户端，输入`SHOW ENGINES;`命令查看所有可用的存储引擎。此时，InnoDB应该被标记为“NO”或“DISABLED”。 禁用InnoDB引擎需要注意的是，这可能会对已经使用InnoDB表的应用造成影响，...
利用MySQL性能监控工具如SHOW STATUS、SHOW VARIABLES、SHOW ENGINE INNODB STATUS等，监控InnoDB的运行状态，及时发现和解决问题。 总结，MySQL的InnoDB存储引擎在提供强大功能的同时，也带来了丰富的优化可能性...
6. **性能监控**：引入了新的性能监控工具，如 `SHOW ENGINE INNODB STATUS` 和 `SHOW STATUS` 命令，帮助管理员更好地理解和优化数据库性能。 7. **安全性和权限管理**：MySQL 5.1 强化了用户权限管理，支持更细...
5. 利用InnoDB监控：通过`SHOW ENGINE INNODB STATUS`和`INNODB_LOCKS`、`INNODB_LOCK_WAITS`等表进行深入分析，找出引发死锁的具体原因，如唯一索引冲突或特定类型的锁导致的阻塞。 在分析过程中，需要注意的是： ...
提供了新的性能监控工具和指标，如`SHOW ENGINE INNODB STATUS`，帮助管理员监控和优化数据库性能。 总的来说，MySQL 5.5是一个功能丰富的数据库管理系统，它的增强功能使其成为大型、高并发应用的理想选择。通过...
10. `show engine innodb status`解读 该命令输出InnoDB引擎的详细状态，包括锁定信息、内存使用和事务状态，有助于诊断和解决问题。 11. InnoDB引擎详解 InnoDB具有回滚段、redo日志和undo日志等特性，保证了数据...
- **监控性能**：定期使用`SHOW ENGINE INNODB STATUS;`命令检查InnoDB状态，以便及时发现潜在问题。 - **调整参数**：根据实际负载和性能测试结果动态调整上述参数，寻找最佳配置方案。 - **使用工具**：利用MySQL...
这个过程可以通过`SHOW ENGINE INNODB STATUS;`命令查看详细信息。 为了预防和减少死锁，可以采取以下策略： 1. **事务设计优化**：尽量减少事务的粒度，避免事务处理大量操作。同时，确保事务内的操作按照相同的...
- **排查步骤**：首先查看`SHOW ENGINE INNODB STATUS`获取死锁日志，找出涉及的SQL，分析SQL的加锁情况，模拟死锁场景，分析日志并确定解决方案。 3. **SQL优化策略** - **加索引**：合理创建和使用索引能显著...
`SHOW ENGINE INNODB STATUS;`可用于检查InnoDB存储引擎的详细信息，帮助诊断问题。 6. **备份与恢复**：MySQL客户端也支持数据的备份和恢复。`mysqldump`命令常用于创建数据库的SQL脚本备份，而`mysqlimport`则...
- D) Run the SHOW ENGINE INNODB STATUS command from the mysql client. - E) Use the sys.innodb_lock_waits view. **正确答案**：C 和 D **解析**： - **A选项**：`SHOW ENGINE INNODB MUTEX`命令主要用于...
- `SHOW ENGINE INNODB STATUS;`：显示 InnoDB 引擎的状态信息，包括锁状态、事务状态等。 - `SHOW VARIABLES LIKE 'innodb%';`：列出所有与 InnoDB 相关的系统变量及其当前值，这对于调整 InnoDB 的配置非常有用。 ...
- `ALTER TABLE table_name ENGINE = InnoDB | MyISAM | MEMORY;` — 更改表的存储引擎。 - `EXPLAIN TABLE_NAME / DESCRIBE TABLE_NAME;` — 显示表的详细结构。 - `SHOW CREATE TABLE table_name;` — 显示创建...
SHOW SLAVE STATUS\G ``` #### 六、测试读写分离 1. **写操作测试** 向主服务器插入数据： ```sql INSERT INTO table_name (column1, column2) VALUES ('value1', 'value2'); ``` 2. **读操作测试** ...