Debian Codegraph @

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

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