Best practices for working with MySQL storage engines

• Table size:

  • Partition your large tables so that file sizes are well under the 16 TiB limit.

• Number of tables:

  • AWS recommend having fewer than ten thousand tables total across all of the databases in a DB instance.

• Storage engine:

  • The point-in-time restore and snapshot restore features of RDS for MySQL require a crash-recoverable storage engine and are supported for the InnoDB storage engine only.

  • Although MySQL supports multiple storage engines with varying capabilities, not all of them are optimized for crash recovery and data durability.