Skip navigation links

MySQL Forums :: Performance :: partitioning every year data


Advanced Search

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 715 mohamed bashid s 04/13/2013 07:20PM
Re: partitioning every year data 331 Mikael Ronström 04/24/2013 12:30PM
Re: partitioning every year data 309 mohamed bashid s 04/29/2013 04:53AM
Re: partitioning every year data 347 Rick James 05/02/2013 12:00AM
Re: partitioning every year data 305 mohamed bashid s 05/02/2013 02:59AM
Re: partitioning every year data 339 Rick James 05/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.