运行中出现:error!mysql is running but PID file could not be found

一人天

1. 130630 16:41:51 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
   
2. 130630 16:41:51 InnoDB: The InnoDB memory heap is disabled
   
3. 130630 16:41:51 InnoDB: Mutexes and rw_locks use GCC atomic builtins
   
4. 130630 16:41:51 InnoDB: Compressed tables use zlib 1.2.3
   
5. 130630 16:41:51 InnoDB: Initializing buffer pool, size = 16.0M
   
6. 130630 16:41:51 InnoDB: Completed initialization of buffer pool
   
7. InnoDB: The first specified data file /usr/local/mysql/var/ibdata1 did not exist:
   
8. InnoDB: a new database to be created!
   
9. 130630 16:41:51 InnoDB: Setting file /usr/local/mysql/var/ibdata1 size to 10 MB
   
10. InnoDB: Database physically writes the file full: wait...
    
11. 130630 16:41:51 InnoDB: Log file /usr/local/mysql/var/ib_logfile0 did not exist: new to be created
    
12. InnoDB: Setting log file /usr/local/mysql/var/ib_logfile0 size to 5 MB
    
13. InnoDB: Database physically writes the file full: wait...
    
14. 130630 16:41:51 InnoDB: Log file /usr/local/mysql/var/ib_logfile1 did not exist: new to be created
    
15. InnoDB: Setting log file /usr/local/mysql/var/ib_logfile1 size to 5 MB
    
16. InnoDB: Database physically writes the file full: wait...
    
17. InnoDB: Doublewrite buffer not found: creating new
    
18. InnoDB: Doublewrite buffer created
    
19. InnoDB: 127 rollback segment(s) active.
    
20. InnoDB: Creating foreign key constraint system tables
    
21. InnoDB: Foreign key constraint system tables created
    
22. 130630 16:41:52 InnoDB: Waiting for the background threads to start
    
23. 130630 16:41:53 InnoDB: 1.1.8 started; log sequence number 0
    
24. 130630 16:41:53 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    
25. 130630 16:41:53 [Note] - '0.0.0.0' resolves to '0.0.0.0';
    
26. 130630 16:41:53 [Note] Server socket created on IP: '0.0.0.0'.
    
27. 130630 16:41:53 [Note] Event Scheduler: Loaded 0 events
    
28. 130630 16:41:53 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
    
29. Version: '5.5.28-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
    
30. 130630 16:41:54 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown
    
31. 
    
32. 130630 16:41:54 [Note] Event Scheduler: Purging the queue. 0 events
    
33. 130630 16:41:54 InnoDB: Starting shutdown...
    
34. 130630 16:41:55 InnoDB: Shutdown completed; log sequence number 1595675
    
35. 130630 16:41:55 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
    
36. 
    
37. 130630 16:41:55 mysqld_safe mysqld from pid file /usr/local/mysql/var/AY1306300803061624a9Z.pid ended
    
38. 130630 16:41:56 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
    
39. 130630 16:41:56 InnoDB: The InnoDB memory heap is disabled
    
40. 130630 16:41:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    
41. 130630 16:41:56 InnoDB: Compressed tables use zlib 1.2.3
    
42. 130630 16:41:56 InnoDB: Initializing buffer pool, size = 16.0M
    
43. 130630 16:41:56 InnoDB: Completed initialization of buffer pool
    
44. "AY1306300803061624a9Z.err" 160L, 10010C

复制代码

puffbaby

ps aux |grep mysql
看下mysql 进程呗
应该是卡死 了

然后再
kill XXXX
XXX 是那个mysql的进程号 有几个
就KILL 几个，全部KILL掉
然后再重启试试

licess

InnoDB: Database physically writes the file full: wait...
看这个是当前分区或硬盘已满

一人天

KILL 掉之后,start不了.一直....

可恶的一小时两个贴子

删掉了mysql/var里面的0000日志文件也是无法启动


确实是磁盘满了.谢谢各位

[ 本帖最后由 一人天 于 2013-10-19 15:27 编辑 ]

licess

你这是看的inode占用，不是看的硬盘容量占用，df -h 是看硬盘容量占用