Skip navigation links

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


Advanced Search

Re: Poor performance of MySQL 5.5
Posted by: Rick James ()
Date: June 03, 2011 07:13PM

innodb_flush_log_at_trx_commit=1 -- The disk subsystem, drivers, OS settings, etc play a big role. I would not expect 64-bit, number of cores, etc to have much impact.

innodb_flush_log_at_trx_commit=1 slows your "transactions per second" to roughly your "writes per second", which (for typical systems) is about 150K/hour.

If INSERTs are your main activity, then any of these can give you on the order of 10x speedup:
* Multiple INSERTs per BEGIN...COMMIT
* Batching 100 rows per INSERT statement
* Using LOAD DATA instead of INSERT.

Options: ReplyQuote


Subject Views Written By Posted
Poor performance of MySQL 5.5 8412 Matteo Canella 05/23/2011 04:43AM
Re: Poor performance of MySQL 5.5 3062 Rick James 05/24/2011 08:14AM
Re: Poor performance of MySQL 5.5 3278 Matteo Canella 05/25/2011 04:10AM
Re: Poor performance of MySQL 5.5 3414 Rick James 05/25/2011 10:40AM
Re: Poor performance of MySQL 5.5 2225 Merlotti Nicola 05/31/2011 07:15AM
Re: Poor performance of MySQL 5.5 1953 Rick James 05/31/2011 09:03AM
Re: Poor performance of MySQL 5.5 1759 Matteo Canella 05/31/2011 11:15AM
Re: Poor performance of MySQL 5.5 2264 Matteo Canella 06/03/2011 01:44AM
Re: Poor performance of MySQL 5.5 1442 Matteo Canella 06/03/2011 02:20AM
Re: Poor performance of MySQL 5.5 2320 Rick James 06/03/2011 09:33AM
Re: Poor performance of MySQL 5.5 1758 Nicola Merlotti 06/03/2011 11:25AM
Re: Poor performance of MySQL 5.5 2682 Matteo Canella 06/09/2011 05:36AM
Re: Poor performance of MySQL 5.5 1552 Nicola Merlotti 06/03/2011 11:38AM
Re: Poor performance of MySQL 5.5 1419 Rick James 06/03/2011 07:13PM
Re: Poor performance of MySQL 5.5 1282 Vladislav Vaintroub 06/11/2011 07:30PM
Re: Poor performance of MySQL 5.5 1164 Vladislav Vaintroub 06/11/2011 07:32PM
Re: Poor performance of MySQL 5.5 1518 Matteo Canella 06/12/2011 10:09AM
Re: Poor performance of MySQL 5.5 1243 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.