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
|
global mysql_options
mysql_options = os.getenv('DSTAT_MYSQL')
class dstat_plugin(dstat):
def __init__(self):
self.name = 'mysql key status'
self.nick = ('used', 'read', 'writ', 'rreq', 'wreq')
self.vars = ('Key_blocks_used', 'Key_reads', 'Key_writes', 'Key_read_requests', 'Key_write_requests')
self.type = 'f'
self.width = 4
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:
raise Exception('Cannot interface with MySQL binary')
def extract(self):
try:
self.stdin.write("show status like 'Key_%';\n")
for line in readpipe(self.stdout):
l = line.split()
if len(l) < 2: continue
if l[0] in self.vars:
self.set2[l[0]] = float(l[1])
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 as 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 as 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
|
