I have a qnap with mariadb 10 and phpmyadmin. For the Mariadb configuration there are two different routes:
/etc/config/my.cnf
and
/usr/local/mariadb/my-mariadb.cnf
I need to modify the sort_buffer_size variable but if I edit those files, restart mariadb and check in phpmyadmin, the value of the sort_buffer_size variable does not change.
Do you know why it doesn't change?
I can change it manually from phpmyadmin but when I restart mariadb then it loads the old value that it has in maria db's file.