【工作笔记_私20210917】Liunx系统硬盘容量不足

问题

情况：mysql数据库突然挂掉了

// 无法启动mysql服务
[root@lyg-cl-3 mysql]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

排查

1、mysql status

可以看到mysql的启动情况

Failed to start MySQL Server
Plugin 'InnoDB' registration as a STORAGE ENGINE failed解决方法

innoDB好像初始化失败

2、查看/etc/my.cnf

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[mysqld]
character_set_server=utf8
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
# mysql安装的目录
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
federated
sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
lower_case_table_names=1
# 错误日志保存的路径log-error
log-error=/var/log/mysqld.log
#log-error=/mnt/vdc1/files/mysql-backup/mysqld-error.log
pid-file=/var/run/mysqld/mysqld.pid
#wait_timeout=31536000
wait_timeout=600
#interactive_timeout=31536000
interactive_timeout=600
max_allowed_packet=20M

3、查看错误日志log-error=/var/log/mysqld.log

4、发现容量不足

[root@lyg-cl-3 ~]# df -h
文件系统                 容量  已用  可用 已用% 挂载点
/dev/mapper/centos-root   50G   50G   20K  100% /
devtmpfs                 7.8G     0  7.8G    0% /dev
tmpfs                    7.8G     0  7.8G    0% /dev/shm
tmpfs                    7.8G  858M  7.0G   11% /run
tmpfs                    7.8G     0  7.8G    0% /sys/fs/cgroup
/dev/vda1               1014M  142M  873M   14% /boot
/dev/vdc1                197G  2.9G  184G    2% /mnt/vdc1
/dev/mapper/centos-home   46G   33M   46G    1% /home
tmpfs                    1.6G     0  1.6G    0% /run/user/0

可以看到mysql所在的盘已经满了

5、发现40GB的log文件

解决

1、日志文件移动到/mnt/vdc1/挂载盘下

2、重启mysql

可使用如下命令启动MySQL：

service mysqld start

或者使用如下命令：

/etc/init.d/mysqld start


可使用如下命令重新启动MySQL：

service mysqld restart

或者使用如下命令：

/etc/init.d/mysqld restart
————————————————
版权声明：本文为CSDN博主「菜鸟柱子」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/xinpz/article/details/84583704/

3、关闭查询日志输出

-- 查看日志输出设置情况
show global variables like '%log%';

参考文献

1. linux命令启动MySQL
2. 如何查看linux系统的存储空间大小,linux 如何查看硬盘大小,存储空间大小等系统信息及硬件信息…
3. MySql 的操作日志 历史记录
4. Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed解决方法
5. MySQL 强行kill后启动失败问题：[ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
6. [mysql]错误解决之"Failed to start MySQL Server"
7. 连接mysql出现错误：Can’t connect to local MySQL server through socket '/var/lib/mysql/mysql.soc
8. MySQL报错的解决’Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’