MySQL Forums
Forum List  »  Performance

Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
Posted by: Walter Trapa
Date: May 24, 2021 01:45AM

I didn't know BSSCODE could be used (I tried to find a post how to format the test in this forum without any luck.

The column in the data is (I) for SQL statement with INSERT ON DUPLICATE
And (U) for the SQL statement with for the same table, do UPDATE only.
(I) Insert on Duplicates Update
(U) Update only

for for the following example is was just:
Using the insert on duplicate, where the insert ALWAYS fails because key, that ON DUPLICATE update was done 1/200s = or 200 per second
In the case of just using UPDATE, the operation could be done at 350 per second.
Using one connection.

NDB
Connections: 1
(I) 200
(U) 350
Inc: 75%

Regarding the version of NDB and MYSQL, I agree, we are working in a plan to migrate, but with millions of records means to shutdown production for a matter of hours (according to the DBA Team).

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
73
May 24, 2021 01:45AM


Sorry, only registered users may post in this forum.

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.