Re: [slurm-users] sacct runtime performance varies on job status codes

2023-09-01 Thread Michael DiDomenico
i can't directly answer you're question, but i suspect there's a missing index somewhere. what i would do is turn on the mysql query log and look at the sql and explain plan associated. it's also possible that since you're a few rev's behind it's already been fixed in a later version, so you coul

[slurm-users] sacct runtime performance varies on job status codes

2023-09-01 Thread John Snowdon
Hi, I am attempting to pull some historical information from our HPC system to analyse some trends of our users over time. As part of this I am using sacct to make a number of queries for different jobs statuses (running, pending, completed, 'other') over particular time periods (hourly, daily