Oracle Cloud Infrastructure Documentation

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 or disk_low_space_percent, whichever value is lower, for disk_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.

This task assumes the following:
  • 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).
Do any of the following to resolve the issue:

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.