lovegx999 发表于 2010-12-28 15:26:35

mysql数据库连不上，查询进程还在 是什么问题？

最近有2次mysql数据库突然好好的就连不上了

查询进程 lnmp status显示mysql还在

lnmp restart 重启下 数据库即可链接正常

请教老大这个是什么问题？

licess 发表于 2010-12-28 17:11:53

回复 1# 的帖子

看看/usr/local/mysql/var/主机名.err 里面有什么错误提示

lovegx999 发表于 2010-12-29 10:25:40

回复 2# 的帖子

101226 21:38:27 mysqld_safe mysqld from pid file /usr/local/mysql/var/swisen.com.pid ended
101226 21:38:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101226 21:38:32InnoDB: Started; log sequence number 0 985399516
101226 21:38:33 Event Scheduler: Loaded 0 events
101226 21:38:33 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
101228 15:17:11 /usr/local/mysql/libexec/mysqld: Normal shutdown

101228 15:17:12 Event Scheduler: Purging the queue. 0 events
101228 15:17:12 /usr/local/mysql/libexec/mysqld: Sort aborted
101228 15:17:14InnoDB: Starting shutdown...
101228 15:17:17InnoDB: Shutdown completed; log sequence number 0 985489357
101228 15:17:17 /usr/local/mysql/libexec/mysqld: Shutdown complete

101228 15:17:17 mysqld_safe mysqld from pid file /usr/local/mysql/var/swisen.com.pid ended
101228 15:17:18 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101228 15:17:18InnoDB: Started; log sequence number 0 985489357
101228 15:17:19 Event Scheduler: Loaded 0 events
101228 15:17:19 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution

最后2天的日志
链接不上出现在28号
老大帮忙看下什么情况啊
thanks

licess 发表于 2010-12-29 14:51:24

回复 3# 的帖子

去掉/etc/my.cnf 里面的scoket = /tmp/mysql.sock ，再启动试试

lovegx999 发表于 2010-12-29 17:27:34

回复 4# 的帖子

去掉 里面的 还是 server里面的 scoket = /tmp/mysql.sock

或者 2个scoket = /tmp/mysql.sock都去掉？
页: [1]
查看完整版本: mysql数据库连不上，查询进程还在 是什么问题？