日志显示如下
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 shutdown110225 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 complete110225 09:06:31 mysqld ended110225 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
有谁知道原因及何种解决方式?
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 shutdown110225 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 complete110225 09:06:31 mysqld ended110225 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
有谁知道原因及何种解决方式?
1 32位的mysql但,进程使用的内存需求超过了4G。
2 磁盘满,或inode满。