Re: Poor performance of MySQL 5.5
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.
Subject
Views
Written By
Posted
15750
May 23, 2011 04:43AM
4998
May 24, 2011 08:14AM
5007
May 25, 2011 04:10AM
5095
May 25, 2011 10:40AM
3578
May 31, 2011 07:15AM
3255
May 31, 2011 09:03AM
2989
May 31, 2011 11:15AM
3636
June 03, 2011 01:44AM
2449
June 03, 2011 02:20AM
3858
June 03, 2011 09:33AM
2750
June 03, 2011 11:25AM
4246
June 09, 2011 05:36AM
2370
June 03, 2011 11:38AM
Re: Poor performance of MySQL 5.5
2411
June 03, 2011 07:13PM
2350
June 11, 2011 07:30PM
2037
June 11, 2011 07:32PM
2609
June 12, 2011 10:09AM
2260
June 15, 2011 01:08PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.