I would like to apply filters to the slow query log analyzer. Especially when log_queries_not_using_indexes is turned on there are a lot of false positives (queries on empty or very small tables for example). I suggest:
“””
Discard entries where:
– total execution time <= .. ms
– average execution time <= .. ms
– maximum execution time <= ... ms
– user = …
– rows sent <= ...
– rows examined <= ...
– count <=
– query occurence <= ...%
Filters are concatenated with a logical OR.
“””