MySQL Bugs: #60273: no rows are in the INFORMATION_SCHEMA TABLESPACES OR FILES tables

Bug #60273	no rows are in the INFORMATION_SCHEMA TABLESPACES OR FILES tables
Submitted:	27 Feb 2011 23:38	Modified:	28 Feb 2011 14:35
Reporter:	Michael Vitale	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Information schema	Severity:	S4 (Feature request)
Version:	5.5.8	OS:	Linux
Assigned to:		CPU Architecture:	Any

Description:
I have innodb_file_per_table set in my.cnf and I have data in the tablespaces files that reflects data in the those tablespaces, but when I query the INFORMATION_SCHEMA (TABLESPACES and FILES), no rows are returned.

How to repeat:
select * from INFORMATION_SCHEMA.TABLESPACES

as far as i understand innodb has never populated those tables.  only ndb cluster (and maybe some third party engines) use it.  so, this is 'not a bug'.

do you agree that, this is only a feature request to have innodb populate those tables?

I do not agree that this is only a feature request.  I have looked at the 5.5 documentation for INFORMATION_SCHEMA and there is no mention of the tablespaces or files tables being limited to a particular storage engine.  In fact, one of the columns of the TABLESPACES table is "ENGINE", therefore implying that tablespaces can be associated with different storage engines.

Furthermore, tablespaces is an implementation now in InnoDB, so why wouldn't these tables be populated?

This is either a bug in the documentation because it should say it does not apply to InnoDB, or it is a bug in not showing rows where the storage engine is InnoDB.

The fact that innodb tablespaces are not present in this I_S table is documented into http://dev.mysql.com/doc/refman/5.7/en/tablespaces-table.html.