Re: [slurm-users] Slurmdbd purge settings

2021-02-23 Thread Luke Sudbery
> -Original Message- > From: slurm-users On Behalf Of > ole.h.niel...@fysik.dtu.dk > Sent: 23 February 2021 15:04 > > Just a thought: Do you run a recent Slurm version? Which version of > MariaDB/MySQL do you run? > /Ole We're currently running Slurm 20.02.6-1 and MariaDB 10.3.28. But

Re: [slurm-users] Slurmdbd purge settings

2021-02-23 Thread Luke Sudbery
puter Centre G5, Elms Road Please note I don’t work on Monday. > -Original Message- > From: ahmet.mer...@uhem.itu.edu.tr > Sent: 23 February 2021 14:20 > To: Slurm User Community List ; Luke > Sudbery (Advanced Research Computing) > Subject: Re: [slurm-users] Slurmdbd pu

Re: [slurm-users] Slurmdbd purge settings

2021-02-23 Thread Ole Holm Nielsen
On 23-02-2021 15:19, mercan wrote: Hi; May be the database can not fit innodb buffer any more. If there are enough room to increase this value(innodb_buffer_pool_size) , to find reason, you can try the increase. The details of modifying the Innodb parameters are described in https://wiki.fys

Re: [slurm-users] Slurmdbd purge settings

2021-02-23 Thread mercan
Hi; May be the database can not fit innodb buffer any more. If there are enough room to increase this value(innodb_buffer_pool_size) , to find reason, you can try the increase. Ahmet M. 23.02.2021 17:03 tarihinde Luke Sudbery yazdı: That great, thanks. We were thinking about staging it lik

Re: [slurm-users] Slurmdbd purge settings

2021-02-23 Thread Luke Sudbery
Message- > From: slurm-users On Behalf Of > ole.h.niel...@fysik.dtu.dk > Sent: 23 February 2021 13:24 > To: slurm-users@lists.schedmd.com > Subject: Re: [slurm-users] Slurmdbd purge settings > > On 2/23/21 1:25 PM, Luke Sudbery wrote: > > We have suddenly got bad performa

Re: [slurm-users] Slurmdbd purge settings

2021-02-23 Thread Ole Holm Nielsen
On 2/23/21 1:25 PM, Luke Sudbery wrote: We have suddenly got bad performance from sreport, querying a 1 hour period (in the last 24 hours) for TopUsage went from taking under a minute to timing out after the 15 minutes max slurmdbd query time – although the SQL query on the DB server continued

Re: [slurm-users] Slurmdbd purge settings

2021-02-23 Thread Luke Sudbery
y. From: slurm-users On Behalf Of Luke Sudbery Sent: 23 February 2021 12:26 To: slurm-users@lists.schedmd.com Subject: [slurm-users] Slurmdbd purge settings We have suddenly got bad performance from sreport, querying a 1 hour period (in the last 24 hours) for TopUsage went from taking under a

[slurm-users] Slurmdbd purge settings

2021-02-23 Thread Luke Sudbery
We have suddenly got bad performance from sreport, querying a 1 hour period (in the last 24 hours) for TopUsage went from taking under a minute to timing out after the 15 minutes max slurmdbd query time - although the SQL query on the DB server continued long after that. So firstly we were wond