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 For useful partitioning rules of thumb see

Options: ReplyQuote

Written By
June 17, 2017 06:09AM
Re: Range Partition
June 17, 2017 10:41AM
June 18, 2017 01:05AM
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.