mysql5.1.30 innodb 的问题

wangxiaosen

今天刚装上mysql5.1.30版 ，好像默认不支持innodb，所以编译的时候 我加了 --with-plugins=innobase 选项，，安装后，不加载my.cnf启动后 ，用show variables 看 have innodb 是yes ，但是当我编译/etc/my.cnf 后启动就会出错

错误信息


081212 21:52:30 mysqld_safe mysqld from pid file /usr/local/mysql/var/mysql.pid ended
081212 21:53:19 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
081212 21:53:19 [ERROR] InnoDB: syntax error in innodb_data_file_path
081212 21:53:19 [ERROR] Plugin 'InnoDB' init function returned error.
081212 21:53:19 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
081212 21:53:19 [ERROR] /usr/local/mysql/libexec/mysqld: unknown variable 'innodb_log_arch_dir=/usr/local/mysql/var/'
081212 21:53:19 [ERROR] Aborting

081212 21:53:19 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

081212 21:53:19 mysqld_safe mysqld from pid file /usr/local/mysql/var/mysql.pid ended



我的my.cnf 配置为

[mysqld]
port            = 3306
socket          = /usr/local/mysql/tmp/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M


log-bin=mysql-bin

# binary logging format - mixed recommended
binlog_format=mixed

# Point the following paths to different dedicated disks
#tmpdir         = /tmp/
#log-update     = /path-to-dedicated-directory/hostname

# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /usr/local/mysql/var/
innodb_data_file_path = ibdata1:4G:ibdata2:4G:ibdata3:4G:autoextend
innodb_log_group_home_dir = /usr/local/mysql/var/
innodb_log_arch_dir = /usr/local/mysql/var/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50


以前4的时候也是这么配置的，，为什么5.1就出错了呢 ，还是5.1已经不能用innodb_log_arch_dir 这个选项了。。大家帮帮我

wangxiaosen

为什么会出现 InnoDB: syntax error in innodb_data_file_path 这个错误呢

wangxiaosen

大家使用5.1.30都没有遇到过这样的问题吗

yueliangdao0608

支持。你要自己安装。

install plugin innodb soname "ha_innodb.so";

wangxiaosen

谢谢，刚刚开了看手册，手册上也介绍了