读书人

Mysql 不明原因经常重启造成无法访问

发布时间: 2012-02-23 22:01:35 作者: rapoo

Mysql 不明原因经常重启,造成无法访问

哪位仁兄帮忙给看看下面什么原因???

090918 16:50:09 [Note] /usr/sbin/mysqld-max: Normal shutdown

090918 16:50:11 InnoDB: Starting shutdown...
090918 16:50:15 InnoDB: Shutdown completed; log sequence number 0 1179760410
090918 16:50:15 [Note] /usr/sbin/mysqld-max: Shutdown complete

090918 16:50:15 mysqld ended

090918 16:50:15 mysqld started
090918 16:50:15 [Warning] Could not increase number of max_open_files to more than 65535 (request: 1049086)
090918 16:50:16 InnoDB: Started; log sequence number 0 1179760410
090918 16:50:16 [Warning] 'user' entry 'root@demo' ignored in --skip-name-resolve mode.
090918 16:50:16 [Warning] 'user' entry '(null)@demo' ignored in --skip-name-resolve mode.
090918 16:50:16 [Warning] 'user' entry 'root@demo' ignored in --skip-name-resolve mode.
090918 16:50:16 [Warning] 'db' entry 'demo root@demo' ignored in --skip-name-resolve mode.
090918 16:50:16 [Warning] 'db' entry 'demo root@demo' ignored in --skip-name-resolve mode.
090918 16:50:16 [Note] /usr/sbin/mysqld-max: ready for connections.
Version: '5.1.7-beta-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Max (GPL)

[解决办法]
090918 16:50:09 [Note] /usr/sbin/mysqld-max: Normal shutdown
...
090918 16:50:16 [Note] /usr/sbin/mysqld-max: ready for connections.
Version: '5.1.7-beta-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Max (GPL)


仅从这段日志上看,完全正常。

是不是你机器上有什么进程在主动关闭你的mysql 服务?
[解决办法]
Deadlock found when trying to get lock; try restarting transaction

看上去应该是死锁啊。
发生这个故障的同时到MYSQL中查一下

show processlist

读书人网 >其他数据库

热点推荐