完整的 cacti监控数据库占用空间的模板
ok前面基本就成可以监控database的占用空间了，只是一个小小的功能，希望能够帮助大家学习cacti这里放上完整的内容，包括php query的xml以及 cacti的模板，具体安装见附件的 readme
模板：
Get MySql DataBase Usage
Get MySql DataBase Usage from php query
<path_cacti>/resource/script_queries/flashapp_mysql_space.xml
hash_03002480e9e4c4191a5da189ae26d0e237f015
get mysql database space by php script query
hash_000024c3bd011b048a0376ca06e2937624becc
hrDataBasesSize
hash_010024750c86d980a785aa8e56cf52a564b52f
hash_08002462c34e48d9ac2f34d76d3ded5a4f6769
title
1
|host_description| - Database Usage - |query_hrDataBasesDescr|
name
hash_010024750c86d980a785aa8e56cf52a564b52f
1
|host_description| - Database Usage - |query_hrDataBasesDescr|
Get Script Data (Indexed)
4
Index Type
index_type
in
index_type
Index Value
index_value
in
index_value
Output Type ID
output_type
in
output_type
Output Value
on
out
output
flashapp - MySQL - Database Usage
|host_description| - Mysql Database Usage- |query_hrDataBasesDescr|
1
120
500
on
on
2
on
on
100
0
1000
hash_08002462c34e48d9ac2f34d76d3ded5a4f6769
FF5F00
FF
7
1
0
hash_060024e9c43831e54eca8069317a2ce8c6f751
Disk Usage
1
Data Source
task_item_id
hash_0000243d73e23783f325147d26107b8ad900f7
flashapp - Get MySql Database usage
on
|host_description| - MySql Space -|query_hrDataBasesDescr|
hash_03002480e9e4c4191a5da189ae26d0e237f015
300
on
hash_150024c21df5178e5c955013591239eb0afd46|hash_1500240d9c0af8b8acdc7807943937b3208e29|hash_1500246fc2d038fb42950138b0ce3e9874cc60|hash_150024e36f3adb9f152adfa5dc50fd2b23337e
database_space
0
0
1
600
0
hash_07002474af2e42dc12956c4817c2ef5d9983f9
on
hash_0700243b7caa46eb809fc238de6ef18b6e10d5
on
hash_070024d39556ecad6166701bfb0e28c5a11108
on
Daily (5 Minute Average)
0.5
1
600
86400
1|3
Weekly (30 Minute Average)
0.5
6
700
604800
1|3
Monthly (2 Hour Average)
0.5
24
775
2678400
1|3
Yearly (1 Day Average)
0.5
288
797
33053184
1|3
Normal
%8.2lf %s
页:
[1]