MySQL Forums
Forum List  »  Partitioning

Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"
Posted by: Jon Jacob
Date: July 20, 2014 07:50AM


I'm performing ~7 million "Insert ... On Duplicate Key Update" statements on a table.

At first I'm getting like ~1000 executed queries per second

Toward the end it has slowed down to ~1 per second...

The table in question has two fields that are unique keys:
date (text as yyyy-mm-dd)
pageid (numeric)

The update portion simply increments a counter field if there is already a date/pageid present.

Could a partition help with the degraded performance? I'm still reading up on how a table partition differs from a field index, but that's another topic. But am I barking up the wrong tree thinking partitions would help with this scenario?

Options: ReplyQuote

Written By
Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"
July 20, 2014 07:50AM

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.