MySQL Forums
Forum List  »  InnoDB

Re: Issue on UPSERT when concurrency is high
Posted by: Rick James
Date: December 09, 2016 05:13PM

That timestamp looks like only 1-second resolution. What if both the INSERT and UPDATE were done in the same second? Seems like you don't have enough resolution?

Do the UPDATEs always have all the columns? If not, the cannot be turned into this UPSERT.

Is it just this one table that is involved?

I would suggest staging the changes in a separate table, clean up various things in the staging table, only then copy to the real table. This will speed things up for various reasons.

Here is more on 'staging'. It is not aimed at your particular case, but I think the ping-ponging, etc, would benefit you.
https://mariadb.com/kb/en/mariadb/data-warehousing-high-speed-ingestion/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Issue on UPSERT when concurrency is high
259
December 09, 2016 05:13PM


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.