Bug #77093 Need SHOW TABLESPACES command
Submitted: 19 May 2015 12:22
Reporter: Andrii Nikitin Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DDL Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[19 May 2015 12:22] Andrii Nikitin
Description:
Since CREATE / DROP / ALTER TABLESPACE  commands are generic (non-engine dependent) , then it logically expected to see SHOW TABLESPACES command as well. 
Querying I_S may be an alternative way to see them, but SHOW command is required the same way as other objects have (DATABASES, TABLES, INDEX, etc).

How to repeat:
fr

Suggested fix:
It should return at lease tablespace name , engine, and datafile