[求助] 后台修改mysql优化方案后, mysql无法启动

dan

正在安装phpwind9.0正式版, 安装中的第二步创建数据库那里, 提交后总是显示504, 于是进后台修改sql的优化方案为"一般".
然后就后台显示数据库没有连接之类的提示, 用SSH, 重启mysqld, 也提示error.
打开mysql的出错日志文件显示如下: 请大大们帮忙分析一下原因, 应该怎么处理, 谢谢!

1. Version: '5.1.63'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
   
2. 130110 19:02:08 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Normal shutdown
   
3. 
   
4. 130110 19:02:08 [Note] Event Scheduler: Purging the queue. 0 events
   
5. 130110 19:02:09 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown comple
   
6. te
   
7. 
   
8. 130110 19:02:10 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/d
   
9. anrun.pid ended
   
10. 130110 19:02:10 mysqld_safe Starting mysqld daemon with databases from /www/wdli
    
11. nux/mysql-5.1.63/var
    
12. 130110 19:02:15 [Note] Event Scheduler: Loaded 0 events
    
13. 130110 19:02:15 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: ready for conne
    
14. ctions.
    
15. Version: '5.1.63'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
    
16. 130110 19:08:11 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Normal shutdown
    
17. 
    
18. 130110 19:08:11 [Note] Event Scheduler: Purging the queue. 0 events
    
19. 130110 19:08:13 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown comple
    
20. te
    
21. 
    
22. 130110 19:08:13 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/d
    
23. anrun.pid ended
    
24. 130110 19:08:14 mysqld_safe Starting mysqld daemon with databases from /www/wdli
    
25. nux/mysql-5.1.63/var
    
26. 130110 19:08:14 [ERROR] /www/wdlinux/mysql-5.1.63/libexec/mysqld: unknown option
    
27. '--skip-innodb'
    
28. 130110 19:08:14 [ERROR] Aborting
    
29. 
    
30. 130110 19:08:14 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown comple
    
31. te
    
32. 
    
33. 130110 19:08:14 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/d
    
34. anrun.pid ended
    
35. 130110 19:14:32 mysqld_safe Starting mysqld daemon with databases from /www/wdli
    
36. nux/mysql-5.1.63/var
    
37. 130110 19:14:33 [ERROR] /www/wdlinux/mysql-5.1.63/libexec/mysqld: unknown option
    
38. '--skip-innodb'
    
39. 130110 19:14:33 [ERROR] Aborting
    
40. 
    
41. 130110 19:14:33 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown comple
    
42. te
    
43. 
    
44. 130110 19:14:33 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/d
    
45. anrun.pid ended
    
46. 130110 19:15:18 mysqld_safe Starting mysqld daemon with databases from /www/wdli
    
47. nux/mysql-5.1.63/var
    
48. 130110 19:15:18 [ERROR] /www/wdlinux/mysql-5.1.63/libexec/mysqld: unknown option
    
49. '--skip-innodb'
    
50. 130110 19:15:18 [ERROR] Aborting
    
51. 
    
52. 130110 19:15:18 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown comple
    
53. te
    
54. 
    
55. 130110 19:15:18 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/d
    
56. anrun.pid ended
    
57. [root@danrun var]# cd /
    
58. [root@danrun /]# service mysqld stop
    
59. ERROR! MySQL manager or server PID file could not be found!

复制代码

dan

当前系统进程:

1. [root@danrun ~]# top
   
2. top - 19:46:45 up 3 min,  1 user,  load average: 0.07, 0.11, 0.05
   
3. Tasks:  24 total,   1 running,  23 sleeping,   0 stopped,   0 zombie
   
4. Cpu(s):  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
   
5. Mem:   1048576k total,    79848k used,   968728k free,        0k buffers
   
6. Swap:        0k total,        0k used,        0k free,        0k cached
   
7. 
   
8.   PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
   
9.     1 root      17   0  2884 1340 1164 S  0.0  0.1   0:00.31 init
   
10. 1149 root      14  -4  2476  552  324 S  0.0  0.1   0:00.00 udevd
    
11. 1363 root      18   0 35612 1320  996 S  0.0  0.1   0:00.00 rsyslogd
    
12. 1376 root      18   0  8492 1004  524 S  0.0  0.1   0:00.00 sshd
    
13. 1383 root      17   0  3188  896  708 S  0.0  0.1   0:00.00 xinetd
    
14. 1595 root      18   0  8700  760  328 S  0.0  0.1   0:00.00 saslauthd
    
15. 1596 root      18   0  8700  496   64 S  0.0  0.0   0:00.00 saslauthd
    
16. 1603 root      15   0 11412 3708 2996 S  0.0  0.4   0:00.08 sshd
    
17. 1605 root      18   0 28348  10m 3972 S  0.0  1.1   0:00.15 httpd
    
18. 1616 root      18   0  7148  848  304 S  0.0  0.1   0:00.00 nginx
    
19. 1617 www       20   0  8180 2116  552 S  0.0  0.2   0:00.00 nginx
    
20. 1618 www       18   0  8180 2116  552 S  0.0  0.2   0:00.00 nginx
    
21. 1619 www       18   0  8180 2100  536 S  0.0  0.2   0:00.00 nginx
    
22. 1625 root      15   0  6264 1656 1416 S  0.0  0.2   0:00.00 bash
    
23. 1632 www       18   0 28348 9292 2092 S  0.0  0.9   0:00.00 httpd
    
24. 1633 www       18   0 28348 9292 2092 S  0.0  0.9   0:00.00 httpd
    
25. 1634 www       18   0 28348 9292 2092 S  0.0  0.9   0:00.00 httpd
    
26. 1635 www       18   0 28348 9292 2092 S  0.0  0.9   0:00.00 httpd
    
27. 1636 www       18   0 28348 9292 2092 S  0.0  0.9   0:00.00 httpd
    
28. 1645 root      15   0  2560 1068  888 R  0.0  0.1   0:00.06 top
    
29. 1646 root      18   0  7984  528  264 S  0.0  0.1   0:00.00 pure-ftpd
    
30. 1653 root      18   0 23488 8276 2836 S  0.0  0.8   0:00.00 httpd
    
31. 1660 root      18   0  7056 1192  632 S  0.0  0.1   0:00.00 crond
    
32. 1667 wdcpu     18   0 23488 7208 1756 S  0.0  0.7   0:00.00 httpd

复制代码

admin

vi /etc/my.cnf
把
--skip-innodb
这行删除,再重起mysql