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'.
Subject
Views
Written By
Posted
3203
March 14, 2012 02:16PM
1187
March 15, 2012 10:41AM
1264
March 16, 2012 05:31AM
1087
March 18, 2012 10:06AM
1308
March 19, 2012 08:33AM
1305
March 20, 2012 11:32AM
1201
March 22, 2012 11:49AM
Re: Optimize multiple writes on the same row
1295
March 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.