May 25, 2012

Post: How Percona does a MySQL Performance Audit

very well. The audit itself OK, so here’s a very basic audit, whose scope I’ll keep within just a MySQL…the workload is a star schema data warehouse, … mysqlsla -lt slow /path/to/slow.log By…on the scale. Now I analyze these one at a time. For each query, I run EXPLAIN if possible (rewriting non-SELECT