Mysql tuning in action…
Yesterday me, and our development team made some tuning of one old project we have couple of tables with 1-10 million records.
It`s NOT BIGDATA, but application makes huge writes to this table.
Only current date records, but you understand partitioning affects index size.
Table can be partitioned by date field. So how to do it:

1. make sure that dt not null.
2. recreate primary key. Field for partition should be part of primary key.
3. create partition for old years and partition for every month.

Read more »