![慢查询日志:mariadb oa debian 12 上应该在哪里配置?](https://linux22.com/image/224959/%E6%85%A2%E6%9F%A5%E8%AF%A2%E6%97%A5%E5%BF%97%EF%BC%9Amariadb%20oa%20debian%2012%20%E4%B8%8A%E5%BA%94%E8%AF%A5%E5%9C%A8%E5%93%AA%E9%87%8C%E9%85%8D%E7%BD%AE%EF%BC%9F.png)
如果我做
show global variables like "%slow%"
我得到这些结果
但我无法找到这些值的设置位置。
我试图找到,几乎
cd /etc/mysql
grep slow -R -n
并得到了完全不同的结果
mariadb.conf.d/50-server.cnf:21:# Broken reverse DNS slows down connections considerably and name resolve is
mariadb.conf.d/50-server.cnf:63:# Enable the slow query log to see queries with especially long duration
mariadb.conf.d/50-server.cnf:64:#log_slow_query_file = /var/log/mysql/mariadb-slow.log
mariadb.conf.d/50-server.cnf:65:#log_slow_query_time = 10
mariadb.conf.d/50-server.cnf:66:#log_slow_verbosity = query_plan,explain
mariadb.conf.d/50-server.cnf:68:#log_slow_min_examined_row_limit = 1000
conf.d/mysql.cnf:3:log_slow_query = on
conf.d/mysql.cnf:4:log_slow_query_file = /var/log/mysql/slow.log
conf.d/mysql.cnf:5:log_slow_query_time = 1.0
conf.d/mysql.cnf:6:log_slow_verbosity = query_plan,explain
conf.d/mysql.cnf:7:log_slow_min_examined_row_limit = 10
该死的“debian-slow.log”文件在哪里设置?我应该在哪里以及如何覆盖这些配置?为什么我的conf.d/mysql.cnf 文件被完全忽略?