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: Rick James ()
Date: March 23, 2012 11:35AM

"Concurrent updates" are impossible. At some low level, the row (InnoDB) or table (MyISAM) will have to be locked to do one update. After the lock is released, the other 'concurrent update' can lock the row/table.

InnoDB should be better than MyISAM because updates to _different_ rows can run 'concurrently'.

Options: Reply•Quote


Subject Views Written By Posted
Optimize multiple writes on the same row 1003 Francis Page 03/14/2012 02:16PM
Re: Optimize multiple writes on the same row 383 Rick James 03/15/2012 10:41AM
Re: Optimize multiple writes on the same row 432 Francis Page 03/16/2012 05:31AM
Re: Optimize multiple writes on the same row 349 Rick James 03/18/2012 10:06AM
Re: Optimize multiple writes on the same row 448 Francis Page 03/19/2012 08:33AM
Re: Optimize multiple writes on the same row 414 Rick James 03/20/2012 11:32AM
Re: Optimize multiple writes on the same row 331 Francis Page 03/22/2012 11:49AM
Re: Optimize multiple writes on the same row 521 Rick James 03/23/2012 11:35AM


Sorry, you can't reply to this topic. It has been closed.
powered by phorum

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.