启用mysql出现错误

ciihom

Starting MySQL
..................................................................................................... * The server quit without updating PID file (/usr/local/mysql/var/li569-55.pid).

不知道是那个，贴出错误时间段内的日志。
日志文件：
文件：li569-55.err

1. InnoDB: Check that you do not already have another mysqld process
   
2. InnoDB: using the same InnoDB data or log files.
   
3. InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
   
4. InnoDB: Check that you do not already have another mysqld process
   
5. InnoDB: using the same InnoDB data or log files.
   
6. 140221 22:48:45  InnoDB: Unable to open the first data file
   
7. InnoDB: Error in opening /usr/local/mysql/var/ibdata1
   
8. 140221 22:48:45  InnoDB: Operating system error number 11 in a file operation.
   
9. InnoDB: Error number 11 means 'Resource temporarily unavailable'.
   
10. InnoDB: Some operating system error numbers are described at
    
11. InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
    
12. 140221 22:48:45 InnoDB: Could not open or create data files.
    
13. 140221 22:48:45 InnoDB: If you tried to add new data files, and it failed here,
    
14. 140221 22:48:45 InnoDB: you should now edit innodb_data_file_path in my.cnf back
    
15. 140221 22:48:45 InnoDB: to what it was, and remove the new ibdata files InnoDB created
    
16. 140221 22:48:45 InnoDB: in this failed attempt. InnoDB only wrote those files full of
    
17. 140221 22:48:45 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
    
18. 140221 22:48:45 InnoDB: remove old data files which contain your precious data!
    
19. 140221 22:48:45 [ERROR] Plugin 'InnoDB' init function returned error.
    
20. 140221 22:48:45 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    
21. 140221 22:48:45 [ERROR] Unknown/unsupported storage engine: InnoDB
    
22. 140221 22:48:45 [ERROR] Aborting
    
23. 
    
24. 140221 22:48:45 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
    
25. 
    
26. 140221 22:48:45 mysqld_safe mysqld from pid file /usr/local/mysql/var/li569-55.pid ended

复制代码

文件：localhost.err

1. 140221 22:59:36 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.pid ended
   
2. 140221 23:00:57 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
   
3. 140221 23:00:58 InnoDB: The InnoDB memory heap is disabled
   
4. 140221 23:00:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins
   
5. 140221 23:00:58 InnoDB: Compressed tables use zlib 1.2.3.4
   
6. 140221 23:00:58 InnoDB: Initializing buffer pool, size = 16.0M
   
7. 140221 23:00:58 InnoDB: Completed initialization of buffer pool
   
8. 140221 23:00:58 InnoDB: highest supported file format is Barracuda.
   
9. 140221 23:00:58  InnoDB: Waiting for the background threads to start
   
10. 140221 23:00:59 InnoDB: 1.1.8 started; log sequence number 5518279
    
11. 140221 23:00:59 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    
12. 140221 23:00:59 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    
13. 140221 23:00:59 [Note] Server socket created on IP: '0.0.0.0'.
    
14. 140221 23:00:59 [Note] Event Scheduler: Loaded 0 events
    
15. 140221 23:00:59 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
    
16. Version: '5.5.28-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
    
17. 140221 23:01:50 mysqld_safe A mysqld process already exists
    
18. 140221 23:27:48 [Warning] IP address '111.73.45.49' could not be resolved: Temporary failure in name resolution

复制代码

licess

安装时开启innodb了没？
删除ib_logfile0, ib_logfile1这些文件后启动试试

ciihom

不知道，默认安装的，重启后没任何问题，后来按照http://yinlenc.wordpress.com/2010/09/27/mysqlinnodb-recover/
这个帖子查看下 重启没问题是有启动innodb的。