InnoDB in MySQL 5.7 introduced for the first time the ability to create a general tablespace and assign multiple tables to it. These tablespaces can be assigned anywhere on the system. They can even be assigned a smaller block size so that they can contain compressed tables that use that size as their key_block_size.…

The new InnoDB Labs release contains the ability to create and use independent multi-table general tablespaces.

This feature will provide a way to group tables together into tablespaces at a location and filename of your choosing. Tables using row formats of Redundant, Compact, and Dynamic can be combined together into the same general tablespace. …