Hi. I need help with InnoDB configuration.
- The machine is a 2 Pentium III 1000GHz, Memory 1G, 30GB SCSSI. - The operating system is FreeBSD 4.5. - The mysql server is 3.23.49 (using FreeBSD port). I read carefully section InnoDB in MySQL manual and set the innodb parameters as: # Uncomment the following if you are using Innobase tables innodb_data_file_path = ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M innodb_data_home_dir = /mysql/ innodb_log_group_home_dir = /mysql/ innodb_log_arch_dir = /mysql/ set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=100M set-variable = innodb_log_buffer_size=16M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=350M set-variable = innodb_additional_mem_pool_size=20M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Note: I use my-huge.cnf as my.cnf. I'm testing InnoDB against MyISAM. I have two databases with the same data one have MyISAM tables and the other InnoDB tables. The queries in MyISAM are faster than in InnoDB. The same query in MyISAM executes in 2:30 minutesand in InnoDB in 27:00 minutes. I think I must have some wrong in configuration. Thanks in advance. Iago. --------------------------------------------------------------------- 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
