1
CREATE TABLE test_ps_sample_pages (a INT, PRIMARY KEY (a)) ENGINE=INNODB;
2
SHOW CREATE TABLE test_ps_sample_pages;
3
Table test_ps_sample_pages
4
Create Table CREATE TABLE `test_ps_sample_pages` (
5
`a` int(11) NOT NULL DEFAULT '0',
7
) ENGINE=InnoDB DEFAULT CHARSET=latin1
8
SELECT create_options FROM information_schema.tables
9
WHERE table_name='test_ps_sample_pages';
11
ALTER TABLE test_ps_sample_pages STATS_SAMPLE_PAGES=12345;
12
SHOW CREATE TABLE test_ps_sample_pages;
13
Table test_ps_sample_pages
14
Create Table CREATE TABLE `test_ps_sample_pages` (
15
`a` int(11) NOT NULL DEFAULT '0',
17
) ENGINE=InnoDB DEFAULT CHARSET=latin1 STATS_SAMPLE_PAGES=12345
18
SELECT create_options FROM information_schema.tables
19
WHERE table_name='test_ps_sample_pages';
20
create_options stats_sample_pages=12345
21
DROP TABLE test_ps_sample_pages;
22
CREATE TABLE test_ps_sample_pages (a INT, PRIMARY KEY (a)) ENGINE=INNODB
23
STATS_SAMPLE_PAGES=default;
24
SHOW CREATE TABLE test_ps_sample_pages;
25
Table test_ps_sample_pages
26
Create Table CREATE TABLE `test_ps_sample_pages` (
27
`a` int(11) NOT NULL DEFAULT '0',
29
) ENGINE=InnoDB DEFAULT CHARSET=latin1
30
SELECT create_options FROM information_schema.tables
31
WHERE table_name='test_ps_sample_pages';
33
DROP TABLE test_ps_sample_pages;
34
CREATE TABLE test_ps_sample_pages (a INT, PRIMARY KEY (a)) ENGINE=INNODB
35
STATS_SAMPLE_PAGES=-5;
36
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-5' at line 2
37
CREATE TABLE test_ps_sample_pages (a INT, PRIMARY KEY (a)) ENGINE=INNODB
39
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0' at line 2
40
CREATE TABLE test_ps_sample_pages (a INT, PRIMARY KEY (a)) ENGINE=INNODB
41
STATS_SAMPLE_PAGES=67000;
42
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '67000' at line 2
43
CREATE TABLE test_ps_sample_pages (a INT, PRIMARY KEY (a)) ENGINE=INNODB
44
STATS_SAMPLE_PAGES=670000;
45
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '670000' at line 2
46
CREATE TABLE test_ps_sample_pages (a INT, PRIMARY KEY (a)) ENGINE=INNODB
47
STATS_SAMPLE_PAGES=65536;
48
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '65536' at line 2
49
CREATE TABLE test_ps_sample_pages (a INT, PRIMARY KEY (a)) ENGINE=INNODB
50
STATS_SAMPLE_PAGES=65535;
51
SHOW CREATE TABLE test_ps_sample_pages;
52
Table test_ps_sample_pages
53
Create Table CREATE TABLE `test_ps_sample_pages` (
54
`a` int(11) NOT NULL DEFAULT '0',
56
) ENGINE=InnoDB DEFAULT CHARSET=latin1 STATS_SAMPLE_PAGES=65535
57
DROP TABLE test_ps_sample_pages;
58
CREATE TABLE test_ps_sample_pages (a INT, PRIMARY KEY (a)) ENGINE=INNODB
60
SHOW CREATE TABLE test_ps_sample_pages;
61
Table test_ps_sample_pages
62
Create Table CREATE TABLE `test_ps_sample_pages` (
63
`a` int(11) NOT NULL DEFAULT '0',
65
) ENGINE=InnoDB DEFAULT CHARSET=latin1 STATS_SAMPLE_PAGES=1
66
SELECT create_options FROM information_schema.tables
67
WHERE table_name='test_ps_sample_pages';
68
create_options stats_sample_pages=1
69
DROP TABLE test_ps_sample_pages;
70
CREATE TABLE test_ps_sample_pages (a INT, PRIMARY KEY (a)) ENGINE=INNODB
71
STATS_SAMPLE_PAGES=5678;
72
SHOW CREATE TABLE test_ps_sample_pages;
73
Table test_ps_sample_pages
74
Create Table CREATE TABLE `test_ps_sample_pages` (
75
`a` int(11) NOT NULL DEFAULT '0',
77
) ENGINE=InnoDB DEFAULT CHARSET=latin1 STATS_SAMPLE_PAGES=5678
78
SELECT create_options FROM information_schema.tables
79
WHERE table_name='test_ps_sample_pages';
80
create_options stats_sample_pages=5678
81
ALTER TABLE test_ps_sample_pages STATS_SAMPLE_PAGES=default;
82
SHOW CREATE TABLE test_ps_sample_pages;
83
Table test_ps_sample_pages
84
Create Table CREATE TABLE `test_ps_sample_pages` (
85
`a` int(11) NOT NULL DEFAULT '0',
87
) ENGINE=InnoDB DEFAULT CHARSET=latin1
88
SELECT create_options FROM information_schema.tables
89
WHERE table_name='test_ps_sample_pages';
91
DROP TABLE test_ps_sample_pages;