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
- Log in to the management console.
- Click
in the upper left corner and select a region and a project.
- Click Service List. Under Database, click Relational Database Service.
- On the Instances page, click the target DB instance.
- 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
- Click Save. In the displayed dialog box, click Yes.
Parent topic: Database Parameter Modification
- Procedure