Unfortunately it persists also for real queries. Eg. query like "select field1 from table1 where field3=xx" and InnoDB is cca 10times slower than MyISAM.
I wonder whether there is not some error or problem in my.ini settings, I use following settings: innodb_additional_mem_pool_size 1048576 innodb_buffer_pool_size 8388608 innodb_data_file_path ibdata1:500M:autoextend innodb_data_home_dir innodb_file_io_threads 4 innodb_force_recovery 0 innodb_thread_concurrency 8 innodb_flush_log_at_trx_commit 1 innodb_fast_shutdown ON innodb_flush_method innodb_lock_wait_timeout 50 innodb_log_arch_dir .\ innodb_log_archive OFF innodb_log_buffer_size 1048576 innodb_log_file_size 5242880 innodb_log_files_in_group 2 innodb_log_group_home_dir .\ innodb_mirrored_log_groups 1 innodb_max_dirty_pages_pct 90 Is there anything wrong or unusual? Jiri Matejka [EMAIL PROTECTED] ==>Wednesday, February 18, 2004 11:57 AM [EMAIL PROTECTED] wrote: > I think count(*) is a special case: MyISAM holds a record count which > it can access instantly, InnoDB has to count rows. Does the time > difference persist for real queries? > > Alec > > Jiří Matějka <[EMAIL PROTECTED]> wrote on 18/02/2004 10:38:13: > >> Hi all, >> I'm using mysql 4.0.17 and I have this problem with speed of innodb >> database: >> >> I have simple command like select count(*) from table1, or select >> field1, field2 from table1. The table1 and has more than cca 10.000 >> rows (most of the fields are integer, only several varchars and >> several memos) and its type is InnoDB. Then the query lasts too >> long, at least several seconds, sometimes more than 5. If I convert >> it to MyISAM then the query lasts usually less then 0.3 second. If >> the table is small (cca less than 5.000 rows) then there is not big >> difference... >> Is it normal, that InnoDB isn't able to access large table as >> quickly as MyISAM? Or is there any parametr to set to make InnoDB >> run faster? I need to use InnoDB because it supports transactions >> and MyISAM not... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
