dolthub / dolthub/dolt

Provide a slow query log

Open
#7,717 1 comment 3 reactions 0 assignees View on GitHub
enhancement sql server
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.