High temporary tables created per second - Zabbix server

[Amiram]

Hey all,

I'm running Zabbix server (5.4.0) inside a docker container using Mysql Server (5.7.33) .
The physicals servers has 36Cores with 256Gb Ram and 4T SSD.
The server is currently monitoring 1513 hosts with ~280K items (nvps- 2131) using 17 proxies.
The server is not monitoring any agent directly.

*The Mysql configure to use RAM for the temp tables.

The problem,
I'm getting a alert from the MySQL saying the "Number of on-disk/internal temporary tables created per second is high"
on-disk ~20 (threshold: 10)
internal ~90 (threshold: 30)

What could be the reason for that?
How it can be fixed/solved?
There is nothing to worry here and just threshold tuning?

Any ideas?


Amiram.

[Amiram]

Any ideas?

[Amiru]

Hi, did you manage to solve this?
I'm also facing the same issue.
mine is monitoring 800+ hosts, almost 67k items & 540 nvps
wondering if this is something that I should be worry about

[cyber]

Temp tables are created, when your DB runs out of memory during queries. So it uses disk space as swap basically. You should increase the amount of memory your DB can use (per query).
I suppose for MySQL there is some config option for that, PG definitely has it.