As of MySQL 5.7.11, COM_REFRESH
is
deprecated and will be removed in a future version of MySQL.
Instead, use mysql_query()
to
execute a FLUSH
statement.
A low-level version of several FLUSH ...
and
RESET ...
statements.
COM_REFRESH
:
Call REFRESH
or FLUSH
statements
Payload
1 [07] COM_REFRESH
1 sub_command
Fields
command (1) --
0x07
COM_REFRESH
-
sub_command (1) -- a bitmask of sub-systems to refresh
sub_command
Constant Name
Description
0x01
REFRESH_GRANT
Refresh grant tables
FLUSH PRIVILEGES
0x02
REFRESH_LOG
Start on new log file
FLUSH LOGS
0x04
REFRESH_TABLES
Close all tables
FLUSH TABLES
0x08
REFRESH_HOSTS
Flush host cache
FLUSH HOSTS
0x10
REFRESH_STATUS
Flush status variables
FLUSH STATUS
0x20
REFRESH_THREADS
Flush thread cache
0x40
REFRESH_SLAVE
Reset master info and restart slave thread
RESET SLAVE
0x80
REFRESH_MASTER
Remove all binary logs in the index and truncate the index
RESET MASTER