MySQL Forums
Forum List  »  Partitioning

Impact of larger partition number on database performance
Posted by: Kamal Joshi
Date: April 04, 2007 07:36AM

Hi,

We have done partitioning of a big table:

Records = 57 millions
Number of Partitions = 1000
Partition type = hash

After the partition, we are facing high CUP usage problem even for the low load in database.
Is this because of the partitioning with large number (1000) of partitions?

If yes, then what should be the ideal number of partitions in this case for better performance?

Please help!

Thanks,
Kamal Joshi

Options: ReplyQuote


Subject
Views
Written By
Posted
Impact of larger partition number on database performance
4279
April 04, 2007 07:36AM


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.