MySQL_tps
#!/usr/bin/env python#_*_coding:utf8 _*_
import MySQLdb
import datetime
import time
#tps
try:
conn=MySQLdb.connect(host="192.168.1.114",user="dlan",passwd="root123",port=3306)
cur=conn.cursor()
while True:
sql='''show global status where variable_name in('uptime','com_commit','com_rollback')'''
cur.execute(sql)
aa=cur.fetchall()
aa=list(aa)
com_commit1=int(aa)
com_rollback1=int(aa)
uptime1=int(aa)
commit1=com_commit1+com_rollback1
time.sleep(2)
while True:
sql = '''show global status where variable_name in('uptime','com_commit','com_rollback')'''
cur.execute(sql)
data = cur.fetchall()
data = list(aa)
com_commit2 = int(aa)
com_rollback2 = int(aa)
uptime2 = int(aa)
commit2 = com_commit2 + com_rollback2
uptime=uptime2-uptime1
commit=commit2-commit1
print commit/uptime,uptime
break
except MySQLdb.Error,e:
print "MySQL error%d:%s"%(e.args,e.args)
页:
[1]