SlurmDBD default recommended values

[msteggink]

On a default install, SlurmDBD comes online with the following message:

Apr 23 15:27:39 slurm systemd[1]: Started Slurm DBD accounting daemon.
Apr 23 15:27:39 slurm slurmdbd[1206]: slurmdbd: accounting_storage/as_mysql: _check_mysql_concat_is_sane: MySQL server version is: 10.5.22-MariaDB
Apr 23 15:27:39 slurm slurmdbd[1206]: slurmdbd: error: Database settings not recommended values: innodb_buffer_pool_size innodb_lock_wait_timeout
Apr 23 15:27:40 slurm slurmdbd[1206]: slurmdbd: accounting_storage/as_mysql: init: Accounting storage MYSQL plugin loaded
Apr 23 15:27:40 slurm slurmdbd[1206]: slurmdbd: slurmdbd version 22.05.8 started

When adding the following lines to /etc/my.cnf, the message will disappear.

cat /etc/my.cnf
#
# Ansible managed
#

[mysqld]
datadir=/trinity/local/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0

innodb_file_per_table=1
innodb_buffer_pool_size=1024M
innodb_log_file_size=64M
innodb_lock_wait_timeout=900

The template file: trinityX/site/roles/trinity/mariadb/templates/etc_my.cnf.j2

See also: https://bugs.schedmd.com/show_bug.cgi?id=11066

[aphmschonewille]

noted. thank you for this one. we will include this in the next push.

[aphmschonewille]

included as of now.