Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_trx_rseg_n_slots_debug_basic.result

raw
1 SET @start_global_value = @@global.innodb_trx_rseg_n_slots_debug;
2 SELECT @start_global_value;
3 @start_global_value
4 0
5 select @@global.innodb_trx_rseg_n_slots_debug between 0 and 1024;
6 @@global.innodb_trx_rseg_n_slots_debug between 0 and 1024
7 1
8 select @@global.innodb_trx_rseg_n_slots_debug;
9 @@global.innodb_trx_rseg_n_slots_debug
10 0
11 select @@session.innodb_trx_rseg_n_slots_debug;
12 ERROR HY000: Variable 'innodb_trx_rseg_n_slots_debug' is a GLOBAL variable
13 show global variables like 'innodb_trx_rseg_n_slots_debug';
14 Variable_name Value
15 innodb_trx_rseg_n_slots_debug 0
16 show session variables like 'innodb_trx_rseg_n_slots_debug';
17 Variable_name Value
18 innodb_trx_rseg_n_slots_debug 0
19 select * from performance_schema.global_variables where variable_name='innodb_trx_rseg_n_slots_debug';
20 VARIABLE_NAME VARIABLE_VALUE
21 innodb_trx_rseg_n_slots_debug 0
22 select * from performance_schema.session_variables where variable_name='innodb_trx_rseg_n_slots_debug';
23 VARIABLE_NAME VARIABLE_VALUE
24 innodb_trx_rseg_n_slots_debug 0
25 set global innodb_trx_rseg_n_slots_debug=1;
26 select @@global.innodb_trx_rseg_n_slots_debug;
27 @@global.innodb_trx_rseg_n_slots_debug
28 1
29 select * from performance_schema.global_variables where variable_name='innodb_trx_rseg_n_slots_debug';
30 VARIABLE_NAME VARIABLE_VALUE
31 innodb_trx_rseg_n_slots_debug 1
32 select * from performance_schema.session_variables where variable_name='innodb_trx_rseg_n_slots_debug';
33 VARIABLE_NAME VARIABLE_VALUE
34 innodb_trx_rseg_n_slots_debug 1
35 set @@global.innodb_trx_rseg_n_slots_debug=0;
36 select @@global.innodb_trx_rseg_n_slots_debug;
37 @@global.innodb_trx_rseg_n_slots_debug
38 0
39 select * from performance_schema.global_variables where variable_name='innodb_trx_rseg_n_slots_debug';
40 VARIABLE_NAME VARIABLE_VALUE
41 innodb_trx_rseg_n_slots_debug 0
42 select * from performance_schema.session_variables where variable_name='innodb_trx_rseg_n_slots_debug';
43 VARIABLE_NAME VARIABLE_VALUE
44 innodb_trx_rseg_n_slots_debug 0
45 set session innodb_trx_rseg_n_slots_debug='some';
46 ERROR HY000: Variable 'innodb_trx_rseg_n_slots_debug' is a GLOBAL variable and should be set with SET GLOBAL
47 set @@session.innodb_trx_rseg_n_slots_debug='some';
48 ERROR HY000: Variable 'innodb_trx_rseg_n_slots_debug' is a GLOBAL variable and should be set with SET GLOBAL
49 set global innodb_trx_rseg_n_slots_debug=1.1;
50 ERROR 42000: Incorrect argument type to variable 'innodb_trx_rseg_n_slots_debug'
51 set global innodb_trx_rseg_n_slots_debug='foo';
52 ERROR 42000: Incorrect argument type to variable 'innodb_trx_rseg_n_slots_debug'
53 set global innodb_trx_rseg_n_slots_debug=-2;
54 Warnings:
55 Warning 1292 Truncated incorrect innodb_trx_rseg_n_slots_debug value: '-2'
56 set global innodb_trx_rseg_n_slots_debug=1e1;
57 ERROR 42000: Incorrect argument type to variable 'innodb_trx_rseg_n_slots_debug'
58 set global innodb_trx_rseg_n_slots_debug=1024;
59 set global innodb_trx_rseg_n_slots_debug=1025;
60 Warnings:
61 Warning 1292 Truncated incorrect innodb_trx_rseg_n_slots_debug value: '1025'
62 SET @@global.innodb_trx_rseg_n_slots_debug = @start_global_value;
63 SELECT @@global.innodb_trx_rseg_n_slots_debug;
64 @@global.innodb_trx_rseg_n_slots_debug
65 0