We collect the most common troubleshooting of using MySQL for your reference:
Many troubleshooting is closely related to the Server, if you can confirm troubleshooting is related to Cloud Platform, please refer to Cloud Platform Documentation (opens new window)
# MySQL is no running?
The most common reasons why MySQL can't start include: insufficient disk space, insufficient memory, configuration file errors... If you application can not connect the MySQL, please refer to following step to solve the problem
- Using the
systemctl status mysqldcommand to view the MySQL status
[root@izm5e5otogu0m1fktk1gsyz ~]# systemctl status mysqld ● mysqld.service - MySQL Community Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: inactive (dead) since Thu 2019-04-04 11:09:32 CST; 15s ago Process: 25155 ExecStartPost=/usr/bin/mysql-systemd-start post (code=exited, status=0/SUCCESS) Process: 25154 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS) Process: 25140 ExecStartPre=/usr/bin/mysql-systemd-start pre (code=exited, status=0/SUCCESS) Main PID: 25154 (code=exited, status=0/SUCCESS)
- You can find the message "Active: inactive (dead) since Thu 2019-04-04 11:09:32 CST; 15s ago" , it means MySQL is not running now
- Using the
systemctl start mysqldto start MySQL, If started successfully, the problem has beed solved
- Otherwise, you should analysis MySQL logs /var/log/mysqld.log to found the reason
# Database service could not be started?
Insufficient disk space, insufficient memory, and configuration file errors can make database service could not be started
It is recommended to first check through the command.
# restart mysql service systemctl restart mysql # view disk space df -lh # view memory rate free -lh
# The database log file is too large, resulting in insufficient disk space?
By default, mysql will automatically open the binlog. Binlog is mainly used to recover the database without backup. However, the binlog will take up a lot of space. If you don't clean it for a long time, the remaining disk space will be 0, which will affect the database or the server will not start.
If you have confidence in your own backup, you do not need the binlog function. Refer to the following steps to turn it off:
- Edit [MySQL Configuration File] (/stack-components.md#mysql) and comment out the binlog log
- Restart mysql
systemctl restart mysqld
# phpMyAdmin page access blank?
Please try another browser, such as chrome or firefox. If the phpMyAdmin can be opened normally before, and now appears to be incomplete or blank, it is recommended to clean up the browser cache, cookies and other information
# The container fails to start?
The most common reason is that the user did not set the required environment variables according to the requirements of the container, causing the container to fail to start
# Container port mapping failed?
If the user is unable to grasp the mapping relationship and availability between the host (server) operating system port and the container port, please enable automatic port mapping