Ticket 11066 - "Database settings not recommended values" error
Summary: "Database settings not recommended values" error
Status: RESOLVED INFOGIVEN
Alias: None
Product: Slurm
Classification: Unclassified
Component: Database (show other tickets)
Version: 20.11.4
Hardware: Linux Linux
: 4 - Minor Issue
Assignee: Marcin Stolarek
QA Contact:
URL:
Depends on:
Blocks:
 
Reported: 2021-03-11 20:19 MST by Will Dennis
Modified: 2021-03-15 01:12 MDT (History)
1 user (show)

See Also:
Site: NEC Labs
Slinky Site: ---
Alineos Sites: ---
Atos/Eviden Sites: ---
Confidential Site: ---
Coreweave sites: ---
Cray Sites: ---
DS9 clusters: ---
Google sites: ---
HPCnow Sites: ---
HPE Sites: ---
IBM Sites: ---
NOAA SIte: ---
NoveTech Sites: ---
Nvidia HWinf-CS Sites: ---
OCF Sites: ---
Recursion Pharma Sites: ---
SFW Sites: ---
SNIC sites: ---
Tzag Elita Sites: ---
Linux Distro: ---
Machine Name:
CLE Version:
Version Fixed:
Target Release: ---
DevPrio: ---
Emory-Cloud Sites: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this ticket.
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.