My.cnf file on Mac Sierra for Slow Queries

Question

I am trying to set the time for my slow_query_log but I cannot find the right file:

I got a file under /usr/local/var/mysql

MYUSER-slow.log

which shows me the queries taking 10seconds (standard in MYSQL is 10sec) - I edited the my-default.cnf under /usr/local/Cellar/mysql/5.7.17/support-files/ and also added this after creating /etc/my.cnf

slow_query_log = 1
slow_query_log_file = /var/log/mysql/slow-queries.log
long_query_time = 1

Nothing seems to work tho. Who can I set the query time top 1 sec?

score 2 · Accepted Answer · answered May 29 '17 at 16:37

After editing the my.cnf, you need to restart mysqld to have it take effect. The configuration file is read only during startup of mysqld.

You can also set those variables dynamically. Dynamic global variables can be changed while mysqld is running, and the change affects any subsequent sessions (current sessions don't inherit global changes).

mysql> SET GLOBAL slow_query_log = 1;
mysql> SET GLOBAL slow_query_log_file = /var/log/mysql/slow-queries.log;
mysql> SET GLOBAL long_query_time = 1;

Not all global variables support dynamic changes, some require a restart. This is documented per variable at https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html

Thank you Bill - setting the GLOBALS was the solution. – Isengo May 29 '17 at 18:23 — Isengo, May 29 '17 at 18:23

My.cnf file on Mac Sierra for Slow Queries

1 Answers1