For the database and daily inspection system系统及数据库日常巡检
1.
系统信息
python dba_tool.py
DBA tools
Hostname |vm2
Uptime |17:10:19 up 1 day
IP Addr |127.0.0.1
IP Addr |192.168.137.11
Memory |989 MB
Platform |CentOS release 6.2 (Final)
CPU Cores |1
CPU ModelName |Intel(R) Core(TM) i3-4150 CPU @ 3.50GHz
FS:/boot |428M of free 485M
FS:/work |8.2G of free 20G
FS:/ |3.2G of free 18G
2.
MySQL QPS/TPS/ins/upd/del
thread:run/connect/create/cache
slow:slow_sql/tmp table/disk tmp table
bytes: Bytes_received/Bytes_sent
python dba_tool.py -info mysql
DBA tools:192.168.137.11
---------+-------mysql-status-------+-----threads-----+-----slow-----+----bytes-------
time | QPS TPS ins upd del| run con cre cac| sql tmp Dtmp| recv send
---------+--------------------------+-----------------+--------------+----------------
17:03:09 | 6 0 0 0 0 | 3 14 32 18 | 0 3 0 | 3.347K 1.838K
17:03:11 | 9 0 0 0 0 | 3 14 32 18 | 0 3 0 | 2.64K 1.555K
17:03:14 | 6 0 0 0 0 | 3 14 32 18 | 0 3 0 | 2.292K 1.416K
17:03:16 | 6 0 0 0 0 | 3 14 32 18 | 0 3 0 | 3.336K 1.833K
17:03:19 | 9 0 0 0 0 | 3 14 32 18 | 0 3 0 | 2.391K 1.421K
17:03:21 | 6 0 0 0 0 | 3 14 32 18 | 0 3 0 | 3.336K 1.833K
17:03:24 | 6 0 0 0 0 | 3 14 32 18 | 0 3 0 | 1.248K 999B