mysql启动失败 问题解决

摘自：http://1.1lifes.sinaapp.com/?p=186

我是linux新手，安装软件也是胡乱安装，找了一篇文章。将mysql安装到一个特定文件下了，但后来压测handlersocket，mysql突然crash了。去启动怎么也启动不了，无奈呀！我安装mysql的文件夹在/opt/yq下，启动不了，自然去找错误日志了，但因为安装文件使用的默认方式，google了一下，说在按安装路径的data下，也确实找到了相关日志文件，文件名为***.err文件，发现里面的内容很旧，郁闷。说明后面启动mysql的错误日志没在这里。那在哪里呢？继续找，google后发现/data/mysql/下会有相关的日志，到里面后发现里面除了错误日志文件外还有数据文件，查看里面的错误日志：

111217 23:23:57  InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… InnoDB: Last MySQL binlog file position 0 406839588, file name ./mysql-bin.000012 111217 23:23:58  InnoDB: Waiting for the background threads to start 111217 23:23:59 InnoDB: 1.1.8 started; log sequence number 3430959679 handlersocket: not listening for reads handlersocket: not listening for writes handlersocket: initialized 111217 23:23:59 [Note] Recovering after a crash using mysql-bin 111217 23:24:04 [ERROR] Error in Log_event::read_log_event(): 'read error', data_len: 749, event_type: 23 111217 23:24:04 [Note] Starting crash recovery… 111217 23:24:04 [Note] Crash recovery finished. /opt/yq/mysql/bin/mysqld: Disk is full writing './mysql-bin.~rec~' (Errcode: 28). Waiting for someone to free space… (Expect up to 60 secs delay for server to continue after freeing disk space)

发现红色部分，原来是磁盘满了，狂晕！ll -lh查看了一下文件大小 mysql-bin 数据库备份文件太大了，删除，重启问题解决了，哈哈！不错！