A slow query log that samples fast queries too
Superseded by https:/
Currently it is impossible to have the following slow logging setup:
a) log all slow queries, that is, taking more than lonq_query_time to execute;
b) additionally, log a random sample of fast queries, that is taking less than long_query_time to execute;
c) each logged query would be annotated to indicate whether it was logged as slow or fast query, e.g. "# logged as sampling 1/100 queries", "# logged as sampling 1/100 queries".
This blueprint is for implementation of such setup. The resulting slow query log in this configuration would be helpful at once in showing both 1) slow queries that need attention; and 2) overall workload on the server.
This feature would be controlled by a new variable log_slow_
Interaction with other slow query log options:
log_slow_
log_slow_
use_global_
Blueprint information
- Status:
- Complete
- Approver:
- None
- Priority:
- Not
- Drafter:
- Laurynas Biveinis
- Direction:
- Needs approval
- Assignee:
- None
- Definition:
- Superseded
- Series goal:
- None
- Implementation:
- Unknown
- Milestone target:
- None
- Started by
- Completed by
- Laurynas Biveinis