MySQL Forums
Forum List  »  Performance

Re: Achieving max write throughput with InnoDB clustered index?
Posted by: James Day
Date: April 24, 2005 03:55PM

If you're inserting a batch of records you could try presorting them to try to get many updates per page. If you're using locking within a transaction and many updates end up waiting for other transaction I've had some success by doing a read before the start of the transaction, so the page is in the buffer before the lock is taken.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Achieving max write throughput with InnoDB clustered index?
1813
April 24, 2005 03:55PM


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.