1SET @start_global_value = @@global.sync_master_info; 2SELECT @start_global_value; 3@start_global_value 410000 5select @@global.sync_master_info; 6@@global.sync_master_info 710000 8select @@session.sync_master_info; 9ERROR HY000: Variable 'sync_master_info' is a GLOBAL variable 10show global variables like 'sync_master_info'; 11Variable_name Value 12sync_master_info 10000 13show session variables like 'sync_master_info'; 14Variable_name Value 15sync_master_info 10000 16select * from information_schema.global_variables where variable_name='sync_master_info'; 17VARIABLE_NAME VARIABLE_VALUE 18SYNC_MASTER_INFO 10000 19select * from information_schema.session_variables where variable_name='sync_master_info'; 20VARIABLE_NAME VARIABLE_VALUE 21SYNC_MASTER_INFO 10000 22set global sync_master_info=1; 23select @@global.sync_master_info; 24@@global.sync_master_info 251 26set session sync_master_info=1; 27ERROR HY000: Variable 'sync_master_info' is a GLOBAL variable and should be set with SET GLOBAL 28set global sync_master_info=1.1; 29ERROR 42000: Incorrect argument type to variable 'sync_master_info' 30set global sync_master_info=1e1; 31ERROR 42000: Incorrect argument type to variable 'sync_master_info' 32set global sync_master_info="foo"; 33ERROR 42000: Incorrect argument type to variable 'sync_master_info' 34set global sync_master_info=0; 35select @@global.sync_master_info; 36@@global.sync_master_info 370 38set global sync_master_info=cast(-1 as unsigned int); 39Warnings: 40Note 1105 Cast to unsigned converted negative integer to it's positive complement 41Warning 1292 Truncated incorrect sync_master_info value: '18446744073709551615' 42select @@global.sync_master_info; 43@@global.sync_master_info 444294967295 45SET @@global.sync_master_info = @start_global_value; 46SELECT @@global.sync_master_info; 47@@global.sync_master_info 4810000 49