Bug #69322 Documentation for INNODB_SYS_DATAFILES and INNODB_SYS_TABLESPACES is missing
Submitted: 26 May 2013 9:38 Modified: 7 Jun 2013 20:00
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.6.10, 5.7.1 OS:Any
Assigned to: Bugs System CPU Architecture:Any

[26 May 2013 9:38] Daniël van Eeden
Description:
The INNODB_SYS tables from 5.6.10:
mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_SYS_%';
+---------------------------------------------+
| Tables_in_INFORMATION_SCHEMA (INNODB_SYS_%) |
+---------------------------------------------+
| INNODB_SYS_DATAFILES                        |
| INNODB_SYS_TABLESTATS                       |
| INNODB_SYS_INDEXES                          |
| INNODB_SYS_TABLES                           |
| INNODB_SYS_FIELDS                           |
| INNODB_SYS_TABLESPACES                      |
| INNODB_SYS_FOREIGN_COLS                     |
| INNODB_SYS_COLUMNS                          |
| INNODB_SYS_FOREIGN                          |
+---------------------------------------------+
9 rows in set (0.00 sec)

The INNODB_SYS tables in the 5.7 ref manual:
19.30.7. The INFORMATION_SCHEMA INNODB_SYS_TABLES Table
19.30.8. The INFORMATION_SCHEMA INNODB_SYS_INDEXES Table
19.30.9. The INFORMATION_SCHEMA INNODB_SYS_COLUMNS Table
19.30.10. The INFORMATION_SCHEMA INNODB_SYS_FIELDS Table
19.30.11. The INFORMATION_SCHEMA INNODB_SYS_FOREIGN Table
19.30.12. The INFORMATION_SCHEMA INNODB_SYS_FOREIGN_COLS Table
19.30.13. The INFORMATION_SCHEMA INNODB_SYS_TABLESTATS View

So it seems like the documentation is missing for INNODB_SYS_DATAFILES and INNODB_SYS_TABLESPACES.

It is identical for 5.6.10 and 5.7.1.

How to repeat:
Compare docs with available tables.

Suggested fix:
Add documentation
[27 May 2013 6:33] MySQL Verification Team
Thank you for the report.
[7 Jun 2013 20:00] Bugs System
Added INODB_SYS_DATAFILES and INNODB_SYS_TABLESPACES information to:

http://dev.mysql.com/doc/refman/5.6/en/information-schema.html
http://dev.mysql.com/doc/refman/5.7/en/information-schema.html

Information will appear soon, with the next doc build. 
Thank you for the bug report.