Menu
▾
▴
Re: [Zabbix-users] Zabbix 3.4.3 / MySQL 5.7.2 Stops after 30mins
|
From: Kim C. <kc...@po...> - 2017-10-29 07:36:57
|
Fra: Guus Snijders [mailto:gsn...@gm...] Sendt: 28. oktober 2017 22:07 Til: Ellis, Merphis <Mer...@us...> Cc: zabbix-users <zab...@li...> Emne: Re: [Zabbix-users] Zabbix 3.4.3 / MySQL 5.7.2 Stops after 30mins Op 28 okt. 2017 20:47 schreef "Ellis, Merphis" <Mer...@us...<mailto:Mer...@us...>>: Good Morning I am having a strange problem with a new Zabbix 3.4.3 install. After 30 mins it seems the Zabbix server stops updating the database. [...] I have use the mysqltuner.pl<http://mysqltuner.pl> to make adjustments in the my.cnf. I can login to the database after the Zabbix starts failing. If I restart the Zabbix server it starts back working, if I restart the MySQL there is no change. The only error message I have found is in the mysql.log file: [Note] Aborted connection 19 to db: 'zabbix' user: 'zabbix' host: 'localhost' (Got an error reading communication packets) Not knowing too much about mysql config, but it looks like mysqltuner broke the configuration (obviously). One way of going about would to use diff to see the differences between the original config and the tuner's. Maybe the tuner tool was kind enough to log it's changes? That might also work. My best guess would be that $tuner optimised the config for a certain kind of usage (number of connections, kind of connections (long/short connections, timeouts)), whereas Zabbix's differs from that. Judging by the error text, it looks like both programs using different protools, but then the 30 minutes doesn't make sense. I'm guessing some time out error or suchlike. Mvg, Guus Snijders Take a look at this link. https://www.percona.com/blog/2016/05/16/mysql-got-an-error-reading-communication-packet-errors/ My guess is that your zabbix have to many open connections to the MySql server. Med venlig hilsen/Best regards Kim Christensen Systemkonsulent København · Korsør · Herning Telefon 70 22 32 35 · www.powernet.dk<http://www.powernet.dk/> [cid:image004.jpg@01D0405A.0A65C360] |
