WL#2511: Add a new table to the Information Schema for TABLESPACE's

Affects: Server-5.5   —   Status: Complete

Implement a new Information Schema Table TABLESPACES which includes
tablespaces from all storage engines using tablespaces (currently NDB
and Falcon). LOGFILE GROUP's in NDB is a type of tablespace, thus a
tablespace table requires a field TYPE distinguishing the type of
tablespace.


Old description
---------------
Apparently work for this happen in WL#4240.
Email about cancellation is here:
https://intranet.mysql.com/secure/mailarchive/mail.php?folder=4&mail=24634


To be able to view the current standing of a tablespace a new   
table in the information schema is proposed or actually two of them  
1) TABLESPACE (defining extent size, name, nodegroup and engine and whether  
   tablespace or logfile group  
2) File of a TABLESPACE  
   providing initial size, current size, name of file, tablespace name,  
   and maximum size and autoextend size  
   [ Peter Gulutzan believes the appropriate 'files' task is WL#1359 ]  
  

If there must be an INFORMATION_SCHEMA.TABLESPACES,
the "primary key" columns (well, not actually primary key
columns but the columns that are guaranteed to be unique)
are: name + storage engine.

References
----------

dev-private thread "Meeeting re WL#4300 Tablespace privilege
+ Meeting re information_schema.tablespaces"
https://intranet.mysql.com/secure/mailarchive/mail.php?folder=214&mail=792

WL#4240 "Online Backup: save/restore table space information"