In MySQL InnoDB, what is the difference between COMPRESSED, COMPACT and DYNAMIC for ROW_FORMAT?
What are the benefits between each other?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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.