Hi.
I've just upgraded a rather busy Zabbix 5.2 instance (with 2 proxies) to 6.0.1. We also had to upgrade MariaDB from 10.1.48 to 10.6. Upgrade went smooth for both DB and Zabbix itself, with few small exceptions quiclky resolved.
Unfortunately, after import we're experiencing problems with the database: a lot of queries are extremely slow. Inserts to `history_uint` can take up to 30s.
Probably as a consequence, nearly all agents are reported as offline. I have checked the release notes but didn't find anything useful.
On the server, top shows a lot of IO usage. Other than moving the server on a faster storage, is there anything I can do, maybe on the DB?
Thanks
These are top table sizes:
I've just upgraded a rather busy Zabbix 5.2 instance (with 2 proxies) to 6.0.1. We also had to upgrade MariaDB from 10.1.48 to 10.6. Upgrade went smooth for both DB and Zabbix itself, with few small exceptions quiclky resolved.
Unfortunately, after import we're experiencing problems with the database: a lot of queries are extremely slow. Inserts to `history_uint` can take up to 30s.
Probably as a consequence, nearly all agents are reported as offline. I have checked the release notes but didn't find anything useful.
On the server, top shows a lot of IO usage. Other than moving the server on a faster storage, is there anything I can do, maybe on the DB?
Thanks
These are top table sizes:
Code:
| Table | Size (MB) | | history_uint | 44166 | | trends_uint | 10926 | | history | 4948 | | trends | 2219 | | events | 712 | | history_str | 297 | | history_log | 204 | | event_recovery | 179 |
Comment