I'm about to update 15.08 to the latest SLURM in August and would appreciate any notes you have on the process.
I'm especially interested in maintaining the DB as well as associations. I'd also like to keep the pending job list if possible. I've only got around 100,000 jobs in the DB so far, since January. Thanks Nick McCollum Alabama Supercomputer Authority On Jun 20, 2017 8:07 AM, Paul Edmon <[email protected]> wrote: Yeah, that sounds about right. Changes between major versions can take quite a bit of time. In the past I've seen upgrades take 2-3 hours for the DB. As for ways to speed it up. Putting the DB on newer hardware if you haven't already helps quite a bit (depends on architecture as to how much gain you will get, we went from AMD Abu Dhabi to Intel Broadwell and saw a factor of 3-4 speed improvement). Upgrading to the latest version of MariaDB if you are on an old version of MySQL can get you about 30-40%. Doing all of these whittled our DB upgrade times for major upgrades to about 30 min or so. Beyond that I imagine some more specific DB optimization tricks could be done, but I'm not a DB admin so I won't venture to say. -Paul Edmon- On 06/20/2017 08:42 AM, Tim Fora wrote: > 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. > > Thanks, > Tim > >
