N
N
NataliaCh2018-04-17 18:22:05
MySQL
NataliaCh, 2018-04-17 18:22:05

How to enable logging of slow database queries on openserver?

In the settings I see a checkbox that basically enables / disables mysql query logs. And how to set up recording only slow ones?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dmitry Kim, 2018-04-17
@kimono

Prior to version 5.7
log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 1
From version 5.7
slow_query_log = /var/log/mysql/mysql-slow.log
long_query_time = 1

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question