1SET @start_global_value = @@global.log_slow_verbosity; 2select @@global.log_slow_verbosity = @@session.log_slow_verbosity; 3@@global.log_slow_verbosity = @@session.log_slow_verbosity 41 5SET @@global.log_slow_verbosity="",@@session.log_slow_verbosity=""; 6show global variables like 'log_slow_verbosity'; 7Variable_name Value 8log_slow_verbosity 9show session variables like 'log_slow_verbosity'; 10Variable_name Value 11log_slow_verbosity 12select * from information_schema.global_variables where variable_name='log_slow_verbosity'; 13VARIABLE_NAME VARIABLE_VALUE 14LOG_SLOW_VERBOSITY 15select * from information_schema.session_variables where variable_name='log_slow_verbosity'; 16VARIABLE_NAME VARIABLE_VALUE 17LOG_SLOW_VERBOSITY 18set global log_slow_verbosity=1; 19select @@global.log_slow_verbosity; 20@@global.log_slow_verbosity 21innodb 22set session log_slow_verbosity=1; 23select @@session.log_slow_verbosity; 24@@session.log_slow_verbosity 25innodb 26set session log_slow_verbosity=1; 27select @@session.log_slow_verbosity; 28@@session.log_slow_verbosity 29innodb 30set session log_slow_verbosity=2; 31select @@session.log_slow_verbosity; 32@@session.log_slow_verbosity 33query_plan 34set session log_slow_verbosity=3; 35select @@session.log_slow_verbosity; 36@@session.log_slow_verbosity 37innodb,query_plan 38set session log_slow_verbosity=4; 39select @@session.log_slow_verbosity; 40@@session.log_slow_verbosity 41explain 42set session log_slow_verbosity=5; 43select @@session.log_slow_verbosity; 44@@session.log_slow_verbosity 45innodb,explain 46set session log_slow_verbosity=6; 47select @@session.log_slow_verbosity; 48@@session.log_slow_verbosity 49query_plan,explain 50set session log_slow_verbosity=7; 51select @@session.log_slow_verbosity; 52@@session.log_slow_verbosity 53innodb,query_plan,explain 54set session log_slow_verbosity='innodb'; 55select @@session.log_slow_verbosity; 56@@session.log_slow_verbosity 57innodb 58set session log_slow_verbosity='query_plan'; 59select @@session.log_slow_verbosity; 60@@session.log_slow_verbosity 61query_plan 62set session log_slow_verbosity='innodb,query_plan'; 63select @@session.log_slow_verbosity; 64@@session.log_slow_verbosity 65innodb,query_plan 66set session log_slow_verbosity='explain'; 67select @@session.log_slow_verbosity; 68@@session.log_slow_verbosity 69explain 70set session log_slow_verbosity='innodb,query_plan,explain'; 71select @@session.log_slow_verbosity; 72@@session.log_slow_verbosity 73innodb,query_plan,explain 74set session log_slow_verbosity=''; 75select @@session.log_slow_verbosity; 76@@session.log_slow_verbosity 77 78set session log_slow_verbosity=1.1; 79ERROR 42000: Incorrect argument type to variable 'log_slow_verbosity' 80set session log_slow_verbosity=1e1; 81ERROR 42000: Incorrect argument type to variable 'log_slow_verbosity' 82set session log_slow_verbosity="foo"; 83ERROR 42000: Variable 'log_slow_verbosity' can't be set to the value of 'foo' 84set session log_slow_verbosity=8; 85ERROR 42000: Variable 'log_slow_verbosity' can't be set to the value of '8' 86SET @@global.log_slow_verbosity = @start_global_value; 87