增加cacti监控对象时导致数据库出问题怎么办-创新互联

这篇文章主要介绍增加cacti监控对象时导致数据库出问题怎么办，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！

生产环境：

数据库：mysql 5.5.49-cll-lve

问题：在众多Cacti监控的对象中，由于增加了监控对象nginx，导致cacti在监控所有对象中仅有1个对象出图出数据。

分析：

1.systemutilities –>Rebuild poller cache #需要重建cache吗？
2.系统时间不准确，重新设置时间  #需要更新服务器时间吗？
3.图像没有生成，运行

# /usr/bin/php /var/www/html/cacti/poller.php --force #出现数据了吗？
4.权限问题，修改权限#chmod 777 -R /var/www/html/cacti/rra #没有权限吗？
5.crontab -e  #定时任务的问题吗？

6.数据库表有损坏。#需要修复数据库吗？

 出现问题之后，我们要通过检查错误日志来分析问题所在，请查看附件。

通过查看cacti日志文件，发现没有加载有效数据，通过修复cacti数据库解决了出图出数据的问题。

[root@sky9896 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 are using or haven't closed the table properly

status  : OK

cacti.data_input_fields                           OK

cacti.data_local

warning : 3 clients are using or haven't closed the table properly

status  : OK

cacti.data_template                               OK

cacti.data_template_data

warning : 3 clients are using or haven't closed the table properly

status  : OK

cacti.data_template_data_rra

warning : 2 clients are using or haven't closed the table properly

status  : OK

cacti.data_template_rrd

warning : 2 clients are using or haven't closed the table properly

status  : OK

cacti.graph_local

warning : 3 clients are 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 are using or haven't closed the table properly

status  : OK

cacti.graph_templates_item

warning : 2 clients are 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 are using or haven't closed the table properly

status  : OK

cacti.host_graph                                  OK

cacti.host_snmp_cache

warning : 9 clients are 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 are 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 are 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 are using or haven't closed the table properly

status  : OK

cacti.poller_item

warning : 9 clients are 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 are 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 are 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 are 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 are using or haven't closed the table properly

status  : OK

cacti.version                                     OK

以上是“增加cacti监控对象时导致数据库出问题怎么办”这篇文章的所有内容，感谢各位的阅读！希望分享的内容对大家有帮助，更多相关知识，欢迎关注创新互联行业资讯频道！

另外有需要云服务器可以了解下创新互联cdcxhl.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。