Michael, thank you for noticing this. I tested the mysqld binary which is in the 4.0.2 rpm distribution, and it did not recognize InnoDB startup options. Obviously the MySQL AB build master has made an error in the building of the 4.0.2 rpm distribution.
........ heikki@hundin:~/usr/sbin> ls -l total 4845 -rwxr-xr-x 1 heikki users 4952476 Jul 14 02:57 mysqld heikki@hundin:~/usr/sbin> mysqld mysqld: ERROR: unknown variable 'innodb_data_home_dir=/home/heikki' ........ Good that you noticed a workaround. The MySQL-Max-4.0.2 rpm distribution contains also InnoDB. The .tar.gz binary distribution of MySQL-4.0.2 also works right. It recognizes InnoDB startup options. I am forwarding this email to the build master of the 4.0.2 release. He will build a new fixed MySQL-4.0.2 rpm. Best regards, Heikki Tuuri Innobase Oy ----- Original Message ----- From: "Michael Ivanyo" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, July 14, 2002 1:26 AM Subject: Re: My.cnf problem when upgrade from 4.01 to 4.02 > Heikki, > > I actually upgraded from Max-3.23.51 to the 4.0.2 > server. The only way I could get it to start was to > comment out all of the innodb variables in the my.cnf > file. After it started I noticed that InnoDB was > disabled when I typed: > show variables like "have_%". > > The contents of the my.cnf file: > [mysqld] > innodb_data_home_dir = / > innodb_data_file_path = ibdata/ibdata1:500M > > set-variable = innodb_buffer_pool_size=32M > set-variable = innodb_additional_mem_pool_size=20M > innodb_log_group_home_dir = /var/lib/mysql > > innodb_log_arch_dir = /var/lib/mysql > innodb_log_archive=0 > set-variable = innodb_log_files_in_group=3 > set-variable = innodb_log_file_size=16M > set-variable = innodb_log_buffer_size=2M > > innodb_flush_log_at_trx_commit=1 > > set-variable = max_connections=20 > set-variable = innodb_file_io_threads=4 > set-variable = innodb_lock_wait_timeout=50 > set-variable = record_buffer=1M > set-variable = sort_buffer=1M > > default-table-type=InnoDB > > # Do not load support for Berkley DB tables > skip-bdb > > Regards, > Michael > > > --- Heikki Tuuri <[EMAIL PROTECTED]> wrote: > > Michael, > > > > what is your my.cnf like? Which my.cnf options did > > not work in the plain > > 4.0.2 rpm? > > > > The difference between 4.0 and Max-4.0 is that Max > > supports also BDB tables. > > > > Regards, > > > > Heikki > > > > ----- Original Message ----- > > From: "Michael Ivanyo" <[EMAIL PROTECTED]> > > Newsgroups: mailing.database.mysql > > Sent: Saturday, July 13, 2002 7:23 AM > > Subject: Re: My.cnf problem when upgrade from 4.01 > > to 4.02 > > > > > > > Hello, > > > > > > I've experienced what seems to be the same problem > > on > > > Redhat 7.2. I eventually realized that in addition > > to > > > the regular 4.0.2 server RPM, I had to also > > install > > > the MySql-Max 4.0.2 server RPM. After that, > > > everything worked fine. > > > > > > I was under the impression that there would only > > be > > > one server that supported all table types > > beginning > > > with version 4.0, and that the Max server would no > > > longer be needed. That doesn't seem to be the > > case. > > > > > > --Michael > > > > > > --- zlab1 <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > I'm a new user of mysql, 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. > > > > > > > > If possible, > > > > 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 > > > > > > > > > > > > > __________________________________________________ > > > Do You Yahoo!? > > > Yahoo! Autos - Get free new car price quotes > > > http://autos.yahoo.com > > > > > > > > > --------------------------------------------------------------------- > > > 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 > > > > > > > > > > > > --------------------------------------------------------------------- > > 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 > > > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Autos - Get free new car price quotes > http://autos.yahoo.com --------------------------------------------------------------------- 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
