Troubleshooting a slow Zabbix installation
Hi,
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.
Thanks!
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.
Thanks!
ASKER
Hi John,
My colleague tried that. But he told me importing it gives a lot of errors. We'll try it again and see what errors come out.
Thanks!
My colleague tried that. But he told me importing it gives a lot of errors. We'll try it again and see what errors come out.
Thanks!
ASKER
The problem seems to be when we export the db using a mysql dump the export it seems to never end even if we wait 24 hours.
A way to export only the config using the web front-end is nowhere described as far as I can find.
1. Is there a way we can find out why the Zabbix front-end is so slow in the first place? Maybe it has nothing to do with the MySQL
2. Is it possible what my colleague is claiming that the housekeeping job hasn't run for a long time and because of that the database is blowing up? How do I check whether the housekeeping job has been running (or when it was the last time)? Can I start it manually?
A way to export only the config using the web front-end is nowhere described as far as I can find.
1. Is there a way we can find out why the Zabbix front-end is so slow in the first place? Maybe it has nothing to do with the MySQL
2. Is it possible what my colleague is claiming that the housekeeping job hasn't run for a long time and because of that the database is blowing up? How do I check whether the housekeeping job has been running (or when it was the last time)? Can I start it manually?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You mean enabling slow query log on the MySQL right? Or on the Zabbix?
MySQL for sure.
ASKER
OK, I'll try to find the way to enable the slow queries at the MySQL level. I have to look it up.
The other question is: How can I check my colleagues claim that the housekeeping process is the reason for the database to blow up. How can I know for sure that the housekeeping process is not running properly and how can I be sure that is the reason the database is blowing up? Its over 1 TB now.
The other question is: How can I check my colleagues claim that the housekeeping process is the reason for the database to blow up. How can I know for sure that the housekeeping process is not running properly and how can I be sure that is the reason the database is blowing up? Its over 1 TB now.
ASKER
@John: I tried the export/import. But you can only export Templates and hosts and doing the import on the new zabbix install is generating a lot of errors of items he can't find. So I'm stuck there.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Dear Author,
Please respond to the last comment and // or provide more inputs. The question is moving to auto close splitting the points in poarticipants.
Please respond to the last comment and // or provide more inputs. The question is moving to auto close splitting the points in poarticipants.
Furthermore ...as i guessed it relies on agent ...i guess this is the missing piece ..as how easy is to reconfigure them to talk to the correct server