MySQL Forums
Forum List  »  Partitioning

Re: Range Partition
Posted by: Peter Brawley
Date: June 17, 2017 10:41AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
2351
June 17, 2017 06:09AM
Re: Range Partition
1257
June 17, 2017 10:41AM
1275
June 18, 2017 01:05AM
1199
June 18, 2017 10:52AM


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.