Database problems caused by increased cacti monitoring objects

Production environment:

Database: MySQL 5.5.49-cll-lve

Problem: In many cacti monitoring objects, because of the addition of the monitoring object nginx, resulting in cacti in the monitoring of all objects only 1 objects out of the graph data.

Analysis:

1.systemutilities–>rebuild poller Cache #需要重建cache吗?
2. System time is not accurate, reset time #需要更新服务器时间吗?
3. Image not generated, run

#/usr/bin/php/var/www/html/cacti/poller.php--force #出现数据了吗?
4. Permissions issues, modify permissions #chmod 777-r/var/www/html/cacti/rra #没有权限吗?
5.crontab-e #定时任务的问题吗?

6. The database table is corrupt. #需要修复数据库吗?

After the problem occurs, we want to check the error log to analyze the problem, please check the attachment.

by viewing the cacti log file, it was found that no valid data was loaded and the problem of figure out data was resolved by repairing the cacti database.

[Email protected] sky]# Mysqlcheck--auto-repair--databases cacti-p

Enter Password:

Cacti.cdef OK

Cacti.cdef_items OK

Cacti.colors OK

Cacti.data_input OK

Cacti.data_input_data

Warning:2 clients is using or haven ' t closed the table properly

Status:ok

Cacti.data_input_fields OK

Cacti.data_local

Warning:3 clients is using or haven ' t closed the table properly

Status:ok

Cacti.data_template OK

Cacti.data_template_data

Warning:3 clients is using or haven ' t closed the table properly

Status:ok

Cacti.data_template_data_rra

Warning:2 clients is using or haven ' t closed the table properly

Status:ok

Cacti.data_template_rrd

Warning:2 clients is using or haven ' t closed the table properly

Status:ok

Cacti.graph_local

Warning:3 clients is using or haven ' t closed the table properly

Status:ok

Cacti.graph_template_input OK

Cacti.graph_template_input_defs OK

Cacti.graph_templates OK

Cacti.graph_templates_gprint OK

Cacti.graph_templates_graph

Warning:3 clients is using or haven ' t closed the table properly

Status:ok

Cacti.graph_templates_item

Warning:2 clients is using or haven ' t closed the table properly

Status:ok

Cacti.graph_tree

Warning:1 client is using or hasn ' t closed the table properly

Status:ok

Cacti.graph_tree_items

Warning:1 client is using or hasn ' t closed the table properly

Status:ok

Cacti.host

Warning:9 clients is using or haven ' t closed the table properly

Status:ok

Cacti.host_graph OK

Cacti.host_snmp_cache

Warning:9 clients is using or haven ' t closed the table properly

Status:ok

Cacti.host_snmp_query OK

Cacti.host_template OK

Cacti.host_template_graph OK

Cacti.host_template_snmp_query OK

Cacti.plugin_config

Warning:1 client is using or hasn ' t closed the table properly

Status:ok

Cacti.plugin_db_changes

Warning:1 client is using or hasn ' t closed the table properly

Status:ok

Cacti.plugin_discover_hosts

Warning:5 clients is using or haven ' t closed the table properly

Status:ok

Cacti.plugin_discover_template OK

Cacti.plugin_hooks

Warning:1 client is using or hasn ' t closed the table properly

Status:ok

Cacti.plugin_notification_lists OK

Cacti.plugin_realms

Warning:1 client is using or hasn ' t closed the table properly

Status:ok

Cacti.plugin_thold_contacts OK

Cacti.plugin_thold_host_failed OK

Cacti.plugin_thold_log

Warning:7 clients is using or haven ' t closed the table properly

Status:ok

Cacti.plugin_thold_template_contact OK

Cacti.plugin_thold_threshold_contact OK

Cacti.poller OK

Cacti.poller_command

Warning:9 clients is using or haven ' t closed the table properly

Status:ok

Cacti.poller_item

Warning:9 clients is using or haven ' t closed the table properly

Status:ok

Cacti.poller_output OK

Cacti.poller_output_rt

Warning:1 client is using or hasn ' t closed the table properly

Status:ok

Cacti.poller_reindex

Warning:9 clients is using or haven ' t closed the table properly

Status:ok

Cacti.poller_time OK

Cacti.rra OK

CACTI.RRA_CF OK

Cacti.settings

Warning:9 clients is using or haven ' t closed the table properly

Status:ok

Cacti.settings_graphs OK

Cacti.settings_tree OK

Cacti.snmp_query OK

Cacti.snmp_query_graph OK

CACTI.SNMP_QUERY_GRAPH_RRD OK

CACTI.SNMP_QUERY_GRAPH_RRD_SV OK

CACTI.SNMP_QUERY_GRAPH_SV OK

Cacti.syslog OK

Cacti.syslog_alert OK

Cacti.syslog_facilities OK

Cacti.syslog_host_facilities OK

Cacti.syslog_hosts OK

Cacti.syslog_incoming OK

Cacti.syslog_logs OK

Cacti.syslog_priorities OK

Cacti.syslog_remove OK

Cacti.syslog_removed OK

Cacti.syslog_reports OK

Cacti.syslog_statistics OK

Cacti.thold_data

Warning:9 clients is using or haven ' t closed the table properly

Status:ok

Cacti.thold_template OK

Cacti.user_auth OK

Cacti.user_auth_perms OK

Cacti.user_auth_realm

Warning:1 client is using or hasn ' t closed the table properly

Status:ok

Cacti.user_log

Warning:8 clients is using or haven ' t closed the table properly

Status:ok

Cacti.version OK

Utilities Utilities

This article is from the "sky9890" blog, make sure to keep this source http://sky9896.blog.51cto.com/2330653/1794426

Database problems caused by increased cacti monitoring objects