启用mysql出现错误
Starting MySQL..................................................................................................... * The server quit without updating PID file (/usr/local/mysql/var/li569-55.pid).
不知道是那个，贴出错误时间段内的日志。
日志文件：
文件：li569-55.err
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
140221 22:48:45InnoDB: Unable to open the first data file
InnoDB: Error in opening /usr/local/mysql/var/ibdata1
140221 22:48:45InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
140221 22:48:45 InnoDB: Could not open or create data files.
140221 22:48:45 InnoDB: If you tried to add new data files, and it failed here,
140221 22:48:45 InnoDB: you should now edit innodb_data_file_path in my.cnf back
140221 22:48:45 InnoDB: to what it was, and remove the new ibdata files InnoDB created
140221 22:48:45 InnoDB: in this failed attempt. InnoDB only wrote those files full of
140221 22:48:45 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
140221 22:48:45 InnoDB: remove old data files which contain your precious data!
140221 22:48:45 Plugin 'InnoDB' init function returned error.
140221 22:48:45 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140221 22:48:45 Unknown/unsupported storage engine: InnoDB
140221 22:48:45 Aborting
140221 22:48:45 /usr/local/mysql/bin/mysqld: Shutdown complete
140221 22:48:45 mysqld_safe mysqld from pid file /usr/local/mysql/var/li569-55.pid ended
文件：localhost.err
140221 22:59:36 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.pid ended
140221 23:00:57 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
140221 23:00:58 InnoDB: The InnoDB memory heap is disabled
140221 23:00:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140221 23:00:58 InnoDB: Compressed tables use zlib 1.2.3.4
140221 23:00:58 InnoDB: Initializing buffer pool, size = 16.0M
140221 23:00:58 InnoDB: Completed initialization of buffer pool
140221 23:00:58 InnoDB: highest supported file format is Barracuda.
140221 23:00:58InnoDB: Waiting for the background threads to start
140221 23:00:59 InnoDB: 1.1.8 started; log sequence number 5518279
140221 23:00:59 Server hostname (bind-address): '0.0.0.0'; port: 3306
140221 23:00:59 - '0.0.0.0' resolves to '0.0.0.0';
140221 23:00:59 Server socket created on IP: '0.0.0.0'.
140221 23:00:59 Event Scheduler: Loaded 0 events
140221 23:00:59 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.28-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
140221 23:01:50 mysqld_safe A mysqld process already exists
140221 23:27:48 IP address '111.73.45.49' could not be resolved: Temporary failure in name resolution 安装时开启innodb了没？
删除ib_logfile0, ib_logfile1这些文件后启动试试
回复 2# 的帖子
不知道，默认安装的，重启后没任何问题，后来按照http://yinlenc.wordpress.com/2010/09/27/mysqlinnodb-recover/这个帖子查看下 重启没问题是有启动innodb的。
页:
[1]