MySQL  8.0.17
Source Code Documentation
COM_REFRESH Flags

Values for the sub_command in COM_REFRESH. More...

Macros

#define REFRESH_GRANT   1
 Refresh grant tables, FLUSH PRIVILEGES. More...
 
#define REFRESH_LOG   2
 Start on new log file, FLUSH LOGS. More...
 
#define REFRESH_TABLES   4
 close all tables, FLUSH TABLES More...
 
#define REFRESH_HOSTS   8
 Flush host cache, FLUSH HOSTS. More...
 
#define REFRESH_STATUS   16
 Flush status variables, FLUSH STATUS. More...
 
#define REFRESH_THREADS   32
 Flush thread cache. More...
 
#define REFRESH_SLAVE   64
 Reset master info and restart slave \ thread, RESET SLAVE. More...
 
#define REFRESH_MASTER   128
 Remove all bin logs in the index \ and truncate the index, RESET MASTER. More...
 
#define REFRESH_ERROR_LOG   256
 Rotate only the erorr log. More...
 
#define REFRESH_ENGINE_LOG   512
 Flush all storage engine logs. More...
 
#define REFRESH_BINARY_LOG   1024
 Flush the binary log. More...
 
#define REFRESH_RELAY_LOG   2048
 Flush the relay log. More...
 
#define REFRESH_GENERAL_LOG   4096
 Flush the general log. More...
 
#define REFRESH_SLOW_LOG   8192
 Flush the slow query log. More...
 
#define REFRESH_READ_LOCK   16384
 Lock tables for read. More...
 
#define REFRESH_FAST   32768
 Wait for an impending flush before closing the tables. More...
 
#define REFRESH_USER_RESOURCES   0x80000L /** FLISH RESOUCES. @sa ::reset_mqh */
 
#define REFRESH_FOR_EXPORT   0x100000L /** FLUSH TABLES ... FOR EXPORT */
 
#define REFRESH_OPTIMIZER_COSTS   0x200000L /** FLUSH OPTIMIZER_COSTS */
 
#define REFRESH_PERSIST   0x400000L /** RESET PERSIST */
 

Detailed Description

Values for the sub_command in COM_REFRESH.

Currently the protocol carries only 8 bits of these flags.

The rest (8-end) are used only internally in the server.

Macro Definition Documentation

◆ REFRESH_BINARY_LOG

#define REFRESH_BINARY_LOG   1024

Flush the binary log.

◆ REFRESH_ENGINE_LOG

#define REFRESH_ENGINE_LOG   512

Flush all storage engine logs.

◆ REFRESH_ERROR_LOG

#define REFRESH_ERROR_LOG   256

Rotate only the erorr log.

◆ REFRESH_FAST

#define REFRESH_FAST   32768

Wait for an impending flush before closing the tables.

See also
REFRESH_READ_LOCK, handle_reload_request, close_cached_tables

◆ REFRESH_FOR_EXPORT

#define REFRESH_FOR_EXPORT   0x100000L /** FLUSH TABLES ... FOR EXPORT */

◆ REFRESH_GENERAL_LOG

#define REFRESH_GENERAL_LOG   4096

Flush the general log.

◆ REFRESH_GRANT

#define REFRESH_GRANT   1

Refresh grant tables, FLUSH PRIVILEGES.

◆ REFRESH_HOSTS

#define REFRESH_HOSTS   8

Flush host cache, FLUSH HOSTS.

◆ REFRESH_LOG

#define REFRESH_LOG   2

Start on new log file, FLUSH LOGS.

◆ REFRESH_MASTER

#define REFRESH_MASTER   128

Remove all bin logs in the index \ and truncate the index, RESET MASTER.

◆ REFRESH_OPTIMIZER_COSTS

#define REFRESH_OPTIMIZER_COSTS   0x200000L /** FLUSH OPTIMIZER_COSTS */

◆ REFRESH_PERSIST

#define REFRESH_PERSIST   0x400000L /** RESET PERSIST */

◆ REFRESH_READ_LOCK

#define REFRESH_READ_LOCK   16384

Lock tables for read.

◆ REFRESH_RELAY_LOG

#define REFRESH_RELAY_LOG   2048

Flush the relay log.

◆ REFRESH_SLAVE

#define REFRESH_SLAVE   64

Reset master info and restart slave \ thread, RESET SLAVE.

◆ REFRESH_SLOW_LOG

#define REFRESH_SLOW_LOG   8192

Flush the slow query log.

◆ REFRESH_STATUS

#define REFRESH_STATUS   16

Flush status variables, FLUSH STATUS.

◆ REFRESH_TABLES

#define REFRESH_TABLES   4

close all tables, FLUSH TABLES

◆ REFRESH_THREADS

#define REFRESH_THREADS   32

Flush thread cache.

◆ REFRESH_USER_RESOURCES

#define REFRESH_USER_RESOURCES   0x80000L /** FLISH RESOUCES. @sa ::reset_mqh */