背景:通过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()