1
SET @start_global_value = @@global.innodb_stats_persistent_sample_pages;
2
SELECT @start_global_value;
5
Valid values are zero or above
6
SELECT @@global.innodb_stats_persistent_sample_pages >=0;
7
@@global.innodb_stats_persistent_sample_pages >=0
9
SELECT @@global.innodb_stats_persistent_sample_pages;
10
@@global.innodb_stats_persistent_sample_pages
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';
16
innodb_stats_persistent_sample_pages 20
17
SHOW session variables LIKE 'innodb_stats_persistent_sample_pages';
19
innodb_stats_persistent_sample_pages 20
20
SELECT * FROM information_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 information_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
32
SELECT * FROM information_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 information_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=1.1;
43
ERROR 42000: Incorrect argument type to variable 'innodb_stats_persistent_sample_pages'
44
SET global innodb_stats_persistent_sample_pages=1e1;
45
ERROR 42000: Incorrect argument type to variable 'innodb_stats_persistent_sample_pages'
46
SET global innodb_stats_persistent_sample_pages="foo";
47
ERROR 42000: Incorrect argument type to variable 'innodb_stats_persistent_sample_pages'
48
SET global innodb_stats_persistent_sample_pages=-7;
50
Warning 1292 Truncated incorrect innodb_stats_persistent_sample_p value: '-7'
51
SELECT @@global.innodb_stats_persistent_sample_pages;
52
@@global.innodb_stats_persistent_sample_pages
54
SELECT * FROM information_schema.global_variables
55
WHERE variable_name='innodb_stats_persistent_sample_pages';
56
VARIABLE_NAME VARIABLE_VALUE
57
INNODB_STATS_PERSISTENT_SAMPLE_PAGES 1
58
SET @@global.innodb_stats_persistent_sample_pages = @start_global_value;
59
SELECT @@global.innodb_stats_persistent_sample_pages;
60
@@global.innodb_stats_persistent_sample_pages