Need help with Zabbix upgrade issues: High CPU and page break problems

[Eznat]

Hello Zabbix Community,

I'm currently facing some challenges while upgrading Zabbix at both the central and distributed sites. I would greatly appreciate your expertise and guidance in resolving these issues.

At the central site, the goal is to upgrade from Zabbix 5.0 to 6.0 on RHEL 8. However, during the upgrade process, I encountered the following problems:

1. Character set and collation issue during the import of the old Zabbix 5.0 database into Zabbix 6.0, resulting in high CPU usage and multiple page breaks.
3. Dumping the Mariadb database from Zabbix 5.0 and restoring it to MySQL on the upgraded RHEL 8 node did not resolve the high CPU usage and host page problems.

Similarly, at the distributed site, where the upgrade is from Zabbix 3.0 to 6.0 on RHEL 8, I faced the following challenges:

1. Importing the old Zabbix 3.0 database into Zabbix 6.0 encountered a character set and collation issue, leading to high CPU usage and multiple page breaks.
2. Step-by-step upgrading to Zabbix 6.0 from Zabbix 3.0 resulted in high CPU usage and host page problems. Additionally, importing hosts, templates, and host groups from Zabbix 6.0 failed due to multiple sub-templates.
3. Dumping the Mariadb database from Zabbix 3.0 and restoring it to MySQL on the upgraded RHEL 8 node did not resolve the high CPU usage and host page problems.

We have already tried troubleshooting steps such as migrating the database from network storage to local storage, adjusting MySQL parameters, and increasing resources on the Zabbix VMs. While these actions improved performance to some extent, the issues persist.

Could you please help me with the following questions:

1. How can I address the character set and collation issue during the import process?
2. What steps can I take to resolve the high CPU usage and host page problems after upgrading and restoring the databases?
3. Is there a recommended approach for importing hosts, templates, and host groups with multiple sub-templates in Zabbix 6.0?

Thank you in advance for your assistance and valuable insights.

PS( if anyone can help resolve, would be happy to engage them commercially)

[darkman]

I have same issue

[gazza4469]

We have a similar issue with high CPU usage on Zabbix Server version 6.4, MariaDB Server version: 10.8.8. Brand new installation, with only imported configurations through the web front-end. Everything was working fine, then suddenly after one of our VEEAM backups, everything started to run slowly (slow query log warnings) and the CPU IOWAIT time increased from the teens, to between 38% and 50% - constantly. Rebooting the server and adding more resource hasn't helped. Disk write usage is at 100%, like something is constantly trying to write to the disk?