That's a really good point. Pruning your DB can also help with this.
-Paul Edmon-
On 06/20/2017 09:19 AM, Loris Bennett wrote:
Hi Tim,
Tim Fora <[email protected]> writes:
Hi,
Upgraded from 15.08 to 17.02. It took about one hour for slurmdbd to
start. Logs show most of the time was spent on this step and other table
changes:
adding column admin_comment after account in table
Does this sound right? Any ideas to help things speed up.
It probably depends a great deal on how many entries you have in your
database and what sort of hardware you have. We are up to around 1.6
million jobs and have never purged anything. I seem to remember the
last update between major releases taking long enough to allow me to get
slightly uneasy, but not long enough for me to really worry, so I guess
it was probably around 10-15 minutes. Our CPUs are around 6 years old,
but the DB is on an SSD.
HTH
Loris
