Size Limits

• MyISAM tables have the mysterious 4GB limit

  • Set MAX_ROWS attribute in CREATE TABLE
  • Or use ALTER TABLE later

• InnoDB tablespace file sizes are pre-set

  • Autoextend helps but only applies to the last file
  • No control over which tables reside in which files
    • To be fixed later this year
  • Watch the COUNT(*) queries