Home > Database > Mysql Tutorial > python写的分析mysql binlog日志工具

python写的分析mysql binlog日志工具

WBOY
Release: 2016-06-07 17:38:29
Original
1280 people have browsed it

因为数据库增删改突然暴增,需要查询是那些表的操作特别频繁,写了一个用来分析bin-log的小工具,找出增删改查的表,并按照操作次数降序排列,以下是代码:#form

因为数据库增删改突然暴增,需要查询是那些表的操作特别频繁,写了一个用来分析bin-log的小工具,,找出增删改查的表,并按照操作次数降序排列,以下是代码:

#for mysql5.5 binlog import os,sys #python binlog.py binglog-0001 '2013-07-01 00:00:00' '2013-07-02 00:00:00' def log_w(type,text): logfile = "%s.txt" % (type,text) #now = time.strftime("%Y-%m-%d %H:%M:%S") tt = str(text) + "\n" f = open(logfile,'a+') f.write(tt) f.close() logname = sys.argv[1] start_time = sys.argv[2] end_time = sys.argv[3] comn = "/usr/bin/mysqlbinlog --start-datetime='%s' --stop-datetime='%s' %s" % (start_time,end_time,logname) aa=os.popen(comn).readlines() mylist=[] for a in aa: if ('UPDATE' in a): update = ' '.join(a.split()[:2]) mylist.append(update) if ('INSERT INTO' in a): update = ' '.join(a.split()[:3]).replace("INTO ","") mylist.append(update) if ('DELETE from' in a): update = ' '.join(a.split()[:3]).replace("from ","") mylist.append(update) mylist.sort() bb = list(set(mylist)) bb.sort() cc = [] for item in bb: cc.append([mylist.count(item),(item)]) cc.sort() cc.reverse() for i in cc: print str(i[0])+'\t'+i[1]

spacer.gif

spacer.gif

执行结果如下:

165939295.jpg


本文出自 “王伟” 博客,请务必保留此出处

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template