后台修改mysql优化方案后, mysql无法启动
正在安装phpwind9.0正式版, 安装中的第二步创建数据库那里, 提交后总是显示504, 于是进后台修改sql的优化方案为"一般".然后就后台显示数据库没有连接之类的提示, 用SSH, 重启mysqld, 也提示error.
打开mysql的出错日志文件显示如下: 请大大们帮忙分析一下原因, 应该怎么处理, 谢谢!
[code]Version: '5.1.63' socket: '/tmp/mysql.sock' port: 3306 Source distribution
130110 19:02:08 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Normal shutdown
130110 19:02:08 [Note] Event Scheduler: Purging the queue. 0 events
130110 19:02:09 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown comple
te
130110 19:02:10 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/d
anrun.pid ended
130110 19:02:10 mysqld_safe Starting mysqld daemon with databases from /www/wdli
nux/mysql-5.1.63/var
130110 19:02:15 [Note] Event Scheduler: Loaded 0 events
130110 19:02:15 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: ready for conne
ctions.
Version: '5.1.63' socket: '/tmp/mysql.sock' port: 3306 Source distribution
130110 19:08:11 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Normal shutdown
130110 19:08:11 [Note] Event Scheduler: Purging the queue. 0 events
130110 19:08:13 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown comple
te
130110 19:08:13 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/d
anrun.pid ended
130110 19:08:14 mysqld_safe Starting mysqld daemon with databases from /www/wdli
nux/mysql-5.1.63/var
130110 19:08:14 [ERROR] /www/wdlinux/mysql-5.1.63/libexec/mysqld: unknown option
'--skip-innodb'
130110 19:08:14 [ERROR] Aborting
130110 19:08:14 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown comple
te
130110 19:08:14 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/d
anrun.pid ended
130110 19:14:32 mysqld_safe Starting mysqld daemon with databases from /www/wdli
nux/mysql-5.1.63/var
130110 19:14:33 [ERROR] /www/wdlinux/mysql-5.1.63/libexec/mysqld: unknown option
'--skip-innodb'
130110 19:14:33 [ERROR] Aborting
130110 19:14:33 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown comple
te
130110 19:14:33 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/d
anrun.pid ended
130110 19:15:18 mysqld_safe Starting mysqld daemon with databases from /www/wdli
nux/mysql-5.1.63/var
130110 19:15:18 [ERROR] /www/wdlinux/mysql-5.1.63/libexec/mysqld: unknown option
'--skip-innodb'
130110 19:15:18 [ERROR] Aborting
130110 19:15:18 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown comple
te
130110 19:15:18 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/d
anrun.pid ended
[root@danrun var]# cd /
[root@danrun /]# service mysqld stop
ERROR! MySQL manager or server PID file could not be found!
[/code] 当前系统进程:[code][root@danrun ~]# top
top - 19:46:45 up 3 min, 1 user, load average: 0.07, 0.11, 0.05
Tasks: 24 total, 1 running, 23 sleeping, 0 stopped, 0 zombie
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
Mem: 1048576k total, 79848k used, 968728k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1 root 17 0 2884 1340 1164 S 0.0 0.1 0:00.31 init
1149 root 14 -4 2476 552 324 S 0.0 0.1 0:00.00 udevd
1363 root 18 0 35612 1320 996 S 0.0 0.1 0:00.00 rsyslogd
1376 root 18 0 8492 1004 524 S 0.0 0.1 0:00.00 sshd
1383 root 17 0 3188 896 708 S 0.0 0.1 0:00.00 xinetd
1595 root 18 0 8700 760 328 S 0.0 0.1 0:00.00 saslauthd
1596 root 18 0 8700 496 64 S 0.0 0.0 0:00.00 saslauthd
1603 root 15 0 11412 3708 2996 S 0.0 0.4 0:00.08 sshd
1605 root 18 0 28348 10m 3972 S 0.0 1.1 0:00.15 httpd
1616 root 18 0 7148 848 304 S 0.0 0.1 0:00.00 nginx
1617 www 20 0 8180 2116 552 S 0.0 0.2 0:00.00 nginx
1618 www 18 0 8180 2116 552 S 0.0 0.2 0:00.00 nginx
1619 www 18 0 8180 2100 536 S 0.0 0.2 0:00.00 nginx
1625 root 15 0 6264 1656 1416 S 0.0 0.2 0:00.00 bash
1632 www 18 0 28348 9292 2092 S 0.0 0.9 0:00.00 httpd
1633 www 18 0 28348 9292 2092 S 0.0 0.9 0:00.00 httpd
1634 www 18 0 28348 9292 2092 S 0.0 0.9 0:00.00 httpd
1635 www 18 0 28348 9292 2092 S 0.0 0.9 0:00.00 httpd
1636 www 18 0 28348 9292 2092 S 0.0 0.9 0:00.00 httpd
1645 root 15 0 2560 1068 888 R 0.0 0.1 0:00.06 top
1646 root 18 0 7984 528 264 S 0.0 0.1 0:00.00 pure-ftpd
1653 root 18 0 23488 8276 2836 S 0.0 0.8 0:00.00 httpd
1660 root 18 0 7056 1192 632 S 0.0 0.1 0:00.00 crond
1667 wdcpu 18 0 23488 7208 1756 S 0.0 0.7 0:00.00 httpd
[/code] vi /etc/my.cnf
把
--skip-innodb
这行删除,再重起mysql
页:
[1]