### Author: global mysql_user mysql_user = os.getenv('DSTAT_MYSQL_USER') or os.getenv('USER') global mysql_pwd mysql_pwd = os.getenv('DSTAT_MYSQL_PWD') class dstat_plugin(dstat): """ Plugin for MySQL 5 connections. """ def __init__(self): self.name = 'mysql5 conn' self.type = 'f' self.width = 4 self.scale = 1 self.nick = ('ThCon', '%Con') self.vars = ('Threads_connected', 'Threads') def check(self): global MySQLdb import MySQLdb try: self.db = MySQLdb.connect(user=mysql_user, passwd=mysql_pwd) except Exception, e: raise Exception, 'Cannot interface with MySQL server, %s' % e def extract(self): try: c = self.db.cursor() c.execute("""show global variables like 'max_connections';""") max = c.fetchone() c.execute("""show global status like 'Threads_connected';""") thread = c.fetchone() if thread[0] in self.vars: self.set2[thread[0]] = float(thread[1]) self.set2['Threads'] = float(thread[1]) / float(max[1]) * 100.0 for name in self.vars: self.val[name] = self.set2[name] * 1.0 / elapsed if step == op.delay: self.set1.update(self.set2) except Exception, e: for name in self.vars: self.val[name] = -1 # vim:ts=4:sw=4:et