we try to gather the number of current connections of an MySQL database via the MySQL v2 sensor.
Unfortunatelly the received results are not matching with the expected results and therefore we assume the query do not work proper.
We have tried two different methods:
1. select count(*) from information_schema.PROCESSLIST
Under MySQL it returns the total number of connection in a single line and column. When we use the sensor to process the data it returns always 5.
2. select * from information_schema.PROCESSLIST where information_schema.PROCESSLIST.host not like "server%"
Under MySQL it returns the correct number of line (without the local server%) When we use the sensor to evaluate the rows of the query it returns always 1
What will be the database schema we need to trigger as a target? Is it information_schema or the one we created?
For the moment i did a workaround and process the query via comandline to an outfile and count the raws. Thats fine but may it can be easier to achieve with someones help.