Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Provide a slow query log #7717

Open
fulghum opened this issue Apr 9, 2024 · 0 comments
Open

Provide a slow query log #7717

fulghum opened this issue Apr 9, 2024 · 0 comments
Labels
enhancement New feature or request sql server Issues related to the built in SQL server

Comments

@fulghum
Copy link
Contributor

fulghum commented Apr 9, 2024

MySQL's slow query log 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 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.

@fulghum fulghum added the enhancement New feature or request label Apr 9, 2024
@timsehn timsehn added the sql server Issues related to the built in SQL server label Apr 12, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request sql server Issues related to the built in SQL server
Projects
None yet
Development

No branches or pull requests

2 participants