How do you guys keep your tables lean in production? If in a particular table, data older than a 6 months is never modified, and not required, is there a solution which backs that data up to another location and deletes it in this table? (Talking about MySQL here)

Is this done in custom batch scripts or is such a solution already available?

You may want to investigate partitioned tables.