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
