Rodrigo, from the manual:
" If the disk becomes full you may want to add another data file to another disk, for example. Then you have to look the size of ibdata1, round the size downward to the closest multiple of 1024 * 1024 bytes (= 1 MB), and specify the rounded size of ibdata1 explicitly in innodb_data_file_path. After that you can add another data file: innodb_data_file_path = /ibdata/ibdata1:988M;/disk2/ibdata2:50M:autoextend " Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB ----- Original Message ----- From: ""Rodrigo Gonzalez"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, April 12, 2002 4:20 PM Subject: InnoDB > I install mysql-max 3.23.50 in my test box and start testing innodb > tables.... > > I found two questions....first of all I used autoextend feature (it's really > great) but I cannot now add another file to the tablespace.... > > The second question is if I am configuring something wrong, the same query > which takes 80 seconds in MyIsam tables takes 640 in InnoDb tables.... > > > Here is my InnoDB definition in my.cnf > > # Uncomment the following if you are using Innobase tables > innodb_data_file_path = > ibdata1:256M;ibdata2:256M;ibdata3:128M:autoextend:max:2000M > innodb_data_home_dir = /usr/local/mysql_50/data/ > innodb_log_group_home_dir = /usr/local/mysql_50/data/ > innodb_log_arch_dir = /usr/local/mysql_50/data/ > set-variable = innodb_mirrored_log_groups=1 > set-variable = innodb_log_files_in_group=3 > set-variable = innodb_log_file_size=10M > set-variable = innodb_log_buffer_size=8M > innodb_flush_log_at_trx_commit=0 > innodb_log_archive=0 > 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 > > The test box is a PIII with 192MB > > > --------------------------------------------------------------------- > 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
