MySql Querys - Slow server

Question

I have a CentOS 7 server.

Since a few days the server behavior has been critically slow due a lot of mysql querys in the web app we have there.

I´ve tried to setup mariaDB server.cnf to log the slow-querys and the general-querys whitout having any response or log, I don´t know why it isn´t log any query.

Please help...

score 0 · Answer 1 · answered Jul 18 '18 at 06:19

0

The setup for the logs is rather convoluted.

You also need

log_output = FILE

answered Jul 18 '18 at 06:19

Rick James

135,179
13
127
222

@AndresZambrano - What is the value of `slow_query_log_file`? – Rick James Aug 16 '18 at 20:24
More discussion: http://mysql.rjweb.org/doc.php/mysql_analysis#slow_queries_and_slowlog – Rick James Aug 16 '18 at 20:26

MySql Querys - Slow server

1 Answers1