Find MySQL Slow Queries by Activating the Slow Query Log - 7 minutes - Lately in PHP Podcast Episode 93 Part 1

By Manuel Lemos

One of the factors that may make a Web application slow is the speed of execution of database queries executed by the application back-end code.

If you optimize the database queries that are the slowest, it may make a lot of impact on the speed of an application.

The first step in optimizing the slowest database queries is to find which are the slowest queries. Using MySQL as the database server, you can find the slowest queries by activating the slow query log.

Read this article, watch a 7-minute video, or listen to part 1 of episode 93 of the Lately in PHP podcast to learn how to enable the MySQL slow query log.