Skip navigation links

MySQL Forums :: Performance :: Optimize multiple writes on the same row


Advanced Search

Re: Optimize multiple writes on the same row
Posted by: Francis Page ()
Date: March 16, 2012 05:31AM

To answer your last question, we have lots of inserts in the first weeks of the life cycle, then mainly updates. There are no deletes. I would say that we have 1000s of inserts/updates per second (I don't have the real numbers right now).

The real problem is that a lot of simultaneous queries are updating the exact same data in the database. As this data is locked every time it's written to, the queries can't be executed simultaneously: they have to wait for each other to update the sum. That have a huge impact on the performance.

I'm not familiar with the triggers, but I don't think it will prevent this problem, but maybe I just don't understand how they work.

Options: ReplyQuote


Subject Views Written By Posted
Optimize multiple writes on the same row 1362 Francis Page 03/14/2012 02:16PM
Re: Optimize multiple writes on the same row 509 Rick James 03/15/2012 10:41AM
Re: Optimize multiple writes on the same row 618 Francis Page 03/16/2012 05:31AM
Re: Optimize multiple writes on the same row 468 Rick James 03/18/2012 10:06AM
Re: Optimize multiple writes on the same row 585 Francis Page 03/19/2012 08:33AM
Re: Optimize multiple writes on the same row 569 Rick James 03/20/2012 11:32AM
Re: Optimize multiple writes on the same row 460 Francis Page 03/22/2012 11:49AM
Re: Optimize multiple writes on the same row 665 Rick James 03/23/2012 11:35AM


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.