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?
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?