If a table is partitioned then that makes it easy to maintain.
Table has grown so huge and the backups are just keep running
long then probably you need to think of archival or purge.
Purge the data if you don't want data from old partitions
just by doing truncate or drop of those partitions which
completes momentarily without locking the table for a long
time
Archival can be done couple of ways.
We can take mysqldump (preferably from a slave) with a
where condition to filter out the data you don't want to copy.
And then import the dump file to archive database. check this
link out for mysqldump with where clause .. and once data is
copied, …
Showing entries 1 to 1
Mar
18
2015
Showing entries 1 to 1