Re: Archive and Reduce Database Size to Optimize the site

[Rick James]

> I would need to reduce the database size to 1year at the time, and save the prior years as Archives on a 2nd database which can be accessed when desired..
This approach does not necessarily help. Let's look at your queries and SHOW CREATE TABLE.

Usually the 'right' solution is to add an appropriate INDEX. Other possibilities are modifying the SELECTs, and maybe PARTITIONing. Another possibility is the cache size. Let's see SHOW VARIABLES LIKE '%buffer%'.

I deal with tables with lots of old data (tens of gigabytes), yet they have been designed so that they continue to work just fine for "recent" data.