Optimize Tables

• To coalesce fragmented rows and eliminate wasted space that results from deleting or updating rows, run myisamchk in recovery mode.

  myisamchk -r tbl_name

• A table can be optimized the same way by using the OPTIMIZE TABLE SQL statement.
  • OPTIMIZE TABLE does a table repair and a key analysis.
  • OPTIMIZE TABLE also sorts the index tree so key lookups are faster.

• myisamchk has the options to improve the performance of a table:
  • --analyze
  • --sort-index
  • --sort-records=index_num

Should I set up a table maintenance schedule?

---

---

© 2007 John Michael Pierobon

Notes