Compressed Table Characteristics

• Compressed storage format is a read-only format that is generated with the myisampack tool.
  • Compressed tables can be uncompressed with myisamchk.

• Compressed format tables have these characteristics:
  • Compressed tables take very little disk space.
  • Each row is compressed separately, so there is very little access overhead.
    • The header for a row takes up one to three bytes depending on the biggest row in the table.
    • Each column is compressed differently.
    • A column may use any combination of the preceding compression types.
  • Can be used for fixed-length or dynamic-length rows.

What are typical MyISAM table problems?

---

---

© 2007 John Michael Pierobon

Notes