Issue Slown queries with mariadb

[Erwan]

Hi all,

I want to log slow queries from Mariab (Plesk Onyx 17.8 - 5.5.60-MariaDB version 10).
I have updated the file /etc/my.cnf with:

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

And after restarted Mariadb:
#service mariadb restart

All like that: How to enable the MySQL slow query log and analyze it on Linux

But nothing in the file. And in PhpMyAdmin we have:
Slow queries => 7

And in the advices, we have:

"... the value of long_query_time is 10 seconds..."
"... the log_slow_queries is OFF..."

Is there another file for the mariadb configuration?
How can i log the slow query?

 

[Mihai]

the specs you modified in my.cnf should be enough. Can you check if the user under which the MariaDB service is running under has the permissions to modify /var/log/mysql-slow.log? The log file should have the same user.group as the Mariadb user/group.

 

[Erwan]

Thanks Mihai.

We have given "mysql:mysql" to the file. It seems good.

And i don't understand that in PhpMyAdmin we have "log_slow_queries => OFF" and in "my.cnf" slow_query_log = 1.
It's as if the changes in my.cnf haven't no effect...

 

[Mihai]

Hi Erwan,

Make sure you place those variables under [mysqld] and not under [mysqld_safe] directive, and you don't duplicate those variables with different values.