Author:skate
Time:2014/12/15
数据库容量模型设计
下载地址:http://download.csdn.net/detail/wyzxg/8262413
用法:
[root@skatedb55 db_capaticy]# python capacity_model.py --help
usage: Database Capaticy Program usage v0.1 ,(C) Copyright Skate 2014
[-h] --port PORT --iops IOPS --maxlatency MAXLATENCY --minlatency
MINLATENCY [--load LOAD] --device DEVICE
optional arguments:
-h, --help show this help message and exit
--port PORT = the monitor port
--iops IOPS = The database total capaticy
--maxlatency MAXLATENCY
= The maximum response time(microsecond)
--minlatency MINLATENCY
= The best response time of datatase(microsecond)
--load LOAD = The data is loaded into monitor database,eg:
load=user/pass@ip:port:dbname
--device DEVICE = The disk partition
[root@skatedb55 db_capaticy]#
样例:
[root@skatedb55 db_capaticy]# python capacity_model.py --port=3306 --iops=100 --maxlatency=500000 --minlatency=200000 --device=sda
hostname is: skatedb55
IP address is: 10.20.0.55
VIP address is: ['10.20.0.57']
The server performance index:
swap usage: si:3 so:6
iops : bi:0 bo:0
load: 0.00
Reponse max time: 91μs
Reponse avg time: 0μs
Database Capaticy: 0.00% Total Capaticy: 100 iops
Database Capaticy Notes: Database response time is very good!
capture sql log path:/tmp/capacity/log_capturesql_Sql.log
[root@skatedb55 db_capaticy]#
这个数据库的性能容量模型比较简单,大概思路是,首先压测软件测试出系统的性能基线(这里指基于io系统)的iops,这个iops定义为系统性能容量的最大值,
然后结合系统响应时间和动态iops来判断系统的性能容量使用情况,而且会根据tcpdump+pt-query-degist分析当前系统的sql。
依赖
tcpdump
pt-query-degist
tcpstat
python-argparse
需要修改lib.py里相应命令的路径。
这里只是写了个简单的模板,后续会完善它。欢迎高人指点。
-----续-----