这篇文章主要介绍增加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 -pEnter password:cacti.cdef OKcacti.cdef_items OKcacti.colors OKcacti.data_input OKcacti.data_input_datawarning: 2 clients are using or haven’t closed the table properlystatus: OKcacti.data_input_fields OKcacti.data_localwarning: 3 clients are using or haven’t closed the table properlystatus: OKcacti.data_template OKcacti.data_template_datawarning: 3 clients are using or haven’t closed the table properlystatus: OKcacti.data_template_data_rrawarning: 2 clients are using or haven’t closed the table properlystatus: OKcacti.data_template_rrdwarning: 2 clients are using or haven’t closed the table properlystatus: OKcacti.graph_localwarning: 3 clients are using or haven’t closed the table properlystatus: OKcacti.graph_template_input OKcacti.graph_template_input_defs OKcacti.graph_templates OKcacti.graph_templates_gprint OKcacti.graph_templates_graphwarning: 3 clients are using or haven’t closed the table properlystatus: OKcacti.graph_templates_itemwarning: 2 clients are using or haven’t closed the table properlystatus: OKcacti.graph_treewarning: 1 client is using or hasn’t closed the table properlystatus: OKcacti.graph_tree_itemswarning: 1 client is using or hasn’t closed the table properlystatus: OKcacti.hostwarning: 9 clients are using or haven’t closed the table properlystatus: OKcacti.host_graph OKcacti.host_snmp_cachewarning: 9 clients are using or haven’t closed the table properlystatus: OKcacti.host_snmp_query OKcacti.host_template OKcacti.host_template_graph OKcacti.host_template_snmp_query OKcacti.plugin_configwarning: 1 client is using or hasn’t closed the table properlystatus: OKcacti.plugin_db_changeswarning: 1 client is using or hasn’t closed the table properlystatus: OKcacti.plugin_discover_hostswarning: 5 clients are using or haven’t closed the table properlystatus: OKca免费主机域名cti.plugin_discover_template OKcacti.plugin_hookswarning: 1 client is using or hasn’t closed the table properlystatus: OKcacti.plugin_notification_lists OKcacti.plugin_realmswarning: 1 client is using or hasn’t closed the table properlystatus: OKcacti.plugin_thold_contacts OKcacti.plugin_thold_host_failed OKcacti.plugin_thold_logwarning: 7 clients are using or haven’t closed the table properlystatus: OKcacti.plugin_thold_template_contact OKcacti.plugin_thold_threshold_contact OKcacti.poller OKcacti.poller_command免费主机域名warning: 9 clients are using or haven’t closed the table properlystatus: OKcacti.poller_itemwarning: 9 clients are using or haven’t closed the table properlystatus: OKcacti.poller_output OKcacti.poller_output_rtwarning: 1 client is using or hasn’t closed the table properlystatus: OKcacti.poller_reindexwarning: 9 clients are using or haven’t closed the table properlystatus : OKcacti.poller_time OKcacti.rra OKcacti.rra_cf OKcacti.settingswarning: 9 clients are using or haven’t closed the table properlystatus: OKcacti.settings_graphs OKcacti.settings_tree OKcacti.snmp_query OKcacti.snmp_query_graph OKcacti.snmp_query_graph_rrd OKcacti.snmp_query_graph_rrd_sv OKcacti.snmp_query_graph_sv OKcacti.syslog OKcacti.syslog_alert OKcacti.syslog_facilities OKcacti.syslog_host_facilities OKcacti.syslog_hosts OKcacti.syslog_incoming OKcacti.syslog_logs OKcacti.syslog_priorities OKcacti.syslog_remove OKcacti.syslog_removed OKcacti.syslog_reports OKcacti.syslog_statistics OKcacti.thold_datawarning: 9 clients are using or haven’t closed the table properlystatus: OKcacti.thold_template OKcacti.user_auth OKcacti.user_auth_perms OKcacti.user_auth_realmwarning: 1 client is using or hasn’t closed the table properlystatus: OKcacti.user_logwarning: 8 clients are using or haven’t closed the table properlystatus: OKcacti.version OK以上是“增加cacti监控对象时导致数据库出问题怎么办”这篇文章的所有内容,感谢各位的阅读!希望分享的内容对大家有帮助,更多相关知识,欢迎关注云技术行业资讯频道!
这篇文章主要讲解了“oracle数据库CPU过高问题分析”,文中的讲解内容简单清晰,易于学习与理解,下面请大家跟着小编的思路慢慢深入,一起来研究和学习“oracle数据库CPU过高问题分析”吧!一、执行一条sql查询免费主机域名无索引的大表,使服务器一核CPU…