Fork me on GitHub
#sql
<
2018-10-03
>
jaihindhreddy09:10:00

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)

jaihindhreddy09:10:41

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

donaldball15:10:03

You may want to investigate partitioned tables.

👍 4