1select @@global.rpl_semi_sync_master_wait_point;
2@@global.rpl_semi_sync_master_wait_point
3AFTER_COMMIT
4SET @start_global_value = @@global.rpl_semi_sync_master_wait_point;
5select @@session.rpl_semi_sync_master_wait_point;
6ERROR HY000: Variable 'rpl_semi_sync_master_wait_point' is a GLOBAL variable
7show global variables like 'rpl_semi_sync_master_wait_point';
8Variable_name	Value
9rpl_semi_sync_master_wait_point	AFTER_COMMIT
10show session variables like 'rpl_semi_sync_master_wait_point';
11Variable_name	Value
12rpl_semi_sync_master_wait_point	AFTER_COMMIT
13select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_wait_point';
14VARIABLE_NAME	VARIABLE_VALUE
15RPL_SEMI_SYNC_MASTER_WAIT_POINT	AFTER_COMMIT
16select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_wait_point';
17VARIABLE_NAME	VARIABLE_VALUE
18RPL_SEMI_SYNC_MASTER_WAIT_POINT	AFTER_COMMIT
19set global rpl_semi_sync_master_wait_point=AFTER_SYNC;
20set session rpl_semi_sync_master_wait_point=AFTER_COMMIT;
21ERROR HY000: Variable 'rpl_semi_sync_master_wait_point' is a GLOBAL variable and should be set with SET GLOBAL
22select @@global.rpl_semi_sync_master_wait_point;
23@@global.rpl_semi_sync_master_wait_point
24AFTER_SYNC
25select @@session.rpl_semi_sync_master_wait_point;
26ERROR HY000: Variable 'rpl_semi_sync_master_wait_point' is a GLOBAL variable
27show global variables like 'rpl_semi_sync_master_wait_point';
28Variable_name	Value
29rpl_semi_sync_master_wait_point	AFTER_SYNC
30show session variables like 'rpl_semi_sync_master_wait_point';
31Variable_name	Value
32rpl_semi_sync_master_wait_point	AFTER_SYNC
33select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_wait_point';
34VARIABLE_NAME	VARIABLE_VALUE
35RPL_SEMI_SYNC_MASTER_WAIT_POINT	AFTER_SYNC
36select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_wait_point';
37VARIABLE_NAME	VARIABLE_VALUE
38RPL_SEMI_SYNC_MASTER_WAIT_POINT	AFTER_SYNC
39set global rpl_semi_sync_master_wait_point=1.1;
40ERROR 42000: Incorrect argument type to variable 'rpl_semi_sync_master_wait_point'
41set global rpl_semi_sync_master_wait_point=1e1;
42ERROR 42000: Incorrect argument type to variable 'rpl_semi_sync_master_wait_point'
43SET @@global.rpl_semi_sync_master_wait_point = @start_global_value;
44select @@global.rpl_semi_sync_master_wait_point;
45@@global.rpl_semi_sync_master_wait_point
46AFTER_COMMIT
47