完整的 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 [database_space]

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