Static Table Characteristics

• Static format is the default for MyISAM tables.
  • Of the three MyISAM storage formats, static format is the simplest and most secure.

• Static format tables have these characteristics:
  • Each row is stored using a fixed number of bytes.
    • CHAR and VARCHAR columns are space-padded to the specified column width, although the column type is not altered.
  • Very quick.
  • Easy to cache.
  • Easy to reconstruct after a crash, because rows are located in fixed positions.
  • Usually require more disk space than dynamic format tables.

What are the MyISAM dynamic table characteristics?

---

---

© 2007 John Michael Pierobon

Notes