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	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_REPLICA 64
	Reset master info and restart replica \ thread, RESET REPLICA. More...

#define	REFRESH_SLAVE REFRESH_REPLICA
	Reset master info and restart replica \ thread, RESET REPLICA. 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 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_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_REPLICA

#define REFRESH_REPLICA 64

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

◆ REFRESH_SLAVE

#define REFRESH_SLAVE REFRESH_REPLICA

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

This is deprecated, \ use REFRESH_REPLICA instead.

◆ 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

Value:

0x80000L /** FLUSH RESOURCES. @sa ::reset_mqh \

*/

Macros