1
=====================================
2
090507 15:57:51 INNODB MONITOR OUTPUT
3
=====================================
4
Per second averages calculated from the last 27 seconds
8
OS WAIT ARRAY INFO: reservation count 4694218, signal count 9295635
9
Mutex spin waits 79626940, rounds 157459864, OS waits 698719
10
RW-shared spins 3859028, OS waits 2100750; RW-excl spins 4641946, OS waits 1530310
11
Spin rounds per wait: 1.98 mutex, 14.39 RW-shared, 13.15 RW-excl
15
I/O thread 0 state: waiting for i/o request (insert buffer thread)
16
I/O thread 1 state: waiting for i/o request (log thread)
17
I/O thread 2 state: waiting for i/o request (read thread)
18
I/O thread 3 state: waiting for i/o request (write thread)
19
Pending normal aio reads: 1, aio writes: 2,
20
ibuf aio reads: 1, log i/o's: 2, sync i/o's: 3
21
Pending flushes (fsync) log: 1; buffer pool: 2
22
8782182 OS file reads, 15635445 OS file writes, 947800 OS fsyncs
23
28.41 reads/s, 25569 avg bytes/read, 23.00 writes/s, 2.26 fsyncs/s
24
-------------------------------------
25
INSERT BUFFER AND ADAPTIVE HASH INDEX
26
-------------------------------------
27
Ibuf: size 10204, free list len 157151, seg size 167356,
28
17549044 inserts, 15956910 merged recs, 1676050 merges
29
Hash table size 57374437, node heap has 72964 buffer(s)
30
639.20 hash searches/s, 1370.02 non-hash searches/s
34
Log sequence number 13093949495856
35
Log flushed up to 13093948219327
36
Last checkpoint at 13093217877062
37
Max checkpoint age 847455806
38
Modified age 731618794
39
Checkpoint age 731618794
40
1 pending log writes, 2 pending chkp writes
41
3430041 log i/o's done, 17.44 log i/o's/second
42
----------------------
43
BUFFER POOL AND MEMORY
44
----------------------
45
Total memory allocated 29642194944; in additional pool allocated 0
46
Internal hash tables (constant factor + variable factor)
47
Adaptive hash index 1654507416 (458995496 + 1195511920)
49
Dictionary cache 116312344 (114750928 + 1561416)
50
File system 172560 (82672 + 89888)
51
Lock system 71719560 (71718824 + 736)
52
Recovery system 0 (0 + 0)
53
Threads 407576 (406936 + 640)
54
Dictionary memory allocated 1561416
55
Buffer pool size 1769471
56
Buffer pool size, bytes 28991012864
58
Database pages 1696503
59
Modified db pages 160602
61
Pending writes: LRU 0, flush list 0, single page 0
62
Pages read 15240822, created 1770238, written 21705836
63
44.37 reads/s, 2.15 creates/s, 21.18 writes/s
64
Buffer pool hit rate 994 / 1000
65
LRU len: 1696503, unzip_LRU len: 0
66
I/O sum[2417]:cur[4], unzip sum[0]:cur[0]
70
1 queries inside InnoDB, 2 queries in queue
71
1 read views open inside InnoDB
72
Main thread process no. 13510, id 1169914176, state: sleeping
73
Number of rows inserted 50678311, updated 66425915, deleted 20605903, read 454561562
74
59.55 inserts/s, 434.35 updates/s, 35.15 deletes/s, 469.46 reads/s
78
Trx id counter EF861B144C
79
Purge done for trx's n:o < 861B135D undo n:o < 0
80
History list length 132
81
LIST OF TRANSACTIONS FOR EACH SESSION:
82
---TRANSACTION 0, not started, process no 13510, OS thread id 1170446656
83
MySQL thread id 8561, query id 79637659 linux.trioptima.com 192.168.33.253 mysqltop
85
---TRANSACTION 861B144A, not started, process no 13510, OS thread id 1171245376
86
MySQL thread id 4096, query id 79637665 Has read all relay log; waiting for the slave I/O thread to update it
87
----------------------------
88
END OF INNODB MONITOR OUTPUT
89
============================