MySQL Forums
Forum List  »  Newbie

Re: Partitioning or Not Partitioning?
Posted by: Rick James
Date: November 06, 2014 07:16PM

> What is? I don't see the answer, it's a spam?

What do you mean?

Your main problem is inserting 5000 rows per second. PARTITIONing will help that. Nor will having multiple tables. So, I am trying to direct your attention to the problem of input speed.

After that is resolved, we can get back to whether to PARTITION or not. Note: It is mostly SELECTs that determine the utility of PARTITIONing, not INSERTs.

Also, please tell us what type of disk system you have. RAID and SSDs can _partially_ help you achieve 5000/sec. But generally other techniques should be used.

Options: ReplyQuote


Subject
Written By
Posted
Re: Partitioning or Not Partitioning?
November 06, 2014 07:16PM


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.