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
> 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
WARNING / LEGAL TEXT: This message is intended only for the use of the
individual or entity to which it is addressed and may contain
information which is privileged, confidential, proprietary, or exempt
from disclosure under applicable law. If you are not the intended
recipient or the person responsible for delivering the message to the
intended recipient, you are strictly prohibited from disclosing,
distributing, copying, or in any way using this message. If you have
received this communication in error, please notify the sender and
destroy and delete any copies you may have received.
http://www.bsc.es/disclaimer
<?xml version="1.0" encoding='UTF-8'?>
<article lang="en">
<subtitle> Week Report from 2013-02-01 to 2013-02-08</subtitle>
<ClusterUtilization>
<TotalTimeAllocated>
<LW>55,4%</LW>
<L3W>60,4%</L3W>
<L3M>56,8%</L3M>
<LY>54,4%</LY>
</TotalTimeAllocated>
<TotalTimeIdle>
<LW>36,4%</LW>
<L3W>22,1%</L3W>
<L3M>22,4%</L3M>
<LY>31,7%</LY>
</TotalTimeIdle>
<TotalTimeReserved>
<LW>4,3%</LW>
<L3W>4,9%</L3W>
<L3M>3,0%</L3M>
<LY>6,3%</LY>
</TotalTimeReserved>
<TotalTimeDown>
<LW>3,9%</LW>
<L3W>12,6%</L3W>
<L3M>12,1%</L3M>
<LY>5,9%</LY>
</TotalTimeDown>
</ClusterUtilization>
<JobsStats>
<Submitted>
<LW>8147</LW>
<L3W>3886,0</L3W>
<L3M>11225,9</L3M>
<LY>7310,2</LY>
</Submitted>
<Started>
<LW>8012</LW>
<L3W>3137,3</L3W>
<L3M>10736,1</L3M>
<LY>6785,8</LY>
</Started>
<Completed>
<LW>3642</LW>
<L3W>2421,0</L3W>
<L3M>10050,3</L3M>
<LY>5981,7</LY>
</Completed>
<Cancelled>
<LW>393</LW>
<L3W>961,7</L3W>
<L3M>672,4</L3M>
<LY>734,8</LY>
</Cancelled>
<Failed>
<LW>4040</LW>
<L3W>368,0</L3W>
<L3M>351,8</L3M>
<LY>438,2</LY>
</Failed>
<TimedOut>
<LW>92</LW>
<L3W>180,7</L3W>
<L3M>153,5</L3M>
<LY>153,8</LY>
</TimedOut>
<NodeFailed>
<LW></LW>
<L3W>0,3</L3W>
<L3M>0,6</L3M>
<LY>0,7</LY>
</NodeFailed>
<JobsBySize_LW>>
<CPU1>1,2</CPU1>
<CPU8>26,4</CPU8>
<CPU16>6,9</CPU16>
<CPU32>6,0</CPU32>
<CPU64>6,6</CPU64>
<CPU128>49,9</CPU128>
<CPU256>1,8</CPU256>
<CPU512>1,2</CPU512>
<CPU1024>0,0</CPU1024>
<CPU2048>0,0</CPU2048>
</JobsBySize_LW>
<JobsBySizeWaitingTime_LW>>
<CPU1>0,0</CPU1>
<CPU8>0,0</CPU8>
<CPU16>3,0</CPU16>
<CPU32>38,0</CPU32>
<CPU64>3,0</CPU64>
<CPU128>0,0</CPU128>
<CPU256>0,0</CPU256>
<CPU512>0,0</CPU512>
<CPU1024>0,0</CPU1024>
<CPU2048>0,0</CPU2048>
</JobsBySizeWaitingTime_LW>
<JobsBySize_L3W>>
<CPU1>6,4</CPU1>
<CPU8>23,0</CPU8>
<CPU16>21,0</CPU16>
<CPU32>19,9</CPU32>
<CPU64>10,5</CPU64>
<CPU128>7,1</CPU128>
<CPU256>6,0</CPU256>
<CPU512>4,8</CPU512>
<CPU1024>1,3</CPU1024>
<CPU2048>0,0</CPU2048>
</JobsBySize_L3W>
<JobsBySizeWaitingTime_L3W>>
<CPU1>0,0</CPU1>
<CPU8>0,0</CPU8>
<CPU16>3,0</CPU16>
<CPU32>13,0</CPU32>
<CPU64>2,0</CPU64>
<CPU128>4,0</CPU128>
<CPU256>3,0</CPU256>
<CPU512>11,0</CPU512>
<CPU1024>21,0</CPU1024>
<CPU2048>0,0</CPU2048>
</JobsBySizeWaitingTime_L3W>
<JobsBySize_L3M>>
<CPU1>2,4</CPU1>
<CPU8>78,6</CPU8>
<CPU16>7,1</CPU16>
<CPU32>6,0</CPU32>
<CPU64>2,0</CPU64>
<CPU128>2,1</CPU128>
<CPU256>1,1</CPU256>
<CPU512>0,5</CPU512>
<CPU1024>0,1</CPU1024>
<CPU2048>0,0</CPU2048>
</JobsBySize_L3M>
<JobsBySizeWaitingTime_L3M>>
<CPU1>19,0</CPU1>
<CPU8>0,0</CPU8>
<CPU16>4,0</CPU16>
<CPU32>14,0</CPU32>
<CPU64>1,0</CPU64>
<CPU128>1,0</CPU128>
<CPU256>2,0</CPU256>
<CPU512>9,0</CPU512>
<CPU1024>20,0</CPU1024>
<CPU2048>0,0</CPU2048>
</JobsBySizeWaitingTime_L3M>
<JobsBySize_LY>>
<CPU1>8,8</CPU1>
<CPU8>49,9</CPU8>
<CPU16>17,1</CPU16>
<CPU32>9,2</CPU32>
<CPU64>7,6</CPU64>
<CPU128>3,2</CPU128>
<CPU256>2,8</CPU256>
<CPU512>1,3</CPU512>
<CPU1024>0,1</CPU1024>
<CPU2048>0,0</CPU2048>
</JobsBySize_LY>
<JobsBySizeWaitingTime_LY>>
<CPU1>8,0</CPU1>
<CPU8>1,0</CPU8>
<CPU16>6,0</CPU16>
<CPU32>10,0</CPU32>
<CPU64>3,0</CPU64>
<CPU128>2,0</CPU128>
<CPU256>1,0</CPU256>
<CPU512>6,0</CPU512>
<CPU1024>22,0</CPU1024>
<CPU2048>7,0</CPU2048>
</JobsBySizeWaitingTime_LY>
</JobsStats>
</article>
