MySQL Database Troubleshooting

Last updated 2 months ago

Mysql Server Unreachable Error

This error refers to the database server being unavailable on the system. It is most likely that the process has stopped and is not running.

Generally this occurs when your system has run out of memory and the System Out Of Memory Management (OOM) process has stopped MySQL to save memory.

You can determine if the system OOM process has interfered by running the following on your system:

cat /var/log/messages* | grep 'Out of memory'

Resolution:

  1. Restart MediaCP database service using the following command as root in SSH:
    mediacp restart mysql
  2. Ensure that MediaCP is the only application running on the system.
    Other applications such as cPanel/WHM, Plesk will also consume CPU, Disk and Memory. We recommend that MediaCP is the only application on the system to ensure it runs fast and stable.

  3. Increase the amount of memory available to your system.
    You should consult the System Requirements documentation to ensure your system meets the Minimum Requirements, however you should also aim to meet the Recommended Hardware requirements.

Table of Contents