Re: [Zabbix-users] Zabbix 3.4.3 / MySQL 5.7.2 Stops after 30mins

[Fernando C. P. <fer...@al...>]

Good Morning,

 I think that mysqlturner is  not the best way to optimize zabbix database.
 People from Percona wrote a very good article.

https://www.percona.com/blog/2014/11/14/optimizing-mysql-zabbix/

Maybe it could help you.


----- Original Message -----
From: Guus Snijders <gsn...@gm...>
To: Ellis, Merphis <Mer...@us...>
Cc: zabbix-users <zab...@li...>
Sent: Sat, 28 Oct 2017 22:06:48 +0200 (CEST)
Subject: 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...
>:

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 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

-- 
Fernando Collado Permuy
 Allenta Consulting (+34 881 922 600)ISO 9001, ISO 14001, ISO 27001, EMAS
 Privacidad / Privacy