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.
A potential new feature.
Introduce some new command in Admin to delete from
stats_mysql_query_digestold entries. For example, something like:PURGE stats_mysql_query_digest TO <value>Any entry in
stats_mysql_query_digestwherelast_seenis 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.