MySQL Forums
Forum List  »  Performance

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
12039
May 23, 2011 04:43AM
4027
May 24, 2011 08:14AM
4259
May 25, 2011 10:40AM
2611
May 31, 2011 09:03AM
3137
June 03, 2011 09:33AM
Re: Poor performance of MySQL 5.5
1930
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.