mysql 5.1 innodb_MYSQL 5.1.25 配置 Innodb 启动不了

我在redhat as4 u4 32位系统编译了 5.1.25后,配置my.cnf启动不了!

my.cnf

# Uncomment the following if you are using InnoDB tables

innodb_data_home_dir = /usr/local/mysql/data/

innodb_data_file_path = ibdata1:10M:autoextend

innodb_log_group_home_dir = /usr/local/mysql/data/

innodb_log_arch_dir = /usr/local/mysql/data/

# You can set .._buffer_pool_size up to 50 - 80 %

# of RAM but beware of setting memory usage too high

innodb_buffer_pool_size = 256M

innodb_additional_mem_pool_size = 20M

# Set .._log_file_size to 25 % of buffer pool size

innodb_log_file_size = 64M

innodb_log_buffer_size = 8M

innodb_flush_log_at_trx_commit = 1

innodb_lock_wait_timeout = 50

不使用上面配置启动正常!

[root@RedhatAS4U4-Oracle mysql]# ls

bin  data  docs  include  lib  libexec  man  my.cnf  mysql.sock  mysql-test  share  sql-bench

[root@RedhatAS4U4-Oracle mysql]# ll

total 48

drwxr-xr-x   2 mysql mysql 4096 Jul  9 03:34 bin

drwx------   5 mysql mysql 4096 Jul  9 15:28 data

drwxr-xr-x   2 mysql mysql 4096 Jul  9 03:18 docs

drwxr-xr-x   3 mysql mysql 4096 Jul  9 03:18 include

drwxr-xr-x   3 mysql mysql 4096 Jul  9 03:19 lib

drwxr-xr-x   2 mysql mysql 4096 Jul  9 03:20 libexec

drwxr-xr-x   4 mysql mysql 4096 Jul  9 03:19 man

-rw-r--r--   1 mysql mysql 4938 Jul  9 15:28 my.cnf

srwxrwxrwx   1 mysql mysql    0 Jul  9 15:28 mysql.sock

drwxr-xr-x  10 mysql mysql 4096 Jul  9 03:20 mysql-test

drwxr-xr-x   4 mysql mysql 4096 Jul  9 03:20 share

drwxr-xr-x   5 mysql mysql 4096 Jul  9 03:20 sql-bench

[root@RedhatAS4U4-Oracle mysql]# ls data/

freeke  mysql  mysql-bin.000001  mysql-bin.index  RedhatAS4U4-Oracle.err  RedhatAS4U4-Oracle.pid  test

[root@RedhatAS4U4-Oracle mysql]# less my.cnf

080709 15:27:36 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

080709 15:27:36 [ERROR] /usr/local/mysql/libexec/mysqld: unknown variable 'innodb_data_home_dir=/usr/local/mysql/data/'

080709 15:27:36 [ERROR] Aborting

080709 15:27:36 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

080709 15:27:36 mysqld_safe mysqld from pid file /usr/local/mysql/data/RedhatAS4U4-Oracle.pid ended

请问是什么原因呢?

作者: myfreeke

发布时间: 2008-07-09