当前位置: 代码迷 >> 其他数据库 >> Mysql 不明原因经常重启,造成无法访问,该怎么处理
  详细解决方案

Mysql 不明原因经常重启,造成无法访问,该怎么处理

热度:5145   发布时间:2013-02-26 00:00:00.0
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
  相关解决方案