事情发生在5日,视频“L10-008-lamp环境之MySQL多实例安装配置指南”看到第2857秒的时候。
在视频里,oldboy故意让多实例启动没有成功,并进行处理。但我在按照视频里的操作步骤执行时,却出现问题。授权、删除文件之后,重新初始化数据库文件,在启动显示正常的情况下,“netstat”命令却没有显示启动成功。于是,我又一次陷入解决问题的漫长过程。
先是根据错误日志,去百度查资料:[root@Web 3306]# tail mysql_oldboy3306.err
InnoDB: Setting log file ./ib_logfile2 size to 4 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
140605 16:37:06 InnoDB: Started; log sequence number 0 0
/usr/local/mysql/libexec/mysqld: Error writing file '/data/3306/slow.log' (Errcode: 28)
:
:
[root@Web 3306]# tail /data/3307/mysql_oldboy3307.err
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html
InnoDB: Error in creating ./ibdata1: probably out of disk space
140605 16:37:05 [ERROR] Plugin 'InnoDB' init function returned error.
140605 16:37:05 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
/usr/local/mysql/libexec/mysqld: Error writing file '/data/3307/slow.log' (Errcode: 28)
140605 16:37:06 [ERROR] Unknown/unsupported table type: InnoDB
140605 16:37:06 [ERROR] Aborting
140605 16:37:06 mysqld_safe mysqld from pid file /data/3307/mysqld.pid ended
但是,根据日志里信息,在百度上找到的信息没有一点有用的。当然,上面的信息也不过是一小部分。
在想办法的过程中,我曾经多次只保留目录里的2个文件:[root@Web 3306]# ll
total 5
drwxr-xr-x 4 mysql mysql 1024 Jun 5 20:30 data
-rw-r--r-- 1 mysql mysql 1887 Apr 12 2012 my.cnf
-rwx------ 1 mysql mysql 1053 Apr 12 2012 mysql
但就是没有敢删除data目录里的mysql子目录里的文件,因为mysql目录里面的文