CactiIt is a network traffic monitoring system, which is very useful. Who knows it! The following describes cacti,RrdRelated
Cacti Database
1. Structure
Host table
Data_local data table
Data_template data template table
Data_template_data data info table
2. Relationship
'Host'. 'id' is associated with 'data _ local'. 'Host _ id'
'Data _ local', 'Data _ tempate_data '. data_template_id is associated with 'data _ template'. id
'Data _ template_data '. local_data_id and 'data _ local'. id
3. Role
Based on the above information, you can find all RRA file information of any given host.
4. Example
Select dl. id, dl. data_template_id, dt. name, dl. host_id, host. hostname, dl. snmp_query_id, dl. snmp_index, dtd. data_template_id, dtd. data_input_id, dtd. data_source_path, dtd. name_cache from data_local as dl, host, data_template as dt, data_template_data as dtd where dl. host_id = {$ host_id} and dl. host_id = host. id and dt. id = dl. data_template_id and dl. id = dtd. local_data_id;