MySQL Forums
Forum List  »  Performance

partitioning every year data
Posted by: mohamed bashid s
Date: April 13, 2013 07:20PM

i am using mysql 5.6, i am trying to implement partition (by range) for my existing tables(planning to seperate the data's year wise!),but i am not able do it for the tables which is having primary key as well as foreign key? somehow i need to separate the data's for every year for the purpose of client restriction from old datas.! can anyone help me to fix this? or anyother alternative solution to handle these kind of scenarios,with steps?

Options: ReplyQuote


Subject
Views
Written By
Posted
partitioning every year data
1363
April 13, 2013 07:20PM
728
May 02, 2013 12:00AM
622
May 02, 2013 07:57AM


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.