Board logo

标题: [求助] 求助无法启动数据库 [打印本页]

作者: helwo    时间: 2012-8-8 20:31     标题: 求助无法启动数据库

起因:因为经常发文出现504 于是我就按照

在Nginx.conf里加上【  给我加分啊!加在client_max_body_size 8m; 之后  】:

        fastcgi_connect_timeout 3000s;
        fastcgi_send_timeout 3000s;
        fastcgi_read_timeout 3000s;
        fastcgi_buffer_size 64k;
        fastcgi_buffers 8 128k;
        fastcgi_busy_buffers_size 256k;
        fastcgi_temp_file_write_size 256k;
        fastcgi_intercept_errors on;
修改后还是不行

http://www.wdlinux.cn/bbs/viewthread.php?tid=2194&highlight=504
再按照这个帖子修改
修改后不行。我就想删除原来的,重启web服务和数据库。web启动好了,启动数据库就无法启动了。这时按照下面的方法再次修改。还是不行。


[root@310174 data]# service mysqld restart
ERROR! MySQL manager or server PID file could not be found!
Starting MySQL. ERROR! Manager of pid-file quit without updating file.

今天晚上突然无法启动数据库,
sed -i '/skip-innodb/d' /www/wdlinux/etc/my.cnf
service mysqld restart
这个命令用过

作者: helwo    时间: 2012-8-8 21:32

管理员在不。非常着急,感谢了
作者: helwo    时间: 2012-8-8 21:36

120701 20:09:44 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.63/var

120701 20:09:44 [Note] Event Scheduler: Loaded 0 events

120701 20:09:44 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: ready for connections.

Version: '5.1.63'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

120701 20:27:55 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Normal shutdown


120701 20:27:55 [Note] Event Scheduler: Purging the queue. 0 events

120701 20:27:55 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown complete


120701 20:27:55 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/310174.techd.pid ended

120701 20:27:57 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.63/var

120701 20:27:57 [Note] Event Scheduler: Loaded 0 events
120701 20:27:57 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: ready for connections.

Version: '5.1.63'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

120705 10:10:06 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Normal shutdown

120705 10:10:06 [Note] Event Scheduler: Purging the queue. 0 events

120705 10:10:06 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown complete

120705 10:10:06 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/310174.techd.pid ended

120705 10:10:46 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.63/var

120705 10:10:47 [Note] Event Scheduler: Loaded 0 events
120705 10:10:47 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: ready for connections.

Version: '5.1.63'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

120808 19:40:02 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Normal shutdown


120808 19:40:02 [Note] Event Scheduler: Purging the queue. 0 events

120808 19:40:02 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown complete


120808 19:40:04 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.63/var
作者: helwo    时间: 2012-8-8 21:38

120808 20:56:37 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.63/var

120808 20:56:37 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use

120808 20:56:37 [ERROR] Do you already have another mysqld server running on port: 3306 ?

120808 20:56:37 [ERROR] Aborting


120808 20:56:37 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown complete


120808 20:56:37 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/310174.techd.pid ended

120808 20:56:40 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.63/var

120808 20:56:40 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use

120808 20:56:40 [ERROR] Do you already have another mysqld server running on port: 3306 ?

120808 20:56:40 [ERROR] Aborting


120808 20:56:40 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown complete


120808 20:56:40 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/310174.techd.pid ended

120808 21:11:07 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.63/var

120808 21:11:07 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use

120808 21:11:07 [ERROR] Do you already have another mysqld server running on port: 3306 ?
120808 21:11:07 [ERROR] Aborting


120808 21:11:07 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown complete


120808 21:11:07 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/310174.techd.pid ended
作者: admin    时间: 2012-8-8 22:51

这个数据库,没看出有什么问题

做这哪些操作或更改,一个个恢复原来的来尝试就可以




欢迎光临 WDlinux官方论坛 (http://wdlinux.cn/bbs/) Powered by Discuz! 7.2