principlesqlModerate
ROW_FORMAT - COMPRESSED vs COMPACT vs DYNAMIC
Viewed 0 times
compressedrow_formatcompactdynamic
Problem
In MySQL InnoDB, what is the difference between COMPRESSED, COMPACT and DYNAMIC for ROW_FORMAT?
What are the benefits between each other?
What are the benefits between each other?
Solution
COMPACT is format supported by Antilope. It stores first 768 bytes of BLOB in case its value doesn't fit in page.
DYNAMIC is almost the same as COMPACT except only 20 bytes for each BLOB field is used. Benefits - more BLOB fields are possible in a record.
COMPRESSED is used for compressed tables. Hence its benefits.
DYNAMIC is almost the same as COMPACT except only 20 bytes for each BLOB field is used. Benefits - more BLOB fields are possible in a record.
COMPRESSED is used for compressed tables. Hence its benefits.
Context
StackExchange Database Administrators Q#69789, answer score: 13
Revisions (0)
No revisions yet.