Help Center/ Relational Database Service/ FAQs/ Database Parameter Modification/ How Do I Change the Transaction Isolation Level of an RDS for MySQL Instance?
Updated on 2024-10-22 GMT+08:00
View PDF
Share

How Do I Change the Transaction Isolation Level of an RDS for MySQL Instance?

You can change the transaction isolation level by setting the following parameter on the RDS console.

  • RDS for MySQL 5.7 and 5.6: tx_isolation
  • RDS for MySQL 8.0: transaction_isolation

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region.
  3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  4. On the Instances page, click the target instance name.
  5. In the navigation pane on the left, choose Parameters. On the Parameters tab page, locate the parameter and select the desired isolation level from the drop-down list in the Value column. The following values are available for you to choose from:

    • READ-UNCOMMITTED
    • READ-COMMITTED
    • REPEATABLE-READ
    • SERIALIZABLE

  6. Click Save. In the displayed dialog box, click Yes.