Re: Poor performance of MySQL 5.5
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
Subject
Views
Written By
Posted
12046
May 23, 2011 04:43AM
4029
May 24, 2011 08:14AM
4205
May 25, 2011 04:10AM
4261
May 25, 2011 10:40AM
2952
May 31, 2011 07:15AM
2612
May 31, 2011 09:03AM
2374
May 31, 2011 11:15AM
2938
June 03, 2011 01:44AM
1953
June 03, 2011 02:20AM
3140
June 03, 2011 09:33AM
Re: Poor performance of MySQL 5.5
2178
June 03, 2011 11:25AM
3507
June 09, 2011 05:36AM
1975
June 03, 2011 11:38AM
1932
June 03, 2011 07:13PM
1821
June 11, 2011 07:30PM
1602
June 11, 2011 07:32PM
2047
June 12, 2011 10:09AM
1671
June 15, 2011 01:08PM
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.