Provide a slow query log
- Dominant language
- Go
- Stars
- 24.4k
- Forks
- 873
- Avg merge
- 1d 5h
- Merged PRs (30d)
- 108
Description
[MySQL's slow query log](https://dev.mysql.com/doc/refman/8.3/en/slow-query-log.html) is really helpful to identify queries that are taking a long time to execute. Having something similar could help Dolt customers identify slow queries that are using up many resources on the DB host.
After first providing an opt-in slow query log file, providing a table function to access the log data without having to log into the host could be useful for customers.
Supporting [the `Slow_queries` status variable](https://dev.mysql.com/doc/refman/8.3/en/server-status-variables.html#statvar_Slow_queries) would also be helpful for operational monitoring. Tools like Datadog use this status variable, as well as the slow query log itself, to provide operational dashboards.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.