Too high Zabbix Server 5.0 queue! Help!

[FabrizioA]

Hi, I've a large Zabbix 5.0 environment composed of:

- single Zabbix Server VM (6 vCPU, 16Gb RAM)
- single MySQL 5.7 VM (6 cCPU, 32Gb RAM, storage write speed at about 350 MB/s from inside mysql's data directory)
- 90 Zabbix Server Proxy with compression enabled.
- 7500 monitored host (6000 enabled / 1000 not enabled).
- 570.000 items (420.000 enabled, 120.000 disabled, 25.000 not supported)
- 209.000 triggers
- Required server performance, new values per second 5550.00

My current annoying problem is the Zabbix Server's Proxies queue
As you can see on attached graphs, we have a Queue at about 80K entry and a "NVPS" at about 5K.... by this way I doubt that the situation could be better in the future...

How can I increase my Zabbix's NVPS capacity?
In your opinion the problem could be on Zabbix Server? Mysql? Proxies??

Thank you in advance for any help.

Regards,
Fabrizio

[FabrizioA]

Here the configuration files of Zabbix Server and MySQL 5.7

[FabrizioA]

Anyone? Suggestions?

[Gutsycat]

Please show CPU Utilisation chart? Maybe it's time to move to real hardware from VM?

[zhujian]

please solve the item with not supported，

[Hamardaban]

What are the queue statistics for each proxy? Are there any error messages in the server logs? To control the database performance, try to control slow queries to the database and see what will be written to the logs.