Hi! Below is my my.cnf. I tested the mysql-4.0.2-alpha-pc-linux-gnu-i686.tar.gz distro and it worked. What distro did you use?
Regards, Heikki # The MySQL server [mysqld] #bdb-no-sync server-id=1 language=/home/heikki/mysql-4.0/sql/share/english default-table-type=innodb #log-bin port=3307 socket=/home/heikki/MySQLheikki skip-locking default-character-set=latin1 basedir=/home/heikki datadir=/home/heikki/data set-variable = table_cache=200 set-variable = max_connections=300 set-variable = sort_buffer=4M set-variable = record_buffer=1M set-variable = max_allowed_packet=16M set-variable = thread_stack=256K set-variable = key_buffer=64M #set-variable = flush_time=1800 innodb_data_home_dir =/home/heikki innodb_data_file_path = ibdata/ibdata1:12M;ibdata/ibdata2:4M;ibdata/ibdata3:306\ M;ibdata/ibdata4:450M:autoextend set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = /home/heikki/iblogs innodb_log_arch_dir = /home/heikki/iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=50M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=0 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=100M set-variable = innodb_additional_mem_pool_size=128M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=60 ----- Original Message ----- From: "zlab1" <[EMAIL PROTECTED]> To: "'Heikki Tuuri'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, July 12, 2002 8:53 PM Subject: RE: MySQL/InnoDB-4.0.2 is released > Hi, > I'm sorry to trouble you, I was upgrade from mysql 4.01 to 4.02 in > mandrake 8.2. > > The following options in current running my.cnf suddently not work: > > innodb_data_file_path = ibdata1:100M > innodb_data_home_dir = /data/mysql/ > innodb_log_group_home_dir = /data/mysql/ > innodb_log_arch_dir = /data/mysql/ > innodb_flush_log_at_trx_commit = 1 > innodb_log_archive = 0 > set-variable = innodb_mirrored_log_groups=1 > set-variable = innodb_log_files_in_group=3 > set-variable = innodb_log_file_size=4M > set-variable = innodb_log_buffer_size=4M > set-variable = innodb_buffer_pool_size=64M > set-variable = innodb_additional_mem_pool_size=4M > set-variable = innodb_file_io_threads=4 > set-variable = innodb_lock_wait_timeout=50 > set-variable = innodb_thread_concurrency=8 > > I change the 1st: > innodb_data_file_path = ibdata1:100M > To > innodb_data_file_path = /data/mysql/ibdata1:100M:autoextend > > I have to remark rest options in order to make it working and also > "set-variable = " seen not needed?? > The err log show: > > ERROR: unknown variable '..................' whenever I keep any options > other than the 1st line, > All previous section section is working when remove 'set-variable = '. > > So the problem isolated to innodb options sections and seen no doc > refer this change, would u kind enough to give me a hand. > > Most of the options is copy from example config file with minor > changes....It is working in 4.0 4.01 and suddently not work now. > Thanks. > > Please reply to [EMAIL PROTECTED] > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php