MySQL Forums
Forum List  »  Partitioning

partitioning
Posted by: mysql learner
Date: August 27, 2008 07:20AM

Hi
I have configured partitioning with range option in which the table have more than 17 million records.
for this i have set range partitioning 40 which almost have 400000 records in single partition.
Please suggest me is thr anything which will help me to configure using alphabetically.
eg:username starts with a in one partition b in second like that.
and update me how many partition a single table can have and will that affects performance of database.
thanks in advance

Options: ReplyQuote


Subject
Views
Written By
Posted
partitioning
3208
August 27, 2008 07:20AM
2167
August 29, 2008 09:39AM


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.