這篇文章主要介紹增加cacti監(jiān)控對象時(shí)導(dǎo)致數(shù)據(jù)庫出問題怎么辦，文中介紹的非常詳細(xì)，具有一定的參考價(jià)值，感興趣的小伙伴們一定要看完！
生產(chǎn)環(huán)境：
數(shù)據(jù)庫：mysql 5.5.49-cll-lve
問題：在眾多Cacti監(jiān)控的對象中，由于增加了監(jiān)控對象nginx，導(dǎo)致cacti在監(jiān)控所有對象中僅有1個(gè)對象出圖出數(shù)據(jù)。
分析：
1.systemutilities –>Rebuild poller cache #需要重建cache嗎？
2.系統(tǒng)時(shí)間不準(zhǔn)確，重新設(shè)置時(shí)間 #需要更新服務(wù)器時(shí)間嗎？
3.圖像沒有生成，運(yùn)行
# /usr/bin/php /var/www/html/cacti/poller.php --force #出現(xiàn)數(shù)據(jù)了嗎？
4.權(quán)限問題，修改權(quán)限#chmod 777 -R /var/www/html/cacti/rra #沒有權(quán)限嗎？
5.crontab -e #定時(shí)任務(wù)的問題嗎？
6.數(shù)據(jù)庫表有損壞。#需要修復(fù)數(shù)據(jù)庫嗎？
出現(xiàn)問題之后，我們要通過檢查錯(cuò)誤日志來分析問題所在，請查看附件。
通過查看cacti日志文件，發(fā)現(xiàn)沒有加載有效數(shù)據(jù)，通過修復(fù)cacti數(shù)據(jù)庫解決了出圖出數(shù)據(jù)的問題。
[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監(jiān)控對象時(shí)導(dǎo)致數(shù)據(jù)庫出問題怎么辦”這篇文章的所有內(nèi)容，感謝各位的閱讀！希望分享的內(nèi)容對大家有幫助，更多相關(guān)知識，歡迎關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道！
另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無理由+7*72小時(shí)售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡單易用、服務(wù)可用性高、性價(jià)比高”等特點(diǎn)與優(yōu)勢，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場景需求。
重慶分公司
重慶分公司
