** Double post; this one can be deleted; please check the newer, more elaborated post here:
Hey there, hope that someone can help me with some pointers where to look at, i don't have all the log files of the event, so i cant bee that specific.
We have a small zabbix server running for quite some time, its hosted on a Ubuntu 24.04.2 LTS; MySQL ; Zabbix version 7.0.7, Running as VM on a Windows Hyper-V.
About 140 hosts monitored; about 10.500 active items; with a nvps of about 50.
The server has been running fine, no problems at all, low io, nice usage, nothing to be concerend about.
But when i was on holiday, suddenly on Sunday the 19th of July roughly between 17:00 and 19:00 our server IO Spiked and basically never returned to normal again.
IO Wait times of 50% or more and that without stopping.
Stopping the zabbix server, didn't lower it instantly; eventually it would drop. Shutting down MySQL; would stop the IO load.
Hey there, hope that someone can help me with some pointers where to look at, i don't have all the log files of the event, so i cant bee that specific.
We have a small zabbix server running for quite some time, its hosted on a Ubuntu 24.04.2 LTS; MySQL ; Zabbix version 7.0.7, Running as VM on a Windows Hyper-V.
About 140 hosts monitored; about 10.500 active items; with a nvps of about 50.
The server has been running fine, no problems at all, low io, nice usage, nothing to be concerend about.
But when i was on holiday, suddenly on Sunday the 19th of July roughly between 17:00 and 19:00 our server IO Spiked and basically never returned to normal again.
IO Wait times of 50% or more and that without stopping.
Stopping the zabbix server, didn't lower it instantly; eventually it would drop. Shutting down MySQL; would stop the IO load.
Code:
[mysqld] user = mysql bind-address = 127.0.0.1 mysqlx-bind-address = 127.0.0.1 key_buffer_size = 16M myisam-recover-options = BACKUP innodb_buffer_pool_size=4G innodb_flush_log_at_trx_commit=2 log_error = /var/log/mysql/error.log slow_query_log = 1 slow_query_log_file = /var/log/mysql/mysql-slow.log long_query_time = 2 max_binlog_size = 100M binlog_expire_logs_seconds = 604800
Code:
ListenPort=10051 LogType=file LogFile=/var/log/zabbix/zabbix_server.log LogFileSize=5 DebugLevel=3 PidFile=/tmp/zabbix_server.pid DBHost=localhost DBName=zabbix DBUser=zabbix DBPassword=supersecret DBPort=3306 StartPollers=10 StartIPMIPollers=0 StartPreprocessors=6 StartPollersUnreachable=10 StartTrappers=6 StartPingers=30 StartDiscoverers=1 StartHTTPPollers=2 StartTimers=2 StartEscalators=2 StartAlerters=2 StartJavaPollers=0 StartVMwareCollectors=0 SNMPTrapperFile=/opt/zabbix/tmp/zabbix_traps.tmp StartSNMPTrapper=1 ListenIP=0.0.0.0 HousekeepingFrequency=1 MaxHousekeeperDelete=5000 CacheSize=64M StartDBSyncers=2 HistoryCacheSize=512M HistoryIndexCacheSize=64M Timeout=30 TrapperTimeout=300 UnreachablePeriod=35 UnavailableDelay=60 UnreachableDelay=15 ExternalScripts=/opt/zabbix/share/zabbix/externalscripts FpingLocation=/usr/sbin/fping Fping6Location=/usr/sbin/fping6 LogSlowQueries=3000 TmpDir=/tmp StartProxyPollers=1 ProxyConfigFrequency=3600 ProxyDataFrequency=60 AllowRoot=0 User=zabbix-srv