MySQL Forums :: Performance :: partitioning every year data
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?
|partitioning every year data||1185||mohamed bashid s||04/13/2013 07:20PM|
|Re: partitioning every year data||539||Mikael Ronström||04/24/2013 12:30PM|
|Re: partitioning every year data||524||mohamed bashid s||04/29/2013 04:53AM|
|Re: partitioning every year data||598||Rick James||05/02/2013 12:00AM|
|Re: partitioning every year data||551||mohamed bashid s||05/02/2013 02:59AM|
|Re: partitioning every year data||534||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.