18 lines
515 B
Plaintext
18 lines
515 B
Plaintext
# Test to ensure resource group statements are not binlogged.
|
|
RESET MASTER;
|
|
CREATE RESOURCE GROUP u1 TYPE=USER VCPU=0-2;
|
|
ALTER RESOURCE GROUP u1 VCPU=3;
|
|
SET RESOURCE GROUP u1;
|
|
SELECT RESOURCE_GROUP_NAME FROM INFORMATION_SCHEMA.RESOURCE_GROUPS;
|
|
RESOURCE_GROUP_NAME
|
|
SYS_default
|
|
u1
|
|
USR_default
|
|
DROP RESOURCE GROUP u1 FORCE;
|
|
include/show_binlog_events.inc
|
|
Log_name Pos Event_type Server_id End_log_pos Info
|
|
SELECT RESOURCE_GROUP_NAME FROM INFORMATION_SCHEMA.RESOURCE_GROUPS;
|
|
RESOURCE_GROUP_NAME
|
|
SYS_default
|
|
USR_default
|