Centos7.3
Mysql 5.7
分区信息如下
df -hFilesystem Size Used Avail Use% Mounted on
/dev/mapper/cl_gr61-root 50G 6.6G 44G 14% /
devtmpfs 3.9G 0 3.9G 0% /dev
tmpfs 3.9G 0 3.9G 0% /dev/shm
tmpfs 3.9G 8.3M 3.9G 1% /run
tmpfs 3.9G 0 3.9G 0% /sys/fs/cgroup
/dev/sda2 1014M 157M 858M 16% /boot
/dev/sda1 200M 9.5M 191M 5% /boot/efi
/dev/mapper/cl_gr61-home 68G 1.7G 67G 3% /home
tmpfs 782M 0 782M 0% /run/user/0
Centos7 默认XFS格式分区
查询mysql配置信息,默认存储地址在/var/lib/mysqlcat /etc/my.cnf
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
方案一,减小(/home)分区空间,加大(/)根分区空间,不适合生产环境。
安装备份工具,备份home分区。yum install xfsdump
xfsdump -f /home.xfsdump /home
please enter label for this dump session (timeout in 300 sec)
-> home
please enter label for media in drive 0 (timeout in 300 sec)
-> home
将home分区取消挂载,缩减到10G(会破坏数据,一定要备份)。umount /home
lvreduce -L 10G /dev/cl_gr61/home
扩展root分区lvextend -l +100%FREE /dev/cl_gr61/root
xfs_growfs /dev/cl_gr61/root
重新格式化home分区为xfs格式,挂载home分区,还原数据。mkfs.xfs -f /dev/cl_gr61/home
xfsrestore /home.xfsdump /home
mount /home
完成后,分区信息如下
df -hFilesystem Size Used Avail Use% Mounted on
/dev/mapper/cl_gr61-root 108G 9.1G 99G 9% /
devtmpfs 3.9G 0 3.9G 0% /dev
tmpfs 3.9G 0 3.9G 0% /dev/shm
tmpfs 3.9G 8