/usr/share/dstat/dstat_innodb_buffer.py is in dstat 0.7.2-4.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 | ### Author: Dag Wieers <dag$wieers,com>
global mysql_options
mysql_options = os.getenv('DSTAT_MYSQL')
class dstat_plugin(dstat):
def __init__(self):
self.name = 'innodb pool'
self.nick = ('crt', 'rea', 'wri')
self.vars = ('created', 'read', 'written')
self.type = 'f'
self.width = 3
self.scale = 1000
def check(self):
if not os.access('/usr/bin/mysql', os.X_OK):
raise Exception, 'Needs MySQL binary'
try:
self.stdin, self.stdout, self.stderr = dpopen('/usr/bin/mysql -n %s' % mysql_options)
except IOError, e:
raise Exception, 'Cannot interface with MySQL binary (%s)' % e
def extract(self):
try:
self.stdin.write('show engine innodb status\G\n')
line = greppipe(self.stdout, 'Pages read ')
if line:
l = line.split()
self.set2['read'] = int(l[2].rstrip(','))
self.set2['created'] = int(l[4].rstrip(','))
self.set2['written'] = int(l[6])
for name in self.vars:
self.val[name] = (self.set2[name] - self.set1[name]) * 1.0 / elapsed
if step == op.delay:
self.set1.update(self.set2)
except IOError, e:
if op.debug > 1: print '%s: lost pipe to mysql, %s' % (self.filename, e)
for name in self.vars: self.val[name] = -1
except Exception, e:
if op.debug > 1: print '%s: exception: %s' % (self.filename, e)
for name in self.vars: self.val[name] = -1
# vim:ts=4:sw=4:et
|