Re: slow performance with InnoDB
Hi David,
if it is only for bulk inserts
increase bulk_insert_buffer_size
if you have more processors
try this to increase innodb performance
innodb_table_locks =0
innodb_thread_concurrency=0
innodb_thread_sleep_delay=0
innodb_flush_log_at_trx_commit=0 or 2
Regards
Nanda kishore Toomula
Sr DBA,Nokia india
Certified MySQL Database Administrator
Subject
Views
Written By
Posted
2848
July 23, 2008 07:01AM
1797
July 23, 2008 01:06PM
1824
July 26, 2008 10:06PM
Re: slow performance with InnoDB
1867
July 28, 2008 06:24AM
1759
August 28, 2008 08:31AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.