☰

尝试启动时出现 MySQL 错误

tag-icon • tag-icon mysql
尝试启动时出现 MySQL 错误

CentOS 5.8

我运行了 yum update 并更新了 MySQL，但现在它无法启动。有什么想法可以解释为什么会出现这种情况/我该如何修复？

我在日志中得到以下内容：

121017 15:58:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
121017 15:58:40 [Note] Plugin 'FEDERATED' is disabled.
121017 15:58:40 InnoDB: The InnoDB memory heap is disabled
121017 15:58:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121017 15:58:40 InnoDB: Compressed tables use zlib 1.2.3
121017 15:58:40 InnoDB: Using Linux native AIO
121017 15:58:40 InnoDB: Error: Linux Native AIO is not supported on tmpdir.
InnoDB: You can either move tmpdir to a file system that supports native AIO
InnoDB: or you can set innodb_use_native_aio to FALSE to avoid this message.
121017 15:58:40 InnoDB: Error: Linux Native AIO check on tmpdir returned error[22]
121017 15:58:40 InnoDB: Warning: Linux Native AIO disabled.
121017 15:58:40 InnoDB: Initializing buffer pool, size = 512.0M
121017 15:58:40 InnoDB: Completed initialization of buffer pool
121017 15:58:40 InnoDB: highest supported file format is Barracuda.
121017 15:58:41  InnoDB: Waiting for the background threads to start
121017 15:58:42 InnoDB: 1.1.8 started; log sequence number 360826692325
121017 15:58:42 [ERROR] /usr/libexec/mysqld: unknown variable 'record_buffer=2M'
121017 15:58:42 [ERROR] Aborting

121017 15:58:42  InnoDB: Starting shutdown...
121017 15:58:42  InnoDB: Shutdown completed; log sequence number 360826692325
121017 15:58:43 [Note] /usr/libexec/mysqld: Shutdown complete

121017 15:58:43 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

答案1

从您的 my.cnf 文件中删除record_buffer=2M并重试。

答案2

您是否升级到 MySQL 5.5？该变量record_buffer已弃用。

參閱MySQL 5.5 中的新功能：

 Removed Features
 The record_buffer system variable (use read_buffer_size).

该变量现在称为读取缓冲区大小。

相关内容