因为数据库增删改突然暴增，需要查询是那些表的操作特别频繁，写了一个用来分析bin-log的小工具，找出增删改查的表，并按照操作次数降序排列，以下是代码：
|
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
|
#for mysql5.5 binlogimport 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) + "
" 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])+' '+i[1] |