Help Center/ Relational Database Service/ User Guide (Kuala Lumpur Region)/ Troubleshooting/ RDS for MySQL/ Performance Issues/ DB Instance Becoming Read-Only Due to Full Storage
Updated on 2025-10-28 GMT+08:00
View PDF
Share

DB Instance Becoming Read-Only Due to Full Storage

Scenario

The following error information was displayed for an RDS for MySQL instance:

The MySQL server is running with the --read-only option so it cannot execute this statement

Troubleshooting

  1. Go to the instance details page and check whether the storage space is full.

  2. Log in to the database and check the read_only variable.

    show variables like 'read_only';

  3. From the previous steps, you can find that the storage space is full and the instance status has changed to read-only. As a result, the SQL statement fails to be executed.

Solution

Scaling up Storage Space.

Parent topic: Performance Issues