A client's database that had over 500K records in this table was causing a serious slowdown. Here was my approach.
No, seriously. Make backups using mysqldump.
Here's What I Did - After ...
You're correct, this is a behavior related to the system (server) and not Magento.
Automated file compression can be achieved through various methods, such as using logrotate or adding a cron job.