Hi Sebastain, 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. Regards, Krishna On 8/3/07, Sebastian Mendel <[EMAIL PROTECTED]> wrote: > > krishna chandra prajapati schrieb: > > Hi Sebastain, > > > > On my production server there is two year data. So the hard disk is > nearly > > 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 > 'old' > data is > > IMHO MySQL has no native function to swap out aging data > > -- > Sebastian > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > >
