启动MySql提示失:The server quit without updating PID file(…)
mysql -uroot -p登录提示:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
原因1.竟然是:磁盘满了
解决方案:
方案1:扩容(步骤可能较多)
方案2:如果是只有一个主mysql,把bin-log日志mv到别的硬盘,重启mysql,
原因2.
mysqld 服务已down掉,但其僵尸进程仍然存在,用ps查看(ps -ef|grep mysql),而用netstat -altnp查看却没有mysql的监听服务
root@localhost ~]# ps -ef|grep mysql
mysql 2546 1 0 13:08 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
mysql 2708 2546 4 13:08 ? 00:00:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock
root 2744 2269 0 13:08 pts/0 00:00:00 grep --color=auto mysql
[root@localhost ~]# kill -9 2546
[root@localhost ~]# kill -9 2708
[root@localhost ~]# service mysql start