mysql - Is there a benefit in creating a vertical partition of a table if only relevant columns are being selected anyway? -

i using mysql 5.6. have tables have upwards of 15-20 columns each.

however, being careful select relevant columns in each of queries.

would there still benefit (ex: performance-wise) in creating vertical partitions of these tables?

i assuming sort of manual implementation of vertical partitioning. documentation quite clear:

mysql 5.6 not support vertical partitioning, in different columns of table assigned different physical partitions. there not @ time plans introduce vertical partitioning mysql 5.6.

when implement yourself, creating multiple tables same primary key different sets of columns. can useful under circumstances:

• there little data modification (because require figuring out partition(s) have columns , require extensive locking).
• there handful of columns accessed very, without other columns.
• or, possibly, many rows missing values columns (so partition table not contain these rows).

in general, work in database not provide native support. 1 situation can useful when there wide text/blob columns accessed. putting these in separate table can make queries more efficient not reading in data these columns, when columns not being used.

so, there occasions such approach useful. rather sophisticated optimization, , unlikely needed 20-25 columns on typical table.