CALS NOTE

  • Home
  • Archives
  • Cheatsheets
  • rss
  • About
  • Friends
2018-11-07 Calvin Lam
Comments

Enable MySQL slow query log

MySQL

Enviroment

  • MySQL 5.7.23
  • MAMP 5.1

my.cnf

Update MySQL config file /Applications/MAMP/conf/my.cnf

1
2
3
4
[mysqld]
slow_query_log = 1
slow_query_log_file = /Applications/MAMP/db/mysql57/mysql-slow.log
long_query_time = 0

Run SQL query

1
Show variables where Variable_name like '%slow%';
  • Database
  • Debug
  • Logs
  • MySQL
  • SystemAdmin
Newer
IT automation - Ansible
Older
Cusomte a PHP docker image

CALS NOTE

© 2020 Calvin Lam
Modify from Apollo theme, designed by SANOGRAPHIX.NET
Powered by Hexo