哪位仁兄帮忙给看看下面什么原因???
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