I have a simple log table with data coming in, every 3 minutes from x sources.
That fills up and I’d need it for like 3 months for reports etc. and later on I would like to move the data to an archive (similar to piwik maybe) to save some rows in my active DB.
Any idea on how I’d do that? Simply INSERT SELECT or would it be better to compress it somehow? If so, how?