Documentation Home
MySQL Internals Manual


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


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.