[slurm-dev] Re: Interesting queries / plots for slurmdbd?

2013-03-31 Thread Marcin Stolarek
Hi all, I'd like to join this question. I remember someone presenting web based application allowing visualisation of accounting data from slurmdbd. Does anyone know a running solution? cheers, marcin 2013/3/30 Alan Orth > All, > > I've got a small cluster using MySQL for accounting and I'v

[slurm-dev] Re: Interesting queries / plots for slurmdbd?

2013-03-31 Thread Lipari, Don
, so think if it as an example of what could be done. Don From: Marcin Stolarek [mailto:stolarek.mar...@gmail.com] Sent: Sunday, March 31, 2013 5:13 AM To: slurm-dev Subject: [slurm-dev] Re: Interesting queries / plots for slurmdbd? Hi all, I'd like to join this question. I remember so

[slurm-dev] Re: Interesting queries / plots for slurmdbd?

2013-03-31 Thread Alan Orth
I sat down and worked on this a bit last night.  I've only got a few dozen lines of PHP so far, and I haven't quite decided how to plot them yet, but it's a start. :) For starters I think the following query would be a useful test case: select (time_end-time_start) as time_used, (time_start-ti

[slurm-dev] Re: Interesting queries / plots for slurmdbd?

2013-04-03 Thread Alejandro Lucero Palau
Upps! the promised file attached. On 03/30/2013 05:19 PM, Alan Orth wrote: > All, > > I've got a small cluster using MySQL for accounting and I've got some > ideas about the type of data I'd like to pull out of my database. > Just checking to see if anyone has already written queries or gnuplot

[slurm-dev] Re: Interesting queries / plots for slurmdbd?

2013-05-30 Thread Alan Orth
Hi, I've been tinkering with this on and off and thought I'd share some progress. I whipped up something to graph the top SLURM users (by number of jobs) using PHP + JSON from DB + NVD3.js + D3.js. Here's a jsFiddle showing what it looks like (including SQL query): http://jsfiddle.net/H2SK