centos下mysql当掉

[mayinhua]

日志显示如下


110223 11:47:55 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
110224 19:22:13 mysqld started
110224 19:22:13 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
110224 19:22:13 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110224 19:22:14 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
110224 19:22:14 InnoDB: Started; log sequence number 0 201962
110224 19:22:14 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
110225 9:05:24 [Note] /usr/libexec/mysqld: Normal shutdown

110225 9:05:28 [ERROR] /usr/libexec/mysqld: Sort aborted
110225 9:05:28 [ERROR] /usr/libexec/mysqld: Sort aborted
110225 9:05:52 InnoDB: Starting shutdown...
110225 9:06:30 InnoDB: Shutdown completed; log sequence number 0 202008
110225 9:06:30 [Note] /usr/libexec/mysqld: Shutdown complete

110225 09:06:31 mysqld ended

110225 09:06:58 mysqld started
110225 9:06:58 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
110225 9:06:58 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
110225 9:06:59 InnoDB: Started; log sequence number 0 202008
110225 9:06:59 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution


有谁知道原因及何种解决方式？

[zuoxingyu]

把ib_logfile0和ib_logfile1备份起来，然后删除掉，重新启动服务看看。

[aleng18]

log中没有显示出来具体现象，让我来猜猜，看人品咋样，能猜中不：
1 32位的mysql但，进程使用的内存需求超过了4G。
2 磁盘满，或inode满。