Hiya Ulf, On 10/10/14 20:05, Ulf Markwardt wrote:
> the update procedure 2.6->14.11 of the slurmdbd adds a couple of > indexes to the database. For >> 10 Mio job entries this takes too > long. Could you define too long, and what problems it caused please? We're looking at upgrading Slurm to from 2.6 to 14.03 shortly and I believe that's when those extra indexes appear. We've got about 14 million rows across the various *_job_table and *_step_table. However, on our Percona Cluster (i.e. MySQL Galera) DB servers adding a multi-column index to an 8+ million row table in another database took just a few seconds. All the best, Chris -- Christopher Samuel Senior Systems Administrator VLSCI - Victorian Life Sciences Computation Initiative Email: sam...@unimelb.edu.au Phone: +61 (0)3 903 55545 http://www.vlsci.org.au/ http://twitter.com/vlsci