Skip navigation links

MySQL Forums :: Performance :: Poor performance of MySQL 5.5


Advanced Search

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
Poor performance of MySQL 5.5 8299 Matteo Canella 05/23/2011 04:43AM
Re: Poor performance of MySQL 5.5 3012 Rick James 05/24/2011 08:14AM
Re: Poor performance of MySQL 5.5 3241 Matteo Canella 05/25/2011 04:10AM
Re: Poor performance of MySQL 5.5 3381 Rick James 05/25/2011 10:40AM
Re: Poor performance of MySQL 5.5 2198 Merlotti Nicola 05/31/2011 07:15AM
Re: Poor performance of MySQL 5.5 1926 Rick James 05/31/2011 09:03AM
Re: Poor performance of MySQL 5.5 1734 Matteo Canella 05/31/2011 11:15AM
Re: Poor performance of MySQL 5.5 2233 Matteo Canella 06/03/2011 01:44AM
Re: Poor performance of MySQL 5.5 1418 Matteo Canella 06/03/2011 02:20AM
Re: Poor performance of MySQL 5.5 2293 Rick James 06/03/2011 09:33AM
Re: Poor performance of MySQL 5.5 1732 Nicola Merlotti 06/03/2011 11:25AM
Re: Poor performance of MySQL 5.5 2632 Matteo Canella 06/09/2011 05:36AM
Re: Poor performance of MySQL 5.5 1526 Nicola Merlotti 06/03/2011 11:38AM
Re: Poor performance of MySQL 5.5 1391 Rick James 06/03/2011 07:13PM
Re: Poor performance of MySQL 5.5 1255 Vladislav Vaintroub 06/11/2011 07:30PM
Re: Poor performance of MySQL 5.5 1150 Vladislav Vaintroub 06/11/2011 07:32PM
Re: Poor performance of MySQL 5.5 1475 Matteo Canella 06/12/2011 10:09AM
Re: Poor performance of MySQL 5.5 1212 Jerry Richart 06/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.