MySQL Bugs: #114915: Please consider deprecating mysqladmin flush-hosts.

Bug #114915	Please consider deprecating mysqladmin flush-hosts.
Submitted:	7 May 2024 17:07	Modified:	8 May 2024 5:19
Reporter:	Jean-François Gagné	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S4 (Feature request)
Version:	8.4	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
Hi,

"What Is New in MySQL 8.4 since MySQL 8.0" [1] indicates that FLUSH HOSTS has been removed, but still suggest using mysqladmin flush-hosts (or TRUNCATE TABLE performance_schema.host_cache).

Because FLUSH HOSTS has been removed, it is weird to have a flush-hosts option to mysqladmin.  I understand the need for backward compatibility, but a path to not using the flush-hosts should be provided (and in this respect, this report might be considered a bug, but as it involved adding an option, I put it as a feature request).

And for that reason, I think an option should be added to mysqladmin for truncating the host cache without referencing flush-host (suggestion truncate-host-cache).

Many thanks for looking into this,

Jean-François Gagné

How to repeat:
N/A for Feature Request.

Suggested fix:
Add an option to mysqladmin for truncating the host cache without referencing flush-host (suggestion truncate-host-cache).

Hello Jean-François,

Thank you for the feature request!

regards,
Umesh