中国真实偷乱视频,东京道一本热中文字幕,久久精品国产99国产精品亚洲,欧美激情一区二区三区在线

Board logo

標(biāo)題: [求助] 后臺修改mysql優(yōu)化方案后, mysql無法啟動(dòng) [打印本頁]

作者: dan    時(shí)間: 2013-1-10 19:52     標(biāo)題: 后臺修改mysql優(yōu)化方案后, mysql無法啟動(dòng)

正在安裝phpwind9.0正式版, 安裝中的第二步創(chuàng)建數(shù)據(jù)庫那里, 提交后總是顯示504, 于是進(jìn)后臺修改sql的優(yōu)化方案為"一般".
然后就后臺顯示數(shù)據(jù)庫沒有連接之類的提示, 用SSH, 重啟mysqld, 也提示error.
打開mysql的出錯(cuò)日志文件顯示如下: 請大大們幫忙分析一下原因, 應(yīng)該怎么處理, 謝謝!

  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. 130110 19:02:08 [Note] Event Scheduler: Purging the queue. 0 events
  4. 130110 19:02:09 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown comple
  5. te

  6. 130110 19:02:10 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/d
  7. anrun.pid ended
  8. 130110 19:02:10 mysqld_safe Starting mysqld daemon with databases from /www/wdli
  9. nux/mysql-5.1.63/var
  10. 130110 19:02:15 [Note] Event Scheduler: Loaded 0 events
  11. 130110 19:02:15 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: ready for conne
  12. ctions.
  13. Version: '5.1.63'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
  14. 130110 19:08:11 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Normal shutdown

  15. 130110 19:08:11 [Note] Event Scheduler: Purging the queue. 0 events
  16. 130110 19:08:13 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown comple
  17. te

  18. 130110 19:08:13 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/d
  19. anrun.pid ended
  20. 130110 19:08:14 mysqld_safe Starting mysqld daemon with databases from /www/wdli
  21. nux/mysql-5.1.63/var
  22. 130110 19:08:14 [ERROR] /www/wdlinux/mysql-5.1.63/libexec/mysqld: unknown option
  23. '--skip-innodb'
  24. 130110 19:08:14 [ERROR] Aborting

  25. 130110 19:08:14 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown comple
  26. te

  27. 130110 19:08:14 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/d
  28. anrun.pid ended
  29. 130110 19:14:32 mysqld_safe Starting mysqld daemon with databases from /www/wdli
  30. nux/mysql-5.1.63/var
  31. 130110 19:14:33 [ERROR] /www/wdlinux/mysql-5.1.63/libexec/mysqld: unknown option
  32. '--skip-innodb'
  33. 130110 19:14:33 [ERROR] Aborting

  34. 130110 19:14:33 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown comple
  35. te

  36. 130110 19:14:33 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/d
  37. anrun.pid ended
  38. 130110 19:15:18 mysqld_safe Starting mysqld daemon with databases from /www/wdli
  39. nux/mysql-5.1.63/var
  40. 130110 19:15:18 [ERROR] /www/wdlinux/mysql-5.1.63/libexec/mysqld: unknown option
  41. '--skip-innodb'
  42. 130110 19:15:18 [ERROR] Aborting

  43. 130110 19:15:18 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown comple
  44. te

  45. 130110 19:15:18 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/d
  46. anrun.pid ended
  47. [root@danrun var]# cd /
  48. [root@danrun /]# service mysqld stop
  49. ERROR! MySQL manager or server PID file could not be found!
復(fù)制代碼

作者: dan    時(shí)間: 2013-1-10 19:54

當(dāng)前系統(tǒng)進(jìn)程:
  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.   PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
  8.     1 root      17   0  2884 1340 1164 S  0.0  0.1   0:00.31 init
  9. 1149 root      14  -4  2476  552  324 S  0.0  0.1   0:00.00 udevd
  10. 1363 root      18   0 35612 1320  996 S  0.0  0.1   0:00.00 rsyslogd
  11. 1376 root      18   0  8492 1004  524 S  0.0  0.1   0:00.00 sshd
  12. 1383 root      17   0  3188  896  708 S  0.0  0.1   0:00.00 xinetd
  13. 1595 root      18   0  8700  760  328 S  0.0  0.1   0:00.00 saslauthd
  14. 1596 root      18   0  8700  496   64 S  0.0  0.0   0:00.00 saslauthd
  15. 1603 root      15   0 11412 3708 2996 S  0.0  0.4   0:00.08 sshd
  16. 1605 root      18   0 28348  10m 3972 S  0.0  1.1   0:00.15 httpd
  17. 1616 root      18   0  7148  848  304 S  0.0  0.1   0:00.00 nginx
  18. 1617 www       20   0  8180 2116  552 S  0.0  0.2   0:00.00 nginx
  19. 1618 www       18   0  8180 2116  552 S  0.0  0.2   0:00.00 nginx
  20. 1619 www       18   0  8180 2100  536 S  0.0  0.2   0:00.00 nginx
  21. 1625 root      15   0  6264 1656 1416 S  0.0  0.2   0:00.00 bash
  22. 1632 www       18   0 28348 9292 2092 S  0.0  0.9   0:00.00 httpd
  23. 1633 www       18   0 28348 9292 2092 S  0.0  0.9   0:00.00 httpd
  24. 1634 www       18   0 28348 9292 2092 S  0.0  0.9   0:00.00 httpd
  25. 1635 www       18   0 28348 9292 2092 S  0.0  0.9   0:00.00 httpd
  26. 1636 www       18   0 28348 9292 2092 S  0.0  0.9   0:00.00 httpd
  27. 1645 root      15   0  2560 1068  888 R  0.0  0.1   0:00.06 top
  28. 1646 root      18   0  7984  528  264 S  0.0  0.1   0:00.00 pure-ftpd
  29. 1653 root      18   0 23488 8276 2836 S  0.0  0.8   0:00.00 httpd
  30. 1660 root      18   0  7056 1192  632 S  0.0  0.1   0:00.00 crond
  31. 1667 wdcpu     18   0 23488 7208 1756 S  0.0  0.7   0:00.00 httpd
復(fù)制代碼

作者: admin    時(shí)間: 2013-1-10 21:24

vi /etc/my.cnf

--skip-innodb
這行刪除,再重起mysql




歡迎光臨 WDlinux官方論壇 (http://ahbydz.com/bbs/) Powered by Discuz! 7.2