Bug #77091 Allow configuration of default General Tablespace - global and per database
Submitted: 19 May 2015 11:58
Reporter: Andrii Nikitin Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any

[19 May 2015 11:58] Andrii Nikitin
This configuration will be used for tables which are created without TABLESPACE= specifciation

How to repeat:

Suggested fix:
Global tablespace configuration should behave the same way as innodb_file_per_table and interact with innodb_file_per_table smoothly.
In best case this option should deprecate innodb_file_per_table, because tablespace value "innodb_file_per_table" will do the same what variable innodb_file_per_table does.

Default tablespace per database may be implemented as discussed in FR bug #77090