### 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 ops' self.nick = ('ins', 'upd', 'del', 'rea') self.vars = ('inserted', 'updated', 'deleted', 'read') self.type = 'f' self.width = 3 self.scale = 1000 def check(self): if os.access('/usr/bin/mysql', os.X_OK): try: self.stdin, self.stdout, self.stderr = dpopen('/usr/bin/mysql -n %s' % mysql_options) except IOError: raise Exception, 'Cannot interface with MySQL binary' return True raise Exception, 'Needs MySQL binary' def extract(self): try: self.stdin.write('show engine innodb status\G\n') line = greppipe(self.stdout, 'OS file reads ') if line: l = line.split() self.set2['inserted'] = l[4].rstrip(',') self.set2['updated'] = l[6].rstrip(',') self.set2['deleted'] = l[8].rstrip(',') self.set2['read'] = l[10] 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' % (self.filename, e) for name in self.vars: self.val[name] = -1 # vim:ts=4:sw=4:et

💾 SAVE CHANGES CANCEL