MySQL Bugs: #69199: STATS_SAMPLE_PAGES not documented in "CREATE TABLE" page

Bug #69199	STATS_SAMPLE_PAGES not documented in "CREATE TABLE" page
Submitted:	10 May 2013 15:55	Modified:	9 Jan 2014 13:53
Reporter:	Leandro Morgado	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.6.x	OS:	Any
Assigned to:	Paul DuBois	CPU Architecture:	Any

Description:
In 5.6 it is possible to define individual table paramaters for statistics gathering, for example, STATS_AUTO_RECALC and STATS_PERSISTENT:

http://dev.mysql.com/doc/refman/5.6/en/create-table.html

However, the paramater to specify the number of pages in the sample size ( STATS_SAMPLE_PAGES ) is not documented. 

How to repeat:
mysql> CREATE TABLE table_foo (id INT NOT NULL, PRIMARY KEY(id)) ENGINE=InnoDB STATS_SAMPLE_PAGES=1000;
Query OK, 0 rows affected (0.03 sec)

mysql> SHOW CREATE TABLE table_foo\G
*************************** 1. row ***************************
       Table: table_foo
Create Table: CREATE TABLE `table_foo` (
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 STATS_SAMPLE_PAGES=1000
1 row in set (0.00 sec)

Suggested fix:
Document "STATS_SAMPLE_PAGES" in the "CREATE TABLE" manual page:
 http://dev.mysql.com/doc/refman/5.6/en/create-table.html
 http://dev.mysql.com/doc/refman/5.7/en/create-table.html

see also

Bug #69982 	STATS_SAMPLE_PAGES clause is not documented in the manual

The parameter is now documented but it is not listed in the grammar

  | ROW_FORMAT [=] {DEFAULT|DYNAMIC|FIXED|COMPRESSED|REDUNDANT|COMPACT}
  | STATS_AUTO_RECALC [=] {DEFAULT|0|1}
  | STATS_PERSISTENT [=] {DEFAULT|0|1}
  | TABLESPACE tablespace_name [STORAGE {DISK|MEMORY|DEFAULT}]
  | UNION [=] (tbl_name[,tbl_name]...)

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.