… 2) partitions got data inserted to them per insert statement. As I tested the UPDATE path on INSERT OF DUPLICATE KEY UPDATE (adding ON DUPLICATE KEY UPDATE set c=c+1 to my bulk inserts) the regression became even larger. 1 partition insert took…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…, this is naturally an INSERT-only workload. The insertions into the base table from… sets, and features pluggable partition mapping, it allows partitioning resources to any depth and…storage node result set merge optimization enabled: ON DUPLICATE KEY UPDATE `origin_airport_id`=VALUES(`origin_airport…
Comment: Why MySQL could be slow with large tables ?
September 24, 2008 By 139 Comments
…, cnt) (where the pair id1, id2 forms the primary key) using INSERT … ON DUPLICATE KEY UPDATE cnt = cnt + 1. Obviously, the resulting table becomes… how I best restructure the DB to maintain an acceptable insert performance. Which are the most relevant parameters I should look… maybe built-in functionality to do such splitting? Or does partitioning only help if I have several servers (or hard-drives…
