14.6.8 COM_REFRESH

Note

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

Returns

OK_Packet or ERR_Packet