MySQL Forums
Forum List  »  Performance

Re: Poor performance of MySQL 5.5
Posted by: Nicola Merlotti
Date: June 03, 2011 11:25AM

the solution to the delays in writing is innodb_flush_log_at_trx_commit = 0 or innodb_flush_log_at_trx_commit = 2
By running millions of transactions INSERT innodb_flush_log_at_trx_commit=1 i have seen with slower 64-bit platform. With 32-bit innodb_flush_log_at_trx_commit = 1 works well

Options: ReplyQuote


Subject
Views
Written By
Posted
15483
May 23, 2011 04:43AM
4934
May 24, 2011 08:14AM
5011
May 25, 2011 10:40AM
3205
May 31, 2011 09:03AM
3780
June 03, 2011 09:33AM
Re: Poor performance of MySQL 5.5
2672
June 03, 2011 11:25AM
2357
June 03, 2011 07:13PM


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.