Ticket 11066

Summary:	"Database settings not recommended values" error
Product:	Slurm	Reporter:	Will Dennis <wdennis>
Component:	Database	Assignee:	Marcin Stolarek <cinek>
Status:	RESOLVED INFOGIVEN	QA Contact:
Severity:	4 - Minor Issue
Priority:	---	CC:	cinek
Version:	20.11.4
Hardware:	Linux
OS:	Linux
See Also:	https://bugs.schedmd.com/show_bug.cgi?id=5248
Site:	NEC Labs	Alineos Sites:	---
Atos/Eviden Sites:	---	Confidential Site:	---
Coreweave sites:	---	Cray Sites:	---
DS9 clusters:	---	HPCnow Sites:	---
HPE Sites:	---	IBM Sites:	---
NOAA SIte:	---	OCF Sites:	---
Recursion Pharma Sites:	---	SFW Sites:	---
SNIC sites:	---	Linux Distro:	---
Machine Name:		CLE Version:
Version Fixed:		Target Release:	---
DevPrio:	---	Emory-Cloud Sites:	---

Description Will Dennis 2021-03-11 20:19:59 MST

Starting slurmdbd on a new cluster, seeing this:

slurmdbd: debug2: Attempting to connect to localhost:3306
slurmdbd: accounting_storage/as_mysql: _check_mysql_concat_is_sane: MySQL server version is: 10.1.47-MariaDB-0ubuntu0.18.04.1
slurmdbd: debug2: accounting_storage/as_mysql: _check_database_variables: innodb_buffer_pool_size: 134217728
slurmdbd: debug2: accounting_storage/as_mysql: _check_database_variables: innodb_log_file_size: 50331648
slurmdbd: debug2: accounting_storage/as_mysql: _check_database_variables: innodb_lock_wait_timeout: 50
slurmdbd: error: Database settings not recommended values: innodb_buffer_pool_size innodb_lock_wait_timeout

Where are the recommended values specified for these params?

Thanks.

Comment 1 Marcin Stolarek 2021-03-12 02:11:58 MST

Will,

The error is printed when configured values are less than half of recommendation/example form our web documentation[1]:

>innodb_buffer_pool_size=1024M
>innodb_log_file_size=64M
>innodb_lock_wait_timeout=900


cheers,
Marcin

[1]https://slurm.schedmd.com/accounting.html#slurm-accounting-configuration-before-build

Comment 3 Will Dennis 2021-03-12 11:59:56 MST

Thanks for the doc reference. Will use that to make the needed param changes to MySQL my.cnf file. OK to close.