Rick's MySQL DocumentsMySQL Documents by Rick James HowTo Techniques for Optimizing Tough Tasks: Partition Maintenance (DROP+REORG) for time series (includes list of PARTITION uses) Big DELETEs - how to optimize -- and other chunking advice, plus a use for PARTITIONing Chunking lengthy DELETE/UPDATE/etc. Data Warehouse techniques: Data Warehouse Overview Summary Tables High speed ingestion Bulk Normalization Schema and
