Hi,
We use MySQL enterprise edition and very often I use slow query logs during a performance test and when the DB is highly active during the typical business hours. We also use MySQL enterprise monitor here for monitoring purposes.
The problem I have with slow query log is that it fills up pretty quickly if we set the threshold(long_query_time) to like 2 seconds, however most of them are filled with monitor agent queries. I was just wondering if is there any way I can configure the slow query log to capture only queries limited to a specific user. Any thoughts on this is highly appreciated.
Many thanks in advance.
Thanks,
Sajan Gone