I inherited an (older) Zabbix 3.2.11 installation that has become really slow. It almost makes it unusable. It loads the pages but it takes a really long time. The Zabbix frontend is running on one machine and the MySQL on another one (a shared MySQL instance). I don't know enough about neither Zabbix nor MySQL to find the root cause of the problem. I can see though that the MySQL process is overloaded CPU-wise and that's not a good sign of course.
My colleague is telling me that the problem is that (possibly due to a bug) the housekeeping process on the database is not executed anymore and because of that the db is growing too much. An option would be to start with a fresh one (latest version) and just export the config from the old one to the new one without dragging along the garbage that piled up in the database. But he's also telling me that (according to him) there is no way to just extract the Zabbix config (all the hosts and parameters) from the MySQL db and import it in the new instance.
So the questions are:
- Is there really no way to extract the Zabbix config (hosts, SNMP setting, metrics, alarm thresholds, etc) from the MySQL and import it on a freshly installed Zabbix?
- What tools do I use to find the root cause of the slow page loads on the Zabbix front-end? Are there build in Zabbix performance troubleshooting tools? Or does mySQL has good performance monitoring tools to see where the high (I think abnormal) CPU usage is coming from?
If anyone knows Zabbix/MySQL really well and has time to assist me let me know. I'll pay you of course and the I'll post te solution here afterwards.