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

[10 May 2013 15:55] Leandro Morgado
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
[9 Jan 2014 12:10] Arnaud Adant
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]...)
[9 Jan 2014 13:53] Paul Dubois
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.