MySQL Bugs: #22933: information_schema.TABLES does not have a TABLESPACE

Bug #22933	information_schema.TABLES does not have a TABLESPACE_NAME column
Submitted:	3 Oct 2006 12:54	Modified:	29 Dec 2009 6:47
Reporter:	Roland Bouman	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Information schema	Severity:	S4 (Feature request)
Version:	5.1.12	OS:	Any (na)
Assigned to:		CPU Architecture:	Any
Tags:	FILES, information_schema, table, tables, Tablespace, TABLESPACE_NAME

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
The information schema does not implement anything to discover in which tablespace a table is stored.

There is a TABLESPACE_NAME column in the FILES system view, however, this cannot be used to discover which tables are in a tablespace, even though the FILES system view has a TABLE_NAME column.

How to repeat:
Na

Suggested fix:
Add a TABLESPACE_NAME column to the TABLES system view. Alternatively, add a TABLESPACE_TABLES systen view to report the realtionship between tables and tablespaces.