Re: Range Partition

[Peter Brawley]

Multiple cores? Good HD hardware? OS? RAM?

What is innodb_buffer_pool_size? Is there replication? Let's see my.cnf, and the result of Show Engine InnoDB Status.

The Create Table SQL you posted shows just the PK index, let's see the full Show Create Table result.

You are bulk inserting a billion rows/day in 1000 million-row chunks? Via Load Data? There's work to do here.

Partitioning may slow down Inserts, eg see http://www.nilinfobin.com/mysql/performance-of-inserts-on-partitions-mysql-5-6-vs-mysql-5-7. For useful partitioning rules of thumb see http://mysql.rjweb.org/doc.php/ricksrots#partitioning.