🔗 SQL performance improvements: finding the right queries to fix (part 1)

A few weeks ago, we massively improved the performance of the dashboard & website by optimizing some of our SQL queries. In this post, we'll share how we identified the queries that needed work. In the next post, we'll explore how we fixed each of them.

We'll cover the basics and gradually work our way up to the more advanced/complex ways of identifying slow queries.

In this post, you'll see:

• Using a local debug-bar to identify queries
• Using MySQL slow query log
• Logging queries that don't use indexes
• Evaluating currently running queries live
• Analysing the global query log
• 2 MySQL bonusses: better CLI output&redirecting output to files
• Enforce eager loading in local Laravel environment