
MySQL 8 for Big Data
By :

As stated earlier, vertical partitioning divides the columns into multiple file groups.
Vertical partitioning can be achieved by the following:
In row splitting, columns from one table are vertically separated into multiple file groups. When there are large datasets stored in a table, it may be difficult to manage large database files on a single location or server. So we can divide some of the columns from the database into a separate file group where can be managed on a separate disk.
Consider the following screenshot for vertical partitioning of the user table. As stated earlier, the database table, users, has been split into two separate partitions stored on different storage.
There can be more than two partitions of the table:
Vertical partitioning of a single table into multiple file groups is...