增加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監控對象時導致數據庫出問題怎么辦”這篇文章的所有內容，感謝各位的閱讀！希望分享的內容對大家有幫助，更多相關知識，歡迎關注億速云行業資訊頻道！