search

clustervision / trinityX

TrinityX is the new generation of ClusterVision's open-source HPC, A/I and cloudbursting platform. It is designed from the ground up to provide all services required in a modern HPC and A/I system, and to allow full customization of the installation.
GNU General Public License v3.0
55 stars 36 forks source link

SlurmDBD default recommended values #405

Closed msteggink closed 3 months ago

msteggink commented 4 months ago

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 commented 4 months ago

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

aphmschonewille commented 3 months ago

included as of now.