MySQL :: Re: How does Innodb cleverly avoid read-write conflicts when implementing mvcc?

New Topic

Re: How does Innodb cleverly avoid read-write conflicts when implementing mvcc?

Posted by: Peter Brawley
Date: September 04, 2021 11:50AM

> if step 5 does not happen, only transaction 1 adds a shared lock
> to the row to avoid the modification of transaction 2.

Only with select ... in shared mode or for update.

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

How does Innodb cleverly avoid read-write conflicts when implementing mvcc?

2095

Y M

September 03, 2021 08:54AM

Re: How does Innodb cleverly avoid read-write conflicts when implementing mvcc?

606

Peter Brawley

September 03, 2021 09:35AM

Re: How does Innodb cleverly avoid read-write conflicts when implementing mvcc?

598

Y M

September 03, 2021 10:07AM

Re: How does Innodb cleverly avoid read-write conflicts when implementing mvcc?

699

Y M

September 03, 2021 10:19AM

Re: How does Innodb cleverly avoid read-write conflicts when implementing mvcc?

629

Peter Brawley

September 03, 2021 11:44AM

Re: How does Innodb cleverly avoid read-write conflicts when implementing mvcc?

789

Y M

September 03, 2021 10:15PM

Re: How does Innodb cleverly avoid read-write conflicts when implementing mvcc?

706

Y M

September 04, 2021 05:08AM

Re: How does Innodb cleverly avoid read-write conflicts when implementing mvcc?

614

Peter Brawley

September 04, 2021 11:50AM

Re: How does Innodb cleverly avoid read-write conflicts when implementing mvcc?

1384

Y M

September 04, 2021 08:32PM

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

This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.