Performance Checklist
A practical checklist: use EXPLAIN on slow queries, index FK columns, avoid SELECT *, avoid functions on indexed columns, use connection pooling, tune innodb_buffer_pool_size, enable slow query log.
MySQL
Intermediate
4 min read
MySQL Performance Checklist
Example
-- Quick health check queries
SHOW STATUS LIKE 'Slow_queries';
SHOW STATUS LIKE 'Select_full_join'; -- bad: full joins
SHOW STATUS LIKE 'Select_full_range_join';
SHOW STATUS LIKE 'Created_tmp_disk_tables'; -- disk spill Pro Tip
Select_full_join > 0 means you have JOINs without indexes on join columns.