平时用得好好的创建数据库的命令,突然间用不了了,今天把MySQL重启,发现无法启动,终端输出信息为
Starting mysqld daemon with databases from /usr/local/mysql/var
091104 12:28:16 mysqld restarted
/usr/local/mysql/bin/mysqld_safe: line 390: 7558 Killed nohup /usr/local/mysql/libexec/mysqld –basedir=/usr/local/mysql –datadir=/usr/local/mysql/var –user=mysql –pid-file=/usr/local/mysql/var/s1.1199.com.pid –skip-external-locking –port=3306 –socket=/tmp/mysql.sock >> /usr/local/mysql/var/s1.1199.com.err 2>&1
Number of processes running now: 0
ps aux |grep mysql
发现有如下进程
ps aux |grep mysql
root 23070 0.2 0.0 63824 1212 pts/1 S 12:19 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe
mysql 26295 112 0.0 0 0 pts/1 Zl 12:22 0:01 [mysqld] <defunct>
cd /usr/local/mysql/var/
more s1.1199.com.err
发现错误如下
091104 12:19:29 mysqld started
/usr/local/mysql/libexec/mysqld: Error writing file ‘/usr/local/mysql/var/s1-slow.log’ (Errcode: 28)
091104 12:19:29 [ERROR] Could not use /usr/local/mysql/var/s1-slow.log for logging (error 28). Turning logging off for the whole dur
ation of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
091104 12:19:30 InnoDB: Started; log sequence number 0 1511759772
091104 12:19:30 [ERROR] /usr/local/mysql/libexec/mysqld: Error writing file ‘/usr/local/mysql/var/s1.1199.com.pid’ (Errcode: 28)
091104 12:19:30 [ERROR] Can’t start server: can’t create PID file: No space left on device
df -h看了下
发现硬盘满了,删除掉多余文件,启动MySQL就可以了。