I am currently running Zabbix 7.0 LTS (7.0.22) with MySQL 8.0.44 on an Ubuntu 24.04.3 LTS system with roughly about 200 hosts to check on. CPU is an Intel Core i3-N305.
At this point in time I have set LogSlowQueries=30000 and DebugLevel=3, so anything that takes over 30 seconds will be logged.
Checking on the zabbix log on this system usually gets about on the average 100 slow query entries a day. While I don't mind these types of entry into the log I don't need to know the actual data stream that is causing the slow query. It would be nice to know the number of bytes of the data is as opposed to the actual data itself.
I take it at this version of Zabbix this is not possible? Or would changing the DebugLevel help?
At this point in time I have set LogSlowQueries=30000 and DebugLevel=3, so anything that takes over 30 seconds will be logged.
Checking on the zabbix log on this system usually gets about on the average 100 slow query entries a day. While I don't mind these types of entry into the log I don't need to know the actual data stream that is causing the slow query. It would be nice to know the number of bytes of the data is as opposed to the actual data itself.
I take it at this version of Zabbix this is not possible? Or would changing the DebugLevel help?