Troubleshooting MySQL Server
Troubleshoot the issues you find in the MySQL Server.
Resolving
SUPER_READ_ONLY
and OFFLINE_MODE
Issue
MySQL Server enables SUPER_READ_ONLY
and
OFFLINE_MODE
when the available disk space falls below
certain configuration values.
Health Monitor enables the SUPER_READ_ONLY
and
OFFLINE_MODE
in the following scenarios:
- The available disk space falls below
disk_low_space_level
ordisk_low_space_percent
, whichever value is lower, fordisk_low_space_duration
seconds. - The available disk space falls below
disk_low_space_critical_level
, for any duration.
Using the Console
Use the Console to resolve the SUPER_READ_ONLY
or
OFFLINE_MODE
issue of MySQL Server.
- You get the following error when any client attempts to connect to
the MySQL Server:
MySQL Error 1290 (HY000): The MySQL server is running with the --super-read-only option so it cannot execute this statement @ file bytes range [1400005472, 1500005697).
MySQL Error 1290 (HY000): The MySQL server is running with the --offline-mode option so it cannot execute this statement @ file bytes range [1400005472, 1500005697).
- Increase the storage size, and restart the DB system. See Increasing DB System Storage.
- If you cannot increase the storage size, do the following:
- Create a manual backup of the DB system. See Creating a Backup.
- Create a new DB system using the manual backup with a larger storage size. See Creating a DB System from a Backup.
To prevent the issue from occurring, you can use the
DbVolumeUtilization
metric to be alerted before disk space
falls below critical levels. For more information, see Checking the Storage of a DB System.
Debugging and Diagnostics Utility
Use the debugging and diagnostics utility to collect diagnostic data on the MySQL Server.
The debugging and diagnostics utility enables you to collect raw diagnostic data from MySQL Servers and generates a diagnostic report to either the local directory or a specified path.
Related Topics