Hi,
i recently got the alert
"MySQL: Created tmp tables on Memory per second is high" with an average of 45 tmp tables
Im monitoring:
748 Hosts
25.031 Items
12.392 Triggers
and using Maria DB
The alert came up after adding another snmp monitored host. most hosts are just monitored by Ping but about 30 to 40 hosts are monitored via snmp.
I have tried the usual preformance tuning of the database but cant get the tmp tables down.
Any advice would be appreciated.
i recently got the alert
"MySQL: Created tmp tables on Memory per second is high" with an average of 45 tmp tables
Im monitoring:
748 Hosts
25.031 Items
12.392 Triggers
and using Maria DB
The alert came up after adding another snmp monitored host. most hosts are just monitored by Ping but about 30 to 40 hosts are monitored via snmp.
I have tried the usual preformance tuning of the database but cant get the tmp tables down.
Any advice would be appreciated.