MySQL Forums
Forum List  »  InnoDB

simultaneous updates take time
Posted by: Mohil Chandra
Date: October 03, 2008 12:34AM

I'm facing a problem where in the update times degrade as the number of transactions increase.

My application is following producer consumer model. 1 producer filling up the buffer with x consumers processing. All the consumers make an update to the DB after processing. The update is based on the primary key index.

Running with around 25 consumer threads i get update times of less than 100 ms. As i increase the number of consumer threads to 50 the update times increase to over 300 ms.

Can someone explain as to why this is so??

Options: ReplyQuote


Subject
Views
Written By
Posted
simultaneous updates take time
3001
October 03, 2008 12:34AM
1595
October 03, 2008 01:20AM
1672
October 03, 2008 03: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.