tag:blogger.com,1999:blog-16959946.post114139232159991409..comments2023-12-09T16:44:47.897+01:00Comments on The Data Charmer: MySQL 5.1: Improving ARCHIVE performance with partitioningGiuseppe Maxiahttp://www.blogger.com/profile/15801583338057324813noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-16959946.post-49423204287536857952010-11-11T07:03:15.415+01:002010-11-11T07:03:15.415+01:00I understand that archiving of data means moving t...I understand that archiving of data means moving the data from operational table to another table whose engine type is archive. However my doubts is still the load on the operational database due to the historical data is not reduced by 100%. I am looking for any way by which user could archive the data in a remove mysql process? Is this a valid problem, if so how it is approached in real timeAnonymousnoreply@blogger.com