1SET @start_global_value = @@global.profiling; 2SELECT @start_global_value; 3@start_global_value 40 5select @@global.profiling; 6@@global.profiling 70 8select @@session.profiling; 9@@session.profiling 100 11show global variables like 'profiling'; 12Variable_name Value 13profiling OFF 14show session variables like 'profiling'; 15Variable_name Value 16profiling OFF 17select * from information_schema.global_variables where variable_name='profiling'; 18VARIABLE_NAME VARIABLE_VALUE 19PROFILING OFF 20select * from information_schema.session_variables where variable_name='profiling'; 21VARIABLE_NAME VARIABLE_VALUE 22PROFILING OFF 23set global profiling=1; 24set session profiling=ON; 25select @@global.profiling; 26@@global.profiling 271 28select @@session.profiling; 29@@session.profiling 301 31show global variables like 'profiling'; 32Variable_name Value 33profiling ON 34show session variables like 'profiling'; 35Variable_name Value 36profiling ON 37select * from information_schema.global_variables where variable_name='profiling'; 38VARIABLE_NAME VARIABLE_VALUE 39PROFILING ON 40select * from information_schema.session_variables where variable_name='profiling'; 41VARIABLE_NAME VARIABLE_VALUE 42PROFILING ON 43set global profiling=0; 44set session profiling=OFF; 45select @@global.profiling; 46@@global.profiling 470 48select @@session.profiling; 49@@session.profiling 500 51show global variables like 'profiling'; 52Variable_name Value 53profiling OFF 54show session variables like 'profiling'; 55Variable_name Value 56profiling OFF 57select * from information_schema.global_variables where variable_name='profiling'; 58VARIABLE_NAME VARIABLE_VALUE 59PROFILING OFF 60select * from information_schema.session_variables where variable_name='profiling'; 61VARIABLE_NAME VARIABLE_VALUE 62PROFILING OFF 63set global profiling=1.1; 64ERROR 42000: Incorrect argument type to variable 'profiling' 65set global profiling=1e1; 66ERROR 42000: Incorrect argument type to variable 'profiling' 67set global profiling="foo"; 68ERROR 42000: Variable 'profiling' can't be set to the value of 'foo' 69SET @@global.profiling = @start_global_value; 70SELECT @@global.profiling; 71@@global.profiling 720 73