MySQL High Performance Part 3 – EXPLAIN Queries
Introduction Once we have a candidate query for optimization, we need to analyze why it is slow, or why it impacts the system soo much.… Read More »MySQL High Performance Part 3 – EXPLAIN Queries
MySQL
MySQL High Performance Part 2 – Finding Candidates for Query Optimizations
Key Takeaways The Performance Schema is a gold mine for finding querying to optimize becuase it allows us to collecting the necessary data to make… Read More »MySQL High Performance Part 2 – Finding Candidates for Query Optimizations
MySQL Performance Tuning Part 1 – Architecture
Key Takeaways We need to understand MySQL design so that we can work with it, and not against it. Everything in InnoDB is an index.… Read More »MySQL Performance Tuning Part 1 – Architecture