MySQL 9.0.0
Source Code Documentation
COM_REFRESH Flags

Values for the sub_command in COM_REFRESH. More...

Collaboration diagram for COM_REFRESH Flags:

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 UNUSED_8    8
 Previously REFRESH_HOSTS but not used anymore. More...
 
#define REFRESH_STATUS   16
 Flush status variables, FLUSH STATUS. More...
 
#define UNUSED_32   32
 Removed. More...
 
#define REFRESH_REPLICA    64
 Reset source info and restart replica \ thread, RESET REPLICA. More...
 
#define REFRESH_SOURCE    128
 Remove all bin logs in the index \ and truncate the index. More...
 
#define REFRESH_ERROR_LOG   256
 Rotate only the error 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
 
#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 error 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_LOG

#define REFRESH_LOG   2

Start on new log file, FLUSH LOGS.

◆ 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_REPLICA

#define REFRESH_REPLICA    64

Reset source info and restart replica \ thread, RESET REPLICA.

◆ REFRESH_SLOW_LOG

#define REFRESH_SLOW_LOG   8192

Flush the slow query log.

◆ REFRESH_SOURCE

#define REFRESH_SOURCE    128

Remove all bin logs in the index \ and truncate the index.

Also resets \ GTID information. Command: \ RESET BINARY LOGS AND GTIDS

◆ REFRESH_STATUS

#define REFRESH_STATUS   16

Flush status variables, FLUSH STATUS.

◆ REFRESH_TABLES

#define REFRESH_TABLES   4

close all tables, FLUSH TABLES

◆ REFRESH_USER_RESOURCES

#define REFRESH_USER_RESOURCES
Value:
0x80000L /** FLUSH RESOURCES. @sa ::reset_mqh \
*/

◆ UNUSED_32

#define UNUSED_32   32

Removed.

Used to be flush thread cache

◆ UNUSED_8

#define UNUSED_8    8

Previously REFRESH_HOSTS but not used anymore.

Use TRUNCATE TABLE \ performance_schema.host_cache instead