mysql启动一直报ERROR的错误。

ujjidt

　昨天晚上一个流量监控，发现无法连接数据库了。上主机一看是Mysql无法启动，用service mysqld start启动一直报ＥＲＲＯＲ错误。mysqld_safe &　启动也不行。原来想找日志看一下什么问题？
　找了日志也找了半天，因为/var/log/mysql.log里面是空的。最后在data里面找到一个localhost.err，打开一个也迷茫了好一会。把日志公布一下：
080921 00:44:20  mysqld started
080921  0:44:20 [Warning] Although a path was specified for the --log option, log tables are used. To enable logging to files use the --log-output option.
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.
080921  0:44:20  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
InnoDB: Check that you do not already have another mysqld process

G/usr/local/mysql/bin/mysqld: Disk is full writing './mysql-bin.000032' (Errcode: 2. Waiting for someone to free space... Retry in 60 secs
^G/usr/local/mysql/bin/mysqld: Disk is full writing './mysql-bin.000032' (Errcode: 2. Waiting for someone to free space... Retry in 60 secs
^G/usr/local/mysql/bin/mysqld: Disk is full writing './mysql-bin.000032' (Errcode: 2. Waiting for someone to free space... Retry in 60 secs
^G/usr/local/mysql/bin/mysqld: Disk is full writing './mysql-bin.000032' (Errcode: 2. Waiting for someone to free space... Retry in 60 secs
^G/usr/local/mysql/bin/mysqld: Disk is full writing './mysql-bin.000032' (Errcode: 2. Waiting for someone to free space... Retry in 60 secs
^G/usr/local/mysql/bin/mysqld: Disk is full writing './mysql-bin.000032' (Errcode: 2. Waiting for someone to free space... Retry in 60 secs

开始的时候没有发现disk is full的日志，可能是没有注意看吧。一直都是搜索InnoDB: Unable to lock ./ibdata1, error: 11的错误信息，一无所获。贴子也不多！今天早上到机房看机器，开机的时候没有任何错误。就是到启动mysqld的时候报错。。。
　无耐还是看日志吧，仔细观察发现./mysql-bin.000032无法进入。。。。最后用df -h看了一下磁盘才发财原来/usr已经没有空闲空间了。奇怪了，我的/usr虽然只１０Ｇ，但是里面也没有写入什么东西的，怎么会一下就满了。去/usr/里面一看发现/data/下面的/mysq-bin.xxxx占用的空间巨大。有5G之多。因为对此文件之前并不是太了解，最后搜索一次才知道原来是和mysqldump恢复有关的，我一般也不需要用这项功能，就先删除了一些之类的文件。。。再启动mysqld，一切正常。。。
　不过，有几个问题还不是搞的太清楚想问一下。
　１、我mysqld的日志文件本来是在/var/log/mysql.log里面的。为什么mysqld一出问题，这里面就写不进去信息。里面也就是空的了。
　２、mysql-bin文件还有什么其它的功能吗，如果将他刚全部删除，需要注意什么不？还有对数据会不会有什么影响？
　暂时就这些吧，呵，等想到了再说说。。。谢谢各位了!

denniswwh

mysql-bin是二进制日志，做即时点恢复和复制时会用到，如果你没有做复制，并且已经备份好了，可以只保留最后一个，删除其他的。

yueliangdao0608

Check that you do not already have another mysqld process

gogo407

原帖由 ujjidt 于 2008-9-21 09:38 发表
　昨天晚上一个流量监控，发现无法连接数据库了。上主机一看是Mysql无法启动，用service mysqld start启动一直报ＥＲＲＯＲ错误。mysqld_safe &　启动也不行。原来想找日志看一下什么问题？
　找了日志也找了半 ...

描述得很详细，如果你的只是作为监控流量的话，完全可以停用bin-log
bin-log是做replication
和恢复用的：）