Wondering if anyone has any recommendation around doing ‘analyze table’ as part of archiving.
we are archiving a large chunk of data from our production system (almost 60M records) from 100 different tables. We plan to do this in batches and archive based on date (e.g. for each month in past). The tables are mix of InoDB and MyISAM, so I’m wondering if we are better off doing the table analyze after all the data has been archived or along every step (i.e. after each month) or even sooner than that?
we obviously don’t want to lock down the production tables for long!