5、zabbix-server日志报错,提示connection to database 'zabbix' failed: [1040] Too many connections错误,mariadb正常。想到应该是mysql最大连接数问题。 修改mysql最大连接数的链接:http://blog.51cto.com/net881004/2089198 6、报警提示More than 100 items having missing data for more than 10 minutes和Zabb...
MySQL: Failed to fetch info data Zabbix has not received any data for items for the last 30 minutes. nodata(/MySQL by Zabbix agent/mysql.uptime,30m)=1 Info Depends on: MySQL: Service is down MySQL: Server has aborted connections The number of failed attempts to connect to the MySQL serv...
Monitor whatever you want - Zabbix makes it easy to collect, transform, analyze, and visualize data Partner and vendor-backed Backed by 250+ global partners and multiple external vendors, Zabbix delivers around the globe Integrated with the systems you already use ...
# mysql -uroot -p ##另一台机器同样需要安装mysql; yum install mariadb-devel mariadb-server -y # MariaDB [(none)]> create database zabbix; ##必须事先创建数据库 # MariaDB [(none)]> use zabbix; # MariaDB [zabbix]> source /tmp/zabbix_2017-05-05.sql ##使用source命令比mysql命令恢复...
思路是:考虑到zabbix数据库不是非常庞大,选择mysqldump备份命令对整个zabbix数据库进行完全备份(tar圧缩形式),方便进行恢复,结合crond任务,每日0:00分执行备份脚本,以年月日作为文件名,备份到/var/lib/backup_mysql_zabbix/目录下,因为是全量备份形式的恢复过程,完全可以把30天以前的已备份后数据库的文件都给清除,以...
Be careful when configuring MySQL event scheduler or Crontab. Zabbix will stop collecting data if you misconfigure them! You will notice that by the empty graphs and the error “[Z3005] query failed: [1526] Table has no partition for value ..” in the Zabbix log file. ...
1184:20170701:005045.185 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 解决: find / -name mysql.sock vim /etc/zabbix/zabbix_server.conf #修改一下DBSocket就行 DBSocket=/tmp/mysql.sock system...
Ubuntu安装软件包时报错: Failed to fetch ...deb 问题描述 今天在Ubuntu上安装软件包的时候报错,如下: apt-get install nginx Failed to fetch http://mirrors.aliyuncs.com/ubuntu...cd /var/lib/apt/lists/partial rm ./* apt-get update 然后再次安装软件包 apt-get install nginx ...
MySQL表分区就是将一个大表在逻辑上切分成好几个物理分片。使用MySQL表分区有以下几个好处: 在有些场景下可以明显增加查询性能,特别是对于那些重度使用的表如果是一个单独的分区或者好几个分区就可以明显增加查询性能,因为比起加载整张表的数据到内存,一个分区的数据和索引更容易加载到内存。查看zabbix数据的general...
else: raise Exception(f"Failed to fetch alert config after {self.max_retries} retries.") ...