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

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

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?

1064

Y M

September 03, 2021 08:54AM

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

366

Peter Brawley

September 03, 2021 09:35AM

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

360

Y M

September 03, 2021 10:07AM

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

390

Y M

September 03, 2021 10:19AM

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

398

Peter Brawley

September 03, 2021 11:44AM

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

528

Y M

September 03, 2021 10:15PM

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

414

Y M

September 04, 2021 05:08AM

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

335

Peter Brawley

September 04, 2021 11:50AM

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

610

Y M

September 04, 2021 08:32PM

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.