Debian Codegraph @

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

raw
1
2 #
3 # 2010-01-25 - Added
4 #
5
6
7 SET @start_global_value = @@global.innodb_stats_transient_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_transient_sample_pages >=0;
15 SELECT @@global.innodb_stats_transient_sample_pages;
16 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
17 SELECT @@session.innodb_stats_transient_sample_pages;
18 SHOW global variables LIKE 'innodb_stats_transient_sample_pages';
19 SHOW session variables LIKE 'innodb_stats_transient_sample_pages';
20 --disable_warnings
21 SELECT * FROM performance_schema.global_variables
22 WHERE variable_name='innodb_stats_transient_sample_pages';
23 SELECT * FROM performance_schema.session_variables
24 WHERE variable_name='innodb_stats_transient_sample_pages';
25 --enable_warnings
26
27 #
28 # show the default value
29 #
30 set global innodb_stats_transient_sample_pages=DEFAULT;
31 select @@global.innodb_stats_transient_sample_pages;
32
33 #
34 # SHOW that it's writable
35 #
36 SET global innodb_stats_transient_sample_pages=10;
37 SELECT @@global.innodb_stats_transient_sample_pages;
38 --disable_warnings
39 SELECT * FROM performance_schema.global_variables
40 WHERE variable_name='innodb_stats_transient_sample_pages';
41 SELECT * FROM performance_schema.session_variables
42 WHERE variable_name='innodb_stats_transient_sample_pages';
43 --enable_warnings
44 --error ER_GLOBAL_VARIABLE
45 SET session innodb_stats_transient_sample_pages=1;
46
47 #
48 # incorrect types
49 #
50 --error ER_WRONG_TYPE_FOR_VAR
51 SET global innodb_stats_transient_sample_pages=1.1;
52 --error ER_WRONG_TYPE_FOR_VAR
53 SET global innodb_stats_transient_sample_pages=1e1;
54 --error ER_WRONG_TYPE_FOR_VAR
55 SET global innodb_stats_transient_sample_pages="foo";
56 --error ER_WRONG_TYPE_FOR_VAR
57 SET global innodb_stats_transient_sample_pages=' ';
58
59 SET global innodb_stats_transient_sample_pages=-7;
60 SELECT @@global.innodb_stats_transient_sample_pages;
61 --disable_warnings
62 SELECT * FROM performance_schema.global_variables
63 WHERE variable_name='innodb_stats_transient_sample_pages';
64 --enable_warnings
65
66 #
67 # cleanup
68 #
69 SET @@global.innodb_stats_transient_sample_pages = @start_global_value;
70 SELECT @@global.innodb_stats_transient_sample_pages;