Documentation Home
MySQL Internals Manual
Download this Manual
EPUB - 0.8Mb


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
Sign Up Login You must be logged in to post a comment.