MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
Posted by: Peter Brawley
Date: May 24, 2021 04:13PM

With btrees at least, Insert On Duplicate Key entails more disk work

https://www.percona.com/blog/2010/07/14/why-insert-on-duplicate-key-update-may-be-slow-by-incurring-disk-seeks/

https://www.percona.com/blog/2010/06/18/disk-seeks-are-evil-so-lets-avoid-them-pt-4/

For more insight into the issue I thionk you'll need to consult the source code.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
1004
Walter Trapa
May 11, 2021 02:51AM
Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
447
Peter Brawley
May 11, 2021 02:34PM
Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
432
Walter Trapa
May 12, 2021 01:24AM
Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
407
Peter Brawley
May 13, 2021 08:30AM
Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
348
Walter Trapa
May 24, 2021 01:45AM
Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
400
Walter Trapa
May 24, 2021 01:53AM
Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
439
Peter Brawley
May 24, 2021 11:50AM
Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
382
Walter Trapa
May 24, 2021 01:55PM
Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
372
Peter Brawley
May 24, 2021 03:07PM
Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
359
Walter Trapa
May 24, 2021 03:52PM
Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
431
Peter Brawley
May 24, 2021 04:13PM
Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
352
Walter Trapa
May 25, 2021 08:23AM
Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
448
Ted Wennmark
May 25, 2021 12:17AM
Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
421
Ted Wennmark
May 25, 2021 12:23AM
Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
353
Walter Trapa
May 25, 2021 08:22AM
Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
442
Ted Wennmark
May 25, 2021 01:42PM
Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
450
Walter Trapa
May 25, 2021 02:04PM
Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
424
Ted Wennmark
May 27, 2021 01:20AM


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.