In MySQL InnoDB, what is the difference between COMPRESSED, COMPACT and DYNAMIC for ROW_FORMAT?
What are the benefits between each other?
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.