Debian Codegraph @

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

raw
1
2 #
3 # 2010-01-25 - Added
4 #
5
6
7 SET @start_global_value = @@global.innodb_stats_persistent_sample_pages;
8 SELECT @start_global_value;
9
10 #
11 # exists as global only
12 #
13 --echo Valid values are zero or above
14 SELECT @@global.innodb_stats_persistent_sample_pages >=0;
15 SELECT @@global.innodb_stats_persistent_sample_pages;
16 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
17 SELECT @@session.innodb_stats_persistent_sample_pages;
18 SHOW global variables LIKE 'innodb_stats_persistent_sample_pages';
19 SHOW session variables LIKE 'innodb_stats_persistent_sample_pages';
20 --disable_warnings
21 SELECT * FROM performance_schema.global_variables
22 WHERE variable_name='innodb_stats_persistent_sample_pages';
23 SELECT * FROM performance_schema.session_variables
24 WHERE variable_name='innodb_stats_persistent_sample_pages';
25 --enable_warnings
26
27 #
28 # SHOW that it's writable
29 #
30 SET global innodb_stats_persistent_sample_pages=10;
31 SELECT @@global.innodb_stats_persistent_sample_pages;
32 --disable_warnings
33 SELECT * FROM performance_schema.global_variables
34 WHERE variable_name='innodb_stats_persistent_sample_pages';
35 SELECT * FROM performance_schema.session_variables
36 WHERE variable_name='innodb_stats_persistent_sample_pages';
37 --enable_warnings
38 --error ER_GLOBAL_VARIABLE
39 SET session innodb_stats_persistent_sample_pages=1;
40
41 #
42 # show the default value
43 #
44 set global innodb_stats_persistent_sample_pages=DEFAULT;
45 select @@global.innodb_stats_persistent_sample_pages;
46
47 #
48 # valid values
49 #
50 SET global innodb_stats_persistent_sample_pages=0;
51 SELECT @@global.innodb_stats_persistent_sample_pages;
52
53 SET global innodb_stats_persistent_sample_pages=10;
54 SELECT @@global.innodb_stats_persistent_sample_pages;
55
56
57
58
59 #
60 # incorrect types
61 #
62 --error ER_WRONG_TYPE_FOR_VAR
63 SET global innodb_stats_persistent_sample_pages=1.1;
64 --error ER_WRONG_TYPE_FOR_VAR
65 SET global innodb_stats_persistent_sample_pages=1e1;
66 --error ER_WRONG_TYPE_FOR_VAR
67 SET global innodb_stats_persistent_sample_pages="foo";
68 --error ER_WRONG_TYPE_FOR_VAR
69 SET global innodb_stats_persistent_sample_pages=' ';
70 SELECT @@global.innodb_stats_persistent_sample_pages;
71 --error ER_WRONG_TYPE_FOR_VAR
72 SET global innodb_stats_persistent_sample_pages=" ";
73 SELECT @@global.innodb_stats_persistent_sample_pages;
74 SET global innodb_stats_persistent_sample_pages=-7;
75 SELECT @@global.innodb_stats_persistent_sample_pages;
76 --disable_warnings
77 SELECT * FROM performance_schema.global_variables
78 WHERE variable_name='innodb_stats_persistent_sample_pages';
79 --enable_warnings
80
81
82 #
83 # cleanup
84 #
85 SET @@global.innodb_stats_persistent_sample_pages = @start_global_value;
86 SELECT @@global.innodb_stats_persistent_sample_pages;