MySQL Forums
Forum List  »  Partitioning

RE:How to make Partition for mytable
Posted by: venkat puvvada
Date: April 12, 2011 11:40PM

Hi all,
This is venkat,i would like to share my problem here,my problem is
I Have a table which is having more then 70 million records,and it will update daily with 1milion records.when we are doing partition based on the primary key for my table [3 primary key fields,one filed used for partition which is of type date] we are not getting good result because the fields which we are using in the query not a part of the partition fields .
can any one suggest me how to resolve this case because we have lot query's,it is very difficult to change all the query's,please help me how to make partition fo r this case.

thanks,
venkat p



Edited 2 time(s). Last edit at 04/12/2011 11:47PM by venkat puvvada.

Options: ReplyQuote


Subject
Views
Written By
Posted
RE:How to make Partition for mytable
2375
April 12, 2011 11:40PM


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.