MediaCP Manual
MySQL Database Troubleshooting

Last updated 3 weeks 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.

Attempt repair of crashed tables

How do i know the tables have crashed

Common errors that you might see include:

  • General Error: 126 Incorrect key file for table ‘tablename‘; try to repair it
  • Table ‘tablename‘ is marked as crashed and should be repaired 

Why do database tables crash?

The major cause of the database corruption is the lack of free disk space on the server. Other possible causes of MySQL table crashes include operating system problems, power failures, hardware issues, unexpected MySQL server termination, data corruption due to external programs, etc.

How do i repair database tables?

You can attempt to repair the database tables by running the command below, however in some cases this might not resolve the problem (See section below What if i cannot repair the database?). Pay attention to the output in case there are errors:

/usr/local/mediacp/mysql/bin/mysqlcheck --protocol=SOCKET --socket=/usr/local/mediacp/mysql/data/mysql.sock --user=root --password= -A --auto-repair --all-databases

It might be required to restart MySQL, pay attention to the output in case there are errors:

mediacp restart mysql

Can MediaCP repair it for me?

Please contact us and our level 2 staff can complete this for you for a 1 hour service fee. Please note that the service fee will be charged regardless if the repair is successful, however we will help you restore or reinstall your MediaCP if a repair cannot be successful.

What if i cannot repair the database?

Unfortunately if the database has crashed and is not repairable then you will need to either:

Table of Contents