How to delete most data from a 2,000GB Mysql InnoDB table
I have a Mysql InnoDB table with storage size(+index) over 2,000GB, There are 14 billion rows in that table.. I need to drop data added over 1 month ago, and figure out a way to always keep recent 1 month…