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