MySQL Database Service Improved Write Performance with Disable Crash Recovery Option

You can now disable Crash Recovery in MySQL Database Service to improve the overall performance of write-intensive tasks such as:

  • Data loading of the schema and data into a new or existing DB System
  • Data reorganization and archival, such as INSERT INTO ... SELECT statements
  • Batch data processing in controlled environments, such as automated tests

Disabling Crash Recovery relaxes MySQL durability mechanisms, reducing data redundancy and recoverability from local failures, and is not recommended for regular database operation. This feature should be used only in particular situations. Enabling High Availability is recommended.

For more information, see Crash Recovery.