MySQL数据库重启操作

1.查看挂载点及空间

# df -hl
Filesystem                Size  Used Avail Use% Mounted on
/dev/mapper/LVGroup-root   32G  9.1G   22G  30% /
devtmpfs                   12G     0   12G   0% /dev
tmpfs                      12G     0   12G   0% /dev/shm
tmpfs                      12G  161M   12G   2% /run
tmpfs                      12G     0   12G   0% /sys/fs/cgroup
/dev/mapper/LVGroup-data  298G  146G  137G  52% /data
/dev/sda1                 497M  128M  370M  26% /boot
tmpfs                     2.4G     0  2.4G   0% /run/user/501
tmpfs                     2.4G     0  2.4G   0% /run/user/0

2.查看MySQL重启前进程
# ps -ef |grep mysql
root      5098     1  0 Mar31 ?        00:00:00 /bin/sh /usr/local/mysql//bin/mysqld_safe --datadir=/data/ --pid-file=/data/DB.pid
mysql     5844  5098 50 Mar31 ?        76-14:56:45 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql/ --datadir=/data --plugin-dir=/usr/local/mysql//lib/plugin --user=mysql --log-error=/var/log/mysql_error.log --open-files-limit=65535 --pid-file=/data/DB.pid --socket=/tmp/mysql.sock

# systemctl status mysqld
● mysqld.service - LSB: start and stop MySQL
   Loaded: loaded (/etc/rc.d/init.d/mysqld)
   Active: inactive (dead)
     Docs: man:systemd-sysv-generator(8)

查看重启mysqld服务前有无报错信息
# tail -500  /var/log/mysql_error.log |more

2.关闭MySQL服务

# systemctl stop mysqld
# ps -ef |grep mysql
# systemctl status mysqld

3.启动MySQL

# systemctl start mysqld

查看mysqld状态

# systemctl status mysqld

查看报错信息
# tail -500  /var/log/mysql_error.log |more