今天程度说mysql表被锁了，mysql不能用了。。
于是查看服务器各个状态，正常。但是killall -9 mysqld 之后，mysql就再也起不来了，那一点点转啊转，都三行了，才出现一个【失败】。。
tail -f /mysql/data/xxxx.com.err 日志，发现很多
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
100301 10:00:02 InnoDB: Retrying to lock the first data file
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
再df -h 一下查看磁盘空间，mysql那个分区用了100%，就是这个问题。把不需要的文件删除了。
[root@xxxx ~]# /etc/init.d/mysqld start
Starting MySQL. [确定]
ok,终于启动了。。
阅读(1139) | 评论(0) | 转发(0) |
