Setting log-basename overrides slow_query_log_file

sudo su

curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup |  bash -s -- --mariadb-server-version=mariadb-11.1.1

yum install MariaDB-server

systemctl start mariadb

echo "

[mariadb]

log_slow_query_time = 1

log_slow_query = 1

log_slow_query_file = /var/log/mariadb/slow-queries.log" >> /etc/my.cnf.d/server.cnf

mkdir /var/log/mariadb

chown mysql:mysql /var/log/mariadb

systemctl restart mariadb

# works as expected

mariadb -e "SELECT SLEEP(5);"

cat /var/log/mariadb/slow-queries.log

# does not work as expected. /var/log/mariadb/slow-queries.log isnt used anymore now

echo "log-basename=any-prefix" >> /etc/my.cnf.d/server.cnf

systemctl restart mariadb

mariadb -e "SELECT SLEEP(4);"

cat /var/log/mariadb/slow-queries.log

# instead its using /var/lib/mysql/any-prefix-slow.log

cat /var/lib/mysql/any-prefix-slow.log

[mariadb]

log-basename=any-prefix

log_slow_query_time = 1

slow_query_log = 1

slow_query_log_file = /var/log/mariadb/slow-queries.log