在线观看免费看美女视频,杨幂醉酒被强视频在线,搜索美女视频

mycheckpoint MySQL監(jiān)控工具

cacti也可以監(jiān)控mysql的一些性能參數(shù)畫出圖,但是無法自定義時間或者其他條件產(chǎn)生報表.mycheckpoint 可以作為替代監(jiān)控mysql性能的工具,并且安裝使用都非常簡單.圖標(biāo)也比cacti漂亮..

mycheckpoint 文檔地址:

http://code.openark.org/forge/mycheckpoint/documentation

需要的環(huán)境. python 2.4 以上 MySQL-python 庫,其他就不需要了.

安裝包和庫

ez_setup.py MYSQL-python

tar xf mycheckpoint-xx.tar.gz

cd mycheckpoint-xx

python setup.py build

python setup.py install

配置:(此處監(jiān)控2個主機(jī),一個是主一個是從,已經(jīng)建立同步關(guān)系.同步所有數(shù)據(jù)庫)

建立監(jiān)控環(huán)境:

on master：

mysql>create database checke_slave;
mysql>create database checke_master;
mysql> grant all privileges on check_slave.* to checker@'192.168.%.%' identified by '123';flush privileges;
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on check_master.* to checker@'192.168.%.%' identified by '123';flush privileges;
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

初始化監(jiān)控的庫和表

on master:

mycheckpoint --host=192.168.128.129 -u checker -p 123 -S /tmp/mysql.sock --database=check_master deploy
mycheckpoint --monitored-host=192.168.128.128 --monitored-user=checker --monitored-password=123 -S /tmp/mysql.sock --monitored-port=3306 --database=check_slave deploy

授權(quán)監(jiān)控賬號：

mysql> grant replication slave,replication client,super,process on *.* to checker@'192.168.%.%';

建立配置文件(可選項,可以將命令行里的參數(shù)寫在這個配置文件里.)
/etc/mycheckpoint.cnf

[mycheckpoint]
smtp_host = mail.my-server-company.com
smtp_from = monitor@my-server-company.com
smtp_to = dba@my-server-company.com
monitored_port = 3306
purge_days = 60
#... Any command line option can go here; replace dash ("-") with underscored ("_")

[client]
user=dbmonitor
password=123456
socket=/tmp/mysql.sock
port=3306
host=localhost

開始抓取數(shù)據(jù).(加入cron里,5分鐘一次)

on master:

*/5 * * * * mycheckpoint --host=192.168.128.129 -u checker -p 123 -S /tmp/mysql.sock --database=check_master
*/5 * * * * mycheckpoint --monitored-host=192.168.128.128 --monitored-user=checker --monitored-password=123 -S /tmp/mysql.sock --monitored-port=3306 --database=check_slave

開啟展示數(shù)據(jù)的http server 默認(rèn)端口為12306 可以用 --http-port 另外指定.

mycheckpoint --host=192.168.128.129 -u checker -p 123 -S /tmp/mysql.sock --database=check_master http

測試訪問,(有可能前一個小時左右沒有圖出來.)

http://192.168.128.129:12306/check_master#Resources

用sql產(chǎn)生自定義報表

mysql> select DML from sv_report_chart_hour ;    （按小時的畫出的數(shù)據(jù)庫執(zhí)行DML語句的數(shù)據(jù)圖）
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| DML                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| http://chart.apis.google.com/chart?cht=lc&chs=370x180&chts=303030,12&chtt=Latest+1+days:+Sep+14,+11:00++-++Sep+15,+17:00&chf=c,s,ffffff&chdl=com_select_psec|com_insert_psec|com_delete_psec|com_update_psec|com_replace_psec&chdlp=b&chco=ff8c00,4682b4,9acd32,dc143c,9932cc&chd=s:QQQRQRQQ9oQQQQQQQQQQQQQQQQQhbRR,LLLLLLLLLLLLLLLLLLLLLLLLLLLQMMM,LLLLLLLLLLLLLLLLLLLLLLLLLLLMMMM,BBBBBBBBBBBBBBBBBBBBBBBBBBBHCCC,AAAAAAAAAAAAAAAAAAAAAAAAAAADAAA&chxt=x,y&chxr=1,0,8.22&chxl=0:|15th|&chxs=0,505050,10,0,lt&chg=80.00,25,1,2,43.33,0&chxp=0,43.33 | 
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (1.48 sec)

生成html報表:
mysql -uroot -pxxx checker_master -e "SELECT html FROM sv_report_html_brief" --silent --raw > /tmp/mycheckpoint_report.html

本站僅提供存儲服務(wù)，所有內(nèi)容均由用戶發(fā)布，如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容，請點擊舉報。

国产一级a片免费看高清,亚洲熟女中文字幕在线视频,黄三级高清在线播放,免费黄色视频在线看

mycheckpoint MySQL監(jiān)控工具