mysql no space_linux "No space left on device" 磁盘空间解决办法

1.查看磁盘空间

df -h

[root@izbp190idbje1fp4hnpk54z /]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/vda1 40G 23G 15G 61% /

devtmpfs 3.9G 0 3.9G 0% /dev

tmpfs 3.9G 0 3.9G 0% /dev/shm

tmpfs 3.9G 376K 3.9G 1% /run

tmpfs 3.9G 0 3.9G 0% /sys/fs/cgroup

tmpfs 783M 0 783M 0% /run/user/0

2.进入根目录cd /，(磁盘占用的升序排列)

du -h --max-depth=1du：

[root@izbp190idbje1fp4hnpk54z /]# du -h --max-depth=1du：

0 ./sys

0 ./dev

100K ./tmp

430M ./root

12K ./opt

4.0K ./media

du: cannot access ‘./proc/30369/task/30369/fd/4’: No such file or directory

du: cannot access ‘./proc/30369/task/30369/fdinfo/4’: No such file or directory

du: cannot access ‘./proc/30369/fd/4’: No such file or directory

du: cannot access ‘./proc/30369/fdinfo/4’: No such file or directory

0 ./proc

460M ./var

376K ./run

313M ./profile

4.0K ./srv

36M ./etc

15G ./home

4.0K ./mnt

143M ./boot

6.2G ./usr

16K ./lost+found

23G .