mysql> show engine innodb status \G
***************************
1
. row ***************************
Type: InnoDB
Name:
Status:
=====================================
150202
17
:
15
:
33
INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last
19
seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops:
0
srv_active,
0
srv_shutdown,
8787
srv_idle
srv_master_thread log flush and writes:
8787
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count
3
OS WAIT ARRAY INFO: signal count
3
Mutex spin waits
2
, rounds
60
, OS waits
1
RW-shared spins
2
, rounds
60
, OS waits
2
RW-excl spins
0
, rounds
0
, OS waits
0
Spin rounds per wait:
30.00
mutex,
30.00
RW-shared,
0.00
RW-excl
------------
TRANSACTIONS
------------
Trx id counter
2305
Purge done
for
trx's n:o <
0
undo n:o <
0
History list length
0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION
0
, not started
MySQL thread id
3
, OS thread handle
0x7fe2a80c2700
, query id
45
localhost root init
show engine innodb status
--------
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
161
OS file reads,
5
OS file writes,
5
OS fsyncs
0.00
reads/s,
0
avg bytes/read,
0.00
writes/s,
0.00
fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size
1
, free list len
0
, seg size
2
,
0
merges
merged operations:
insert
0
, delete mark
0
, delete
0
discarded operations:
insert
0
, delete mark
0
, delete
0
Hash table size
276707
, node heap has
0
buffer(s)
0.00
hash searches/s,
0.00
non-hash searches/s
---
LOG
---
Log sequence number
1602871
Log flushed up to
1602871
Pages flushed up to
1602871
Last checkpoint at
1602871
0
pending log writes,
0
pending chkp writes
8
log i/o
's done, 0.00 log i/o'
s/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated
137363456
; in additional pool allocated
0
Dictionary memory allocated
43148
Buffer pool size
8192
Free buffers
8042
Database pages
150
Old database pages
0
Modified db pages
0
Pending reads
0
Pending writes: LRU
0
, flush list
0
single page
0
Pages made young
0
, not young
0
0.00
youngs/s,
0.00
non-youngs/s
Pages read
150
, created
0
, written
1
0.00
reads/s,
0.00
creates/s,
0.00
writes/s
No buffer pool page gets since the last printout
Pages read ahead
0.00
/s, evicted without access
0.00
/s, Random read ahead
0.00
/s
LRU len:
150
, 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.
4294
, id
140611110070016
, state: sleeping
Number of rows inserted
0
, updated
0
, deleted
0
, read
0
0.00
inserts/s,
0.00
updates/s,
0.00
deletes/s,
0.00
reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
1
row in set (
0.00
sec)
