[slurm-users] Database Tuning w/SLURM

[Prentice Bisbal]

On 3/21/19 1:56 PM, Ryan Novosielski wrote:
>> On Mar 21, 2019, at 12:21 PM, Loris Bennett <loris.bennett at fu-berlin.de> wrote:
>>
>>   Our last cluster only hit around 2.5 million jobs after
>> around 6 years, so database conversion was never an issue.  For sites
>> with a higher-throughput things may be different, but I would hope that
>> at those places, the managers would know the importance of planned
>> updates and testing.
> I’d be curious about any database tuning you might have done, or anyone else here. SchedMD’s guidance is minimal.
>
> I’ve ever been impressed with the performance on ours, and I’ve also seen other sites reporting >24 hour database conversion times.

I haven't heard numbers that big, but I have definitely  heard on the 
order of an hour or more. My DB must be very small relative to others, 
because my conversion after an update usually takes 3-5 minutes at most.

--
Prentice