MySQL Forums
Forum List  »  Partitioning

Minimum number of rows for using partitioning
Posted by: Ramesh Kumar
Date: December 10, 2009 10:57PM

Hi,

I have some tables which have 1 million to 20 millions records. Currently I don't see any big performance hit while accessing(select/insert) the table due to indexing. But I would like to improve the performance using partition. I guess there might be some overheads to mysql while using partitions for small tables. But I am not sure. Kindly give your valuable suggestions for the below questions.

What are the minimum number of rows for using table partition will produce better performance ?

What are the minimum/maximum number of rows per partition will produce better performance ?


Thanks,
Ramesh



Edited 1 time(s). Last edit at 12/11/2009 01:04AM by Ramesh Kumar.

Options: ReplyQuote


Subject
Views
Written By
Posted
Minimum number of rows for using partitioning
5194
December 10, 2009 10:57PM


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.