Bug #60878 mysqladmin doesn't support flushing specific logs

• Submitted: 15 Apr 2011 9:31
• Modified: 11 Jun 2014 20:49
• Reporter: Daniël van Eeden
• Status: Closed
• Category: MySQL Server: Command-line Clients
• Severity: S4 (Feature request)
• Version: 5.5.11
• OS: Any
• CPU Architecture: Any
• Tags: Contribution

[15 Apr 2011 9:31] Daniël van Eeden

Description:
mysqladmin has a flush-logs option.

Since 5.5.3 a log type is supported by the SQL interface:
http://dev.mysql.com/doc/refman/5.5/en/flush.html

mysqladmin sends REFRESH_LOG using mysql_refresh()
http://dev.mysql.com/doc/refman/5.5/en/mysql-refresh.html

There are more specific options available than REFRESH_LOG according to sql/sql_reload.cc:111

    options|= REFRESH_BINARY_LOG;
    options|= REFRESH_RELAY_LOG;
    options|= REFRESH_SLOW_LOG;
    options|= REFRESH_GENERAL_LOG;
    options|= REFRESH_ENGINE_LOG;
    options|= REFRESH_ERROR_LOG;

But these aren't used by mysqladmin

How to repeat:
Read docs.

Suggested fix:
Add logtype option to flush-logs option of mysqladmin.

I will add another bug for REFRESH_*_LOG not being documented.

[15 Apr 2011 9:36] Daniël van Eeden

Related: Bug #60879 (C API: mysql_refresh() options REFRESH_*_LOGS not documented)

[15 Apr 2011 10:19] Valeriy Kravchuk

Thank you for the feature request.

[15 Apr 2011 17:57] Daniël van Eeden

Simple fix for this feature request:
lp:~dveeden/mysql-server/mysql-5.5-bug60878

I made this fix and I've signed the SCA...

[22 May 2014 8:12] Erlend Dahl

Bug#52008 was marked as a duplicate.

[23 May 2014 6:47] Daniël van Eeden

Added the patch to make sure it won't get lost.

Attachment: de643792-69fc-11e0-8049-001e0bc3957e.txt (text/plain), 1.59 KiB.

[11 Jun 2014 20:49] Paul DuBois

Noted in 5.7.5 changelog.

The mysqladmin flush-logs command now permits optional log types to
be given, to specify which logs to flush. Following the flush-logs
command, you can provide a space-separated list of one or more of the
following log types: binary, engine, error, general, relay, slow.
These correspond to the log types that can be specified for the FLUSH
LOGS SQL statement.

[11 Jun 2014 20:51] Paul DuBois

Thanks to  Daniël van Eeden for the patch.