In my experience the built-in partitioning support of MySQL (using PARTITION BY RANGE for example) is very good. Inserts no longer drag due to huge indexes, de

In my experience the built-in partitioning support of MySQL (using PARTITION BY RANGE for example) is very good. Inserts no longer drag due to huge indexes, delete's are instant (drop a partition of stale data), and SELECT's can limit their lookups to specific underlying files. This is for a 500m row table of time series data.