Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_adaptive_flushing_basic.test

raw
1
2
3 # 2010-01-25 - Added
4 #
5
6 --source include/have_innodb.inc
7
8 SET @start_global_value = @@global.innodb_adaptive_flushing;
9 SELECT @start_global_value;
10
11 #
12 # exists as global only
13 #
14 --echo Valid values are 'ON' and 'OFF'
15 select @@global.innodb_adaptive_flushing in (0, 1);
16 select @@global.innodb_adaptive_flushing;
17 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
18 select @@session.innodb_adaptive_flushing;
19 show global variables like 'innodb_adaptive_flushing';
20 show session variables like 'innodb_adaptive_flushing';
21 select * from information_schema.global_variables where variable_name='innodb_adaptive_flushing';
22 select * from information_schema.session_variables where variable_name='innodb_adaptive_flushing';
23
24 #
25 # show that it's writable
26 #
27 set global innodb_adaptive_flushing='OFF';
28 select @@global.innodb_adaptive_flushing;
29 select * from information_schema.global_variables where variable_name='innodb_adaptive_flushing';
30 select * from information_schema.session_variables where variable_name='innodb_adaptive_flushing';
31 set @@global.innodb_adaptive_flushing=1;
32 select @@global.innodb_adaptive_flushing;
33 select * from information_schema.global_variables where variable_name='innodb_adaptive_flushing';
34 select * from information_schema.session_variables where variable_name='innodb_adaptive_flushing';
35 set global innodb_adaptive_flushing=0;
36 select @@global.innodb_adaptive_flushing;
37 select * from information_schema.global_variables where variable_name='innodb_adaptive_flushing';
38 select * from information_schema.session_variables where variable_name='innodb_adaptive_flushing';
39 set @@global.innodb_adaptive_flushing='ON';
40 select @@global.innodb_adaptive_flushing;
41 select * from information_schema.global_variables where variable_name='innodb_adaptive_flushing';
42 select * from information_schema.session_variables where variable_name='innodb_adaptive_flushing';
43 --error ER_GLOBAL_VARIABLE
44 set session innodb_adaptive_flushing='OFF';
45 --error ER_GLOBAL_VARIABLE
46 set @@session.innodb_adaptive_flushing='ON';
47
48 #
49 # incorrect types
50 #
51 --error ER_WRONG_TYPE_FOR_VAR
52 set global innodb_adaptive_flushing=1.1;
53 --error ER_WRONG_TYPE_FOR_VAR
54 set global innodb_adaptive_flushing=1e1;
55 --error ER_WRONG_VALUE_FOR_VAR
56 set global innodb_adaptive_flushing=2;
57 --error ER_WRONG_VALUE_FOR_VAR
58 set global innodb_adaptive_flushing=-3;
59 select @@global.innodb_adaptive_flushing;
60 select * from information_schema.global_variables where variable_name='innodb_adaptive_flushing';
61 select * from information_schema.session_variables where variable_name='innodb_adaptive_flushing';
62 --error ER_WRONG_VALUE_FOR_VAR
63 set global innodb_adaptive_flushing='AUTO';
64
65 #
66 # Cleanup
67 #
68
69 SET @@global.innodb_adaptive_flushing = @start_global_value;
70 SELECT @@global.innodb_adaptive_flushing;