Re: Backup and trimming data idea

[Rick James]

PARTITION only the tables that can take advantage of PARTITIONing. "Big DELETEs" is a good use case for PARTITION.

If you would like to provide the following, I will make a stab at the "optimal indexes":
SHOW CREATE TABLE -- for each table
SHOW TABLE STATUS -- for each table
SELECT -- including JOIN cases

In the process of designing _your_ indexes, I can probably explain 'why' I am picking the indexes. There is a pretty good chance that my set of INDEXes will be optimal for the set of SELECTs you provide. By "optimal, I mean:
* Makes all the SELECTs efficient. (They may not be the most efficient, but they should be close.)
* Minimizes the number of indexes. (Extra indexes have a small cost to INSERTs, so one does not want to create more indexes than necessary.)