MySQL Forums
Forum List  »  Partitioning

Re: Partitioning help
Posted by: Rick James
Date: October 12, 2010 08:03AM

The main thing that could slow down INSERTs is having lots of indexes.

Let's see your tentative schema. SHOW CREATE TABLE.

I'm still concerned about the math. What is the peak number of rows/minute?

Since you are mostly INSERTing, and assuming that you have few indexes, RAM will not be an issue. Buy what is convenient, and set innodb_buffer_pool_size to 70% of it.

When you do SELECT, are you selecting 1 row? Or many? If it is too many, it could blow out the cache and make the INSERTs slow. (So, let's not 'sweep it under the rug'.)

Options: ReplyQuote


Subject
Views
Written By
Posted
3170
September 24, 2010 02:16AM
1697
September 25, 2010 01:09PM
1667
September 27, 2010 03:43AM
1628
September 27, 2010 07:55PM
1592
October 12, 2010 01:55AM
Re: Partitioning help
1588
October 12, 2010 08:03AM
1509
October 13, 2010 03:27AM
1549
October 13, 2010 06:03PM


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.