MySQL Forums
Forum List  »  Newbie

Re: Partitioning or Not Partitioning?
Posted by: Wayne Rasmussen
Date: November 24, 2014 05:14PM

Rick James Wrote:
-------------------------------------------------------
> Even if it is just terabytes, we need to look very
> seriously at the number of indexes on the table.
> Even one secondary index could make it
> _impossible_ to INSERT 5000 rows/second, whether
> partitioned or not, whether using SSDs or not,
> etc.

Rick,
Is the issue of more than one index due to recalculation of indexes?

Options: ReplyQuote


Subject
Written By
Posted
Re: Partitioning or Not Partitioning?
November 24, 2014 05:14PM


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.