1SET @start_global_value = @@global.profiling; 2Warnings: 3Warning 1287 '@@profiling' is deprecated and will be removed in a future release. 4SELECT @start_global_value; 5@start_global_value 60 7select @@global.profiling; 8@@global.profiling 90 10Warnings: 11Warning 1287 '@@profiling' is deprecated and will be removed in a future release. 12select @@session.profiling; 13@@session.profiling 140 15Warnings: 16Warning 1287 '@@profiling' is deprecated and will be removed in a future release. 17show global variables like 'profiling'; 18Variable_name Value 19profiling OFF 20show session variables like 'profiling'; 21Variable_name Value 22profiling OFF 23select * from information_schema.global_variables where variable_name='profiling'; 24VARIABLE_NAME VARIABLE_VALUE 25PROFILING OFF 26select * from information_schema.session_variables where variable_name='profiling'; 27VARIABLE_NAME VARIABLE_VALUE 28PROFILING OFF 29set global profiling=1; 30Warnings: 31Warning 1287 '@@profiling' is deprecated and will be removed in a future release. 32set session profiling=ON; 33Warnings: 34Warning 1287 '@@profiling' is deprecated and will be removed in a future release. 35select @@global.profiling; 36@@global.profiling 371 38Warnings: 39Warning 1287 '@@profiling' is deprecated and will be removed in a future release. 40select @@session.profiling; 41@@session.profiling 421 43Warnings: 44Warning 1287 '@@profiling' is deprecated and will be removed in a future release. 45show global variables like 'profiling'; 46Variable_name Value 47profiling ON 48show session variables like 'profiling'; 49Variable_name Value 50profiling ON 51select * from information_schema.global_variables where variable_name='profiling'; 52VARIABLE_NAME VARIABLE_VALUE 53PROFILING ON 54select * from information_schema.session_variables where variable_name='profiling'; 55VARIABLE_NAME VARIABLE_VALUE 56PROFILING ON 57set global profiling=0; 58Warnings: 59Warning 1287 '@@profiling' is deprecated and will be removed in a future release. 60set session profiling=OFF; 61Warnings: 62Warning 1287 '@@profiling' is deprecated and will be removed in a future release. 63select @@global.profiling; 64@@global.profiling 650 66Warnings: 67Warning 1287 '@@profiling' is deprecated and will be removed in a future release. 68select @@session.profiling; 69@@session.profiling 700 71Warnings: 72Warning 1287 '@@profiling' is deprecated and will be removed in a future release. 73show global variables like 'profiling'; 74Variable_name Value 75profiling OFF 76show session variables like 'profiling'; 77Variable_name Value 78profiling OFF 79select * from information_schema.global_variables where variable_name='profiling'; 80VARIABLE_NAME VARIABLE_VALUE 81PROFILING OFF 82select * from information_schema.session_variables where variable_name='profiling'; 83VARIABLE_NAME VARIABLE_VALUE 84PROFILING OFF 85set global profiling=1.1; 86ERROR 42000: Incorrect argument type to variable 'profiling' 87set global profiling=1e1; 88ERROR 42000: Incorrect argument type to variable 'profiling' 89set global profiling="foo"; 90ERROR 42000: Variable 'profiling' can't be set to the value of 'foo' 91SET @@global.profiling = @start_global_value; 92Warnings: 93Warning 1287 '@@profiling' is deprecated and will be removed in a future release. 94SELECT @@global.profiling; 95@@global.profiling 960 97Warnings: 98Warning 1287 '@@profiling' is deprecated and will be removed in a future release. 99