Cacti and rrd (1)

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;