EXPLAIN plans, index strategies, query refactoring, partitioning, and advanced MySQL performance tuning.