Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: krishna chandra prajapati (prajapatikcgmail.com)
Date: Fri Aug 03 2007 - 05:49:57 CDT
The data size is around 10 GB. Three months data will be around 600 to 700
MB. If i have deleted the data then how i will reclaim the free space as
innodb storage engine is being used. Data deletion will take a lot of time.
In addition to this i have to perform other task also.
My task is to keep 3 monts data on the production server. archive the whole
data and move it other computer. Reclaim the free space also.
Please give me the efficient way to do this job.
On 8/3/07, Sebastian Mendel <listssebastianmendel.de> wrote:
> krishna chandra prajapati schrieb:
> > Hi Sebastain,
> > On my production server there is two year data. So the hard disk is
> > 60% full. It contains user data also. On the basis of data column, i
> have to
> > keep only 3 months user data on the production server. I have to also
> > archive whole data and move it to other system.
> ok, this is your assigned task - but what is the problem?
> on a daily basis sync your production data with backup server
> and delete data on production server older than 3 month
> this is an application problem - cause only the application knows how
> data is
> IMHO MySQL has no native function to swap out aging data
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: