Find MySQL Slow Queries in Production Activating the Slow Query Log: Lately in PHP Podcast 93 part 2

Securely activate MySQL slow query log to find the slow SQL queries in a production server.

0:49 SQL query to locate the MySQL slow query log file
1:15 Pause your applications before you restart your MySQL database server

When you want to optimize a MySQL database application in production, you should figure out the slowest queries in that environment.

Enabling the MySQL slow query log can help you figure out the slowest SQL queries to optimize first. You can do that in a production environment, but you need to take extra care with how you enable the slow query log to avoid causing harm to the application.

Watch this video of part 2 of episode 93 of the Lately in PHP podcast to learn how to enable the MySQL slow query log in a production environment in a safe way.

The link to the podcast article is in this video's comments.