Zabbix使用Python3.7实现MySQ监控脚本

Python版本 

# python -V
Python 3.7.4

Python3中用pymysql替代了Python2版本的MySQLdb

下载pymysql库

# pip3 install pymysql

命令行使用脚本

#!/usr/bin/env python
# _*_ coding: utf-8 _*_

import pymysql

# 连接mysql用到的4个主要对象
host = 'localhost'
user = 'root'
passwd = '123456'
db = 'test'

# 定义执行的sql语句
Com_insert = "show global status like 'Com_insert';"
Com_update = "show global status like 'Com_update';"
Com_select = "show global status like 'Com_select';"
Com_delete = "show global status like 'Com_delete';"
Com_commit = "show global status like 'Com_commit';"
Open_tables = "show global status like 'Open_tables';"
Qcache_hits = "show global status like 'Qcache_hits';"
Slow_queri