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

Support some form of partial cleanup of stats_mysql_query_digest #4543

Open
renecannao opened this issue May 9, 2024 · 0 comments
Open

Support some form of partial cleanup of stats_mysql_query_digest #4543

renecannao opened this issue May 9, 2024 · 0 comments

Comments

@renecannao
Copy link
Contributor

A potential new feature.

Introduce some new command in Admin to delete from stats_mysql_query_digest old entries.
For example, something like:
PURGE stats_mysql_query_digest TO <value>

Any entry in stats_mysql_query_digest where last_seen is less than <value> will be deleted.

The process needs to be synchronous, thus will block the internal hash table while the process is running.
As an optimization, we can use parallel processing as we already do in many tasks related to stats_mysql_query_digest.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant