DeveloperBreeze

Performance Schema Development Tutorials, Guides & Insights

Unlock 1+ expert-curated performance schema tutorials, real-world code snippets, and modern dev strategies. From fundamentals to advanced topics, boost your performance schema skills on DeveloperBreeze.

How to Monitor MySQL Database Performance

Tutorial August 12, 2024
mysql

To enable the slow query log, add the following lines to your my.cnf or my.ini file:

[mysqld]
slow_query_log = ON
slow_query_log_file = /path/to/slow-query.log
long_query_time = 2