[slurm-users] MariaDB lock problems for sacctmgr delete query
chris at csamuel.org
Fri Feb 16 05:44:03 MST 2018
On 16/02/18 22:23, Ole Holm Nielsen wrote:
> Question: Is it safer to wait for 17.11.4 where the issue will
> presumably be solved?
I don't think the commit has been backported to 17.11.x to date.
It's in master (for 18.08) here:
Author: Tim Wickberg <tim at schedmd.com>
Date: Tue Feb 13 21:34:33 2018 -0700
Remove AUTO_INCREMENT resets when removing an association from the
These calls are apparently quite expensive on larger databases,
and nothing requires that the association id number not have any
skipped values. So stop doing this.
Performance problems first reported by Jessica Nettelblad.
All the best,
More information about the slurm-users