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
