python2.6 监听tomcat io并发量，并记录到数据库

背景：通过python脚本记录下tomcat的io访问量，并记录到数据库，通过数据分析日常访问量

'''
@author: Jacobpc
'''
import os
import time
import datetime
import sys
import threading
import subprocess
import MySQLdb


tomcatprocess="tomcat"
def get_process_id(name):
    child = subprocess.Popen(["pgrep","-f",name],stdout=subprocess.PIPE,shell=False)
    response = child.communicate()[0]
    return response


def gettomcatIoNum():
    tomcatpid = get_process_id(tomcatprocess)        
    print "tomcat pid is %s"%(tomcatpid)     
     
    number = os.popen("lsof -p 4154 | wc -l").read()
    print "io number is %s"%(number)      
    return number




def recordTomcatIo():
    number = gettomcatIoNum()
    dt=datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")  
    
    sql = "insert into cnf_tomcat_io(number,create_date) values ('%s','%s')"%(number,dt)
    print "get data number is %s time is %s"%(number,dt)
    
    db = MySQLdb.connect("11.8.x.x", "name", "password", "database", charset='utf8' )
    cursor = db.cursor()
    try:
        cursor.execute(sql)
        db.commit()
    except:
        # Rollback in case there is any error
        db.rollback()
    db.close()
    print "inert data success"
    global timer 
    timer = threading.Timer(60, recordTomcatIo)
    timer.start()
    


timer = threading.Timer(2,recordTomcatIo)
timer.start()