首页 > 代码库 > mysql慢查询日志切割,日志分析

mysql慢查询日志切割,日志分析

#!/usr/bin/env python

#coding:utf8

import os,sys

import datetime,shutil,subprocess

from config.config import slow_config

class cut_mysql(object):

   mysql_user,mysql_pass,date_day,slow_log_name,slow_log_path,mysqlsla_log_name,mysqldumpslow_log_name,new_log_path,new_log_name,cut_command,mysqlsla_cmd,mysqldumpslow_cmd = slow_config

   def __init__ (self):

       self.mysql_slow()

   def mysql_slow (self):

       os.chdir(self.slow_log_path)

       if self.new_log_path in os.listdir(self.slow_log_path):

           pass

       else:

           os.mkdir(self.slow_log_path+self.new_log_path)

       if self.slow_log_name in os.listdir(self.slow_log_path):

           os.rename(self.slow_log_name,self.new_log_name)

           if self.new_log_name in os.listdir(self.slow_log_path+self.new_log_path):

               pass

           else:

               shutil.move(self.new_log_name,self.slow_log_path+self.new_log_path)

       reload_slow=subprocess.Popen(self.cut_command,shell=True)

       self.mysql_slow_show()

   def mysql_slow_show(self):

       cmd_list=[self.mysqlsla_cmd,self.mysqldumpslow_cmd]

       for i in cmd_list:

               seiri_log=subprocess.Popen(i,shell=True)


本文出自 “原创python发布区” 博客,请务必保留此出处http://cuihailong.blog.51cto.com/2923450/1409565