MySQL Forums :: InnoDB :: Issue on UPSERT when concurrency is high


Advanced Search

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
Issue on UPSERT when concurrency is high 394 Kailas Janardhanan 12/06/2016 03:46AM
Re: Issue on UPSERT when concurrency is high 186 Rick James 12/09/2016 05:13PM
Re: Issue on UPSERT when concurrency is high 278 Peter Brawley 12/09/2016 07:18PM
Re: Issue on UPSERT when concurrency is high 263 Rick James 12/10/2016 12:21AM
Re: Issue on UPSERT when concurrency is high 175 Peter Brawley 12/10/2016 01:45PM


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.