What should I do if the disk space in Ubuntu is full and mysql cannot be started?-Mysql Tutorial-php.cn

What should I do if the disk space in Ubuntu is full and mysql cannot be started?

Y2J

Release： 2017-05-24 13:56:42

Original

2268 people have browsed it

Yesterday, I encountered the problem that the MySQL database could not be restarted. I thought it was due to permissions. Later, I found that the prompt was caused by insufficient disk space. I solved it by searching for relevant information. Therefore, the following article mainly introduces the issue under ubuntu. Friends who need a solution to the problem that mysql cannot start due to insufficient disk space can refer to it.

Preface

Recently, I added two fields to a table in the database. Later, it prompted something like insufficient disk space, and then the database failed. The connection was disconnected, and I couldn't connect to it. Later, I finally solved the problem after thinking about it. This experience was really frightening. This article is to record the solution to mysql being unable to start due to insufficient disk space.

The method is as follows

Operating system: ubuntu, mysql cannot be started due to insufficient disk space, which will cause the following problems:

root@iZ28z558vv0Z:/etc/mysql# mysql -u root -p
Enter password: 
ERROR 2002 (HY000): Can&#39;t connect to local MySQL server through socket &#39;/var/run/mysqld/mysqld.sock&#39; (2)
root@iZ28z558vv0Z:/b# service mysql start
start: Job failed to start
root@iZ28z558vv0Z:/var/lib# service mysqld start
mysqld: unrecognized service

Copy after login

Solution: Find the configuration file of mysql my.cnf:

root@iZ28z558vv0Z:/etc/mysql# ls
conf.d debian.cnf debian-start my.cnf
root@iZ28z558vv0Z:/etc/mysql# vi my.cnf

Copy after login

The datadir in the file displays /var/lib/mysql

[mysqld]
#
# * Basic Settings
#
user   = mysql
pid-file  = /var/run/mysqld/mysqld.pid
socket   = /var/run/mysqld/mysqld.sock
port   = 3306
basedir   = /usr
datadir   = /var/lib/mysql
tmpdir   = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking

Copy after login

because there is insufficient disk space. , so we need to check the location where mysql saves the data, the usage of the disk space where datadir or tmpdir is located, and check the usage of the disk space where datadir is located:

root@iZ28z558vv0Z:/var# df /var
Filesystem  1K-blocks  Used Available Use% Mounted on
/dev/xvda1  41151808 39038392   0 100% /

Copy after login

It can be seen from the above that the disk space availability rate is obviously 0, which is the reason why mysql cannot start. Delete the

other files in the /var directory to free up disk space to solve the problem, and then restart the mysql service.

Summary

[Related recommendations]

Mysql free video tutorial

Detailed explanation of innodb_index_stats when importing data Error prompting table primary key conflict

Example details innodb_autoinc_lock_mode in mysql

Detailed example of adding new user permissions in MySQL##5.

Detailed example of init_connect method in mysql

The above is the detailed content of What should I do if the disk space in Ubuntu is full and mysql cannot be started?. For more information, please follow other related articles on the PHP Chinese website!