Re: Challenging performance demand
Posted by:
James Day
Date: July 17, 2005 03:07AM
The 50/50 mix of inserts and updates suggests to me that you should try InnoDB. It'll cache the updates itself, probably reducing the number of disk writes involved substantially.
The high update rate means the query cache probably can't help and you can get a small speed improvement by turning it off.
At 5,000 updates per second you'd need a write caching disk controller with InnoDB to keep up with the fsync rate. Can dodge it if you can combine multiple updates (say 200 to 500) into a single transaction. Inserting with multiple connections instead of one would also help.
Subject
Views
Written By
Posted
2400
June 02, 2005 03:16PM
1620
June 03, 2005 06:45AM
1684
June 03, 2005 07:10AM
1676
June 03, 2005 07:50AM
1732
July 13, 2005 07:54AM
1617
July 13, 2005 10:10AM
1650
July 14, 2005 10:02AM
1739
July 14, 2005 12:03PM
1645
July 13, 2005 02:09PM
Re: Challenging performance demand
1652
July 17, 2005 03:07AM
1652
July 20, 2005 12:32AM
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.