Python 获取CentOS7的内存使用率并写入mysql
由于Centos7和6的系统变化挻大的，所以先看看Centos7的内存信息是怎么样的。
系统版本：
|
1
2
3
|
[root@docker ~]
# cat /etc/redhat-release
CentOS Linux release 7.2.1511 (Core)
[root@docker ~]
#
|
查看内存信息：其实只需要关注前5行即可；
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
|
[root@docker ~]
# cat /proc/meminfo
MemTotal: 2049248 kB
MemFree: 85408 kB
MemAvailable: 1061812 kB
Buffers: 138044 kB
Cached: 885028 kB
SwapCached: 33308 kB
Active: 881088 kB
Inactive: 832516 kB
Active(anon): 315948 kB
Inactive(anon): 375464 kB
Active(
file
): 565140 kB
Inactive(
file
): 457052 kB
Unevictable: 0 kB
Mlocked: 0 kB
SwapTotal: 524284 kB
SwapFree: 377836 kB
Dirty: 24 kB
Writeback: 0 kB
AnonPages: 659500 kB
Mapped: 71544 kB
Shmem: 876 kB
Slab: 160772 kB
SReclaimable: 123148 kB
SUnreclaim: 37624 kB
KernelStack: 7408 kB
PageTables: 20580 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
WritebackTmp: 0 kB
CommitLimit: 1548908 kB
Committed_AS: 2998548 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 156648 kB
VmallocChunk: 34359541760 kB
HardwareCorrupted: 0 kB
AnonHugePages: 434176 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize: 2048 kB
DirectMap4k: 73664 kB
DirectMap2M: 2023424 kB
DirectMap1G: 0 kB
[root@docker ~]
#
[root@docker ~]
# free -m
total used
free
shared buff
/cache
available
Mem: 2001 762 81 0 1156 1035
Swap: 511 142 369
[root@docker ~]
#
|
内存使用率的计算：mem_used=MemTotal-MemFree-Buffers
python 代码：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
#/usr/bin/env python
import
time
import
pymysql as mysql
db = mysql.connect(user=
'dba'
,
passwd
=
'123456'
,db=
'memory'
,host=
'localhost'
)
db.autocommit(True)
cur = db.cursor()
def getMem():
f =
open
(
'/proc/meminfo'
)
total = int(f.readline().
split
()[1])
free
= int(f.readline().
split
()[1])
MemAvailable = f.readline().
split
()
cache = int(f.readline().
split
()[1])
mem_use = total-
free
-cache
t =
time
.
time
()
sql =
'insert into memory(memory,time) values(%s,%s)'
%(mem_use
/1024
,t)
cur.execute(sql)
#print mem_use
print (
'ok'
)
while
True:
time
.
sleep
(1)
getMem()
|
安装pymysql模块
|
1
|
pip
install
pymysql
|
创建数据库以及表：
|
1
2
3
4
5
6
7
|
MariaDB [(none)]> create database memory charset=utf8;
MariaDB [(none)]> use memory;
MariaDB [(none)]> CREATE TABLE `memory` ( `memory` int(11) DEFAULT NULL, `
time
` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
授权用户
MariaDB [(none)]> grant all on *.* to dba@
'localhost'
identified by
'123456'
;
MariaDB [(none)]> flush privileges;
|
执行python代码，每隔一秒就会打印一个ok到终端，然后在Mysql里查询一下；
|
1
2
3
4
5
6
7
8
9
10
11
|
MariaDB [memory]>
select
* from memory limit 5;
+--------+------------+
| memory |
time
|
+--------+------------+
| 1775 | 1513906229 |
| 1775 | 1513906230 |
| 1775 | 1513906231 |
| 1775 | 1513906232 |
| 1775 | 1513906233 |
+--------+------------+
5 rows
in
set
(0.00 sec)
|
注：Mysql的表只用了两个字段，一个内存使用率，这个值是以兆为单位的，另一个就是时间了。
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
MariaDB [(none)]> use memory;
Reading table information
for
completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [memory]> show create table memory\G
*************************** 1. row ***************************
Table: memory
Create Table: CREATE TABLE `memory` (
`memory` int(11) DEFAULT NULL,
`
time
` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
1 row
in
set
(0.00 sec)
MariaDB [memory]>
|
本文转自 dengaosky 51CTO博客，原文链接：http://blog.51cto.com/dengaosky/2053186，如需转载请自行联系原作者
