smtc0097 / mysql-cacti-templates

Automatically exported from code.google.com/p/mysql-cacti-templates
GNU General Public License v2.0
0 stars 0 forks source link

SHOW ENGINE INNODB STATUS output changed in 5.5 #202

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
5.0 shows:
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 19640435, signal count 15082398
Mutex spin waits 0, rounds 3325394081, OS waits 10928282
RW-shared spins 9793057, OS waits 2430095; RW-excl spins 13476023, OS waits 
1072071
[...]
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1442, free list len 3847, seg size 5290,
5029903 inserts, 4785535 merged recs, 1064274 merges
Hash table size 8850487, used cells 3385125, node heap has 6294 buffer(s)
27266.79 hash searches/s, 14139.31 non-hash searches/s

5.5.16 does:
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 100104, signal count 966421
Mutex spin waits 1583483, rounds 2374807, OS waits 32937
RW-shared spins 339882, rounds 2716408, OS waits 49515
RW-excl spins 844265, rounds 2687418, OS waits 14238
Spin rounds per wait: 1.50 mutex, 7.99 RW-shared, 3.18 RW-excl
[...]
-------------------------------------
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 84999127, node heap has 25401 buffer(s)
14393.20 hash searches/s, 1263.97 non-hash searches/s

So, spin_waits and os_waits calculated erroneously.
As well as ibuf_inserts, ibuf_merged, and ibuf_merges get nothing.

Original issue reported on code.google.com by dbmelni...@gmail.com on 9 Nov 2011 at 2:46

GoogleCodeExporter commented 8 years ago
Marking for migration / fixing in a new project.

Original comment by baron.schwartz on 4 Jan 2012 at 6:21

GoogleCodeExporter commented 8 years ago
We just had the same issue when upgrading the first machine in production 
(Cacti doesn't monitor DEV/TEST/STG) and I modified the ss_get_mysql_stats.php 
file to meet both old and new output. 

See also the patch attached to this comment. It is not the "nicest" piece of 
code but at least it fixed our immediate problem and it may be useful for 
someone else as well.

Original comment by banpei....@gmail.com on 12 Jan 2012 at 10:24

Attachments:

GoogleCodeExporter commented 8 years ago
Thanks for the patch. This is fixed in the new repository.

Original comment by baron.schwartz on 25 Jan 2012 at 2:32