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.
Last updated
Was this helpful?