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

lovegx999

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

查询进程 lnmp status显示mysql还在

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

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

licess

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

lovegx999

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:32  InnoDB: Started; log sequence number 0 985399516
101226 21:38:33 [Note] Event Scheduler: Loaded 0 events
101226 21:38:33 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
101228 15:17:11 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

101228 15:17:12 [Note] Event Scheduler: Purging the queue. 0 events
101228 15:17:12 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
101228 15:17:14  InnoDB: Starting shutdown...
101228 15:17:17  InnoDB: Shutdown completed; log sequence number 0 985489357
101228 15:17:17 [Note] /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:18  InnoDB: Started; log sequence number 0 985489357
101228 15:17:19 [Note] Event Scheduler: Loaded 0 events
101228 15:17:19 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

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

licess

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

lovegx999

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

或者 2个scoket = /tmp/mysql.sock  都去掉？