Python writes system memory usage to MySQL database

1. Prerequisites for creating database and tabular format

[Email protected] ~]# Mysql-uroot-pcentos

mysql> CREATE database memory;

mysql> use memory;

Mysql> CREATE TABLE memory (memory int,time varchar (50));

2. Write the system Use_mem memory to the database every second sleep

[email protected] ~]# cat mem.py

#!/usr/bin/env python

#-*-Coding:utf-8-*-

Import Time #导入时间模块

Import mysqldb as MySQL #导入MySQLdb模块

Db=mysql.connect (user= ' root ', passwd= ' CentOS ', db= ' memory ', host= ' localhost ') #连接数据库

Cursor=db.cursor () #创建游标对象

Def getmem ():

f = open ('/proc/meminfo ')

Total = Int (F.readline (). Split () [1])

free = Int (F.readline (). Split () [1])

buffer = Int (F.readline (). Split () [1])

cache = Int (F.readline (). Split () [1])

mem_used = Total-free-buffer-cache

Cur_time =time.strftime ('%y%m%d%h%m%s ', Time.localtime (Time.time ()))

sql = ' INSERT INTO memory ' (memory, Time) value (%s,%s) '% (mem_used,cur_time)

Cursor.execute (SQL) #执行sql语句

print ' OK '

While True:

Getmem ()

Time.sleep (1) # sleep 1 Second

3. Execute the script to view the database

Python writes system memory usage to MySQL database