Page 1 of 1

Mysql-name resolution 10.2.30-MariaDB

Posted: 27 Aug 2021 12:17
by henk
After updating efa (dd. 27-08-2021) and moving to 10.2.30-MariaDB Server, I noticed name resolution was active again.

2021-08-27 14_03_08-MailWatchMozi.png
2021-08-27 14_03_08-MailWatchMozi.png (11.04 KiB) Viewed 1399 times
The reason is quite simple as is the solution: change [mariadb-10.1] to [mariadb-10.2] and restart Mariadb

Code: Select all

/etc/my.cnf.d/mariadb-server.cnf

Code: Select all

#[mariadb-10.1]
[mariadb-10.2]
bind-address = 127.0.0.1
innodb-defragment = 1
innodb_buffer_pool_instances = 1
skip-name-resolve
skip-host-cache
On top of that I changed the swappiness default value to 1

Code: Select all

cat /etc/sysctl.d/vm.swappiness.conf
Source and howto: https://mariadb.com/kb/en/configuring-swappiness/

Re: Mysql-name resolution 10.2.30-MariaDB

Posted: 27 Aug 2021 23:02
by shawniverson
Good catch, I missed this one, rolling it into next update