Debian Codegraph @

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

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