尝试启动时MySQL错误

CentOS 5.8

我运行了一个yum更新和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 

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

你升级到MySQL 5.5吗? variablesrecord_buffer已被弃用。

请参阅MySQL 5.5中的新function :

  Removed Features The record_buffer system variable (use read_buffer_size). 

该variables现在称为read_buffer_size 。