Linux 为CentOS 5.5,MySQL为5.5.8。
系统和数据库都是新装的,启动后无任何异常,访问数据一切正常!
但是一段时间后(有时候十几分钟,有时候几个小时),再去查看MySQL进程,发现进程已经死亡了,下面是日志!问题可能在那里?
131212 13:57:40 mysqld_safe Starting mysqld daemon with databases from /mysql/mysqldir/data
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use InnoDB's own implementation
InnoDB: Compressed tables use zlib 1.2.3
131212 13:57:41 InnoDB: Initializing buffer pool, size = 128.0M
131212 13:57:41 InnoDB: Completed initialization of buffer pool
131212 13:57:41 InnoDB: highest supported file format is Barracuda.
131212 13:57:41 InnoDB: 1.1.4 started; log sequence number 1595675
131212 13:57:41 [Note] Event Scheduler: Loaded 0 events
131212 13:57:41 [Note] /mysql/mysqldir/bin/mysqld: ready for connections.
Version: '5.5.8-log' socket: '/mysql/mysqldir/data/mysql.sock' port: 3306 Source distribution
131212 14:00:45 [Note] /mysql/mysqldir/bin/mysqld: Normal shutdown
131212 14:00:45 [Note] Event Scheduler: Purging the queue. 0 events
131212 14:00:45 InnoDB: Starting shutdown...
131212 14:00:46 InnoDB: Shutdown completed; log sequence number 1595675
131212 14:00:46 [Note] /mysql/mysqldir/bin/mysqld: Shutdown complete
131212 14:00:46 mysqld_safe mysqld from pid file /mysql/mysqldir/data/CentOS01.pid ended