MySQL 9.0.0
Source Code Documentation
|
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 | 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 */ |
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.
#define REFRESH_BINARY_LOG 1024 |
Flush the binary log.
#define REFRESH_ENGINE_LOG 512 |
Flush all storage engine logs.
#define REFRESH_ERROR_LOG 256 |
Rotate only the error log.
#define REFRESH_FAST 32768 |
Wait for an impending flush before closing the tables.
#define REFRESH_FOR_EXPORT 0x100000L /** FLUSH TABLES ... FOR EXPORT */ |
#define REFRESH_GENERAL_LOG 4096 |
Flush the general log.
#define REFRESH_GRANT 1 |
Refresh grant tables, FLUSH PRIVILEGES.
#define REFRESH_LOG 2 |
Start on new log file, FLUSH LOGS.
#define REFRESH_OPTIMIZER_COSTS 0x200000L /** FLUSH OPTIMIZER_COSTS */ |
#define REFRESH_PERSIST 0x400000L /** RESET PERSIST */ |
#define REFRESH_READ_LOCK 16384 |
Lock tables for read.
#define REFRESH_RELAY_LOG 2048 |
Flush the relay log.
#define REFRESH_REPLICA 64 |
Reset source info and restart replica \ thread, RESET REPLICA.
#define REFRESH_SLOW_LOG 8192 |
Flush the slow query log.
#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
#define REFRESH_STATUS 16 |
Flush status variables, FLUSH STATUS.
#define REFRESH_TABLES 4 |
close all tables, FLUSH TABLES
#define REFRESH_USER_RESOURCES |
#define UNUSED_32 32 |
Removed.
Used to be flush thread cache
#define UNUSED_8 8 |
Previously REFRESH_HOSTS but not used anymore.
Use TRUNCATE TABLE \ performance_schema.host_cache instead