If table is partitioned it 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 …