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/H2SKt/333/

I like it because D3.js is fluid and reactive, and feeding it JSON-formatted data is so easy. Hope that helps someone else!

Alan

On 03/30/2013 07:17 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 scripts before I start writing my own.

The kinds of things I have I'm interested in are showing usage, average run time, average wait time, jobs completed, etc.

Cheers,

--
Alan Orth
[email protected] <mailto:[email protected]>
http://alaninkenya.org
http://mjanja.co.ke
"In heaven all the interesting people are missing." -Friedrich Nietzsche

--
Alan Orth
[email protected]
http://alaninkenya.org
http://mjanja.co.ke
"I have always wished for my computer to be as easy to use as my telephone; my wish 
has come true because I can no longer figure out how to use my telephone." -Bjarne 
Stroustrup, inventor of C++

Reply via email to