我在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