<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
p.ParagraphStyle, li.ParagraphStyle, div.ParagraphStyle
{mso-style-name:"Paragraph Style";
margin:0cm;
margin-bottom:.0001pt;
text-autospace:none;
font-size:12.0pt;
font-family:"Verdana","sans-serif";
mso-fareast-language:EN-US;}
span.FontStyle
{mso-style-name:"Font Style";
mso-style-priority:99;
font-family:"Verdana","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="FR" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">Hi guys,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">I would like to know how to fetch, via a command line, the information about the max CPU usage of a chosen server for a chosen time period from its *.rrd files.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">More precisely, I would like to fetch the information from the "vm_cpu" section of the "/soft/xymon/current/server/etc/graphs.cfg" file:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><i><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">[vm_cpu]<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:12.0pt;font-family:"Arial","sans-serif""> TITLE VMX: vCPU usage<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:12.0pt;font-family:"Arial","sans-serif""> YAXIS MHz Used<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:12.0pt;font-family:"Arial","sans-serif""> DEF:cpuuse=vm_cpu,cpuuse.rrd:lambda:AVERAGE<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:12.0pt;font-family:"Arial","sans-serif""> DEF:vcpurunning=vm_cpu,vcpurunning.rrd:lambda:AVERAGE<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:12.0pt;font-family:"Arial","sans-serif""> AREA:cpuuse#00CC00:VM CPU usage<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:12.0pt;font-family:"Arial","sans-serif""> LINE1:vcpurunning#000000:# of vCPUs running<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:12.0pt;font-family:"Arial","sans-serif""> COMMENT:\n<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:12.0pt;font-family:"Arial","sans-serif""> GPRINT:cpuuse:LAST:VM CPU usage \: %5.0lf (cur)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">
<b>GPRINT:cpuuse:MAX: \: %5.0lf (max) <======================== HERE<o:p></o:p></b></span></i></p>
<p class="MsoNormal"><i><span style="font-size:12.0pt;font-family:"Arial","sans-serif""> GPRINT:cpuuse:MIN: \: %5.0lf (min)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:12.0pt;font-family:"Arial","sans-serif""> GPRINT:cpuuse:AVERAGE: \: %5.0lf (avg)\n<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:12.0pt;font-family:"Arial","sans-serif""> GPRINT:vcpurunning:LAST:#vCPUs running\: %5.0lf (cur)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">
<b>GPRINT:vcpurunning:MAX: \: %5.0lf (max) <======================== HERE<o:p></o:p></b></span></i></p>
<p class="MsoNormal"><i><span style="font-size:12.0pt;font-family:"Arial","sans-serif""> GPRINT:vcpurunning:MIN: \: %5.0lf (min)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:12.0pt;font-family:"Arial","sans-serif""> GPRINT:vcpurunning:AVERAGE: \: %5.1lf (avg)\n<o:p></o:p></span></i></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">so :<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><i><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">=> GPRINT:cpuuse:MAX: \: %5.0lf (max)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">=> GPRINT:vcpurunning:MAX: \: %5.0lf (max)<o:p></o:p></span></i></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">I was having fun with the "rrdtool fetch …", but the result is not so comprehensible for me… I have found a topic "Top ten list of servers wrt cpu load" on Your mailing list,
but it doesnt solve my problem.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">What I tried is:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><b><span lang="X-NONE" style="font-family:"Arial","sans-serif"">rrdtool fetch vm_cpu.rrd AVERAGE --start 1378040857 --end 1378213657 | awk '{print $3}' |sort</span></b></span><span class="FontStyle"><b><span style="font-family:"Arial","sans-serif""><o:p></o:p></span></b></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><b><span style="font-family:"Arial","sans-serif""><o:p> </o:p></span></b></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><span style="font-family:"Arial","sans-serif"">Few questions here:<o:p></o:p></span></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><span style="font-family:"Arial","sans-serif""><o:p> </o:p></span></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><span style="font-family:"Arial","sans-serif"">1.) Should I use the
</span></span><span class="FontStyle"><b><span lang="X-NONE" style="font-family:"Arial","sans-serif"">vm_cpu.rrd</span></b></span><span class="FontStyle"><b><span lang="X-NONE" style="font-family:"Arial","sans-serif"">
</span></b></span><span class="FontStyle"><span style="font-family:"Arial","sans-serif"">file? Or<b> vm_cpu,cpuuse.rrd</b> or
<b>vm_cpu,vcpurunning.rrd</b>?<o:p></o:p></span></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><span style="font-family:"Arial","sans-serif""><o:p> </o:p></span></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><span style="font-family:"Arial","sans-serif"">Here are the files present on the server:<o:p></o:p></span></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><b><span style="font-family:"Arial","sans-serif""><o:p> </o:p></span></b></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><span style="font-family:"Arial","sans-serif"">[root@vt2043]# ls -l | grep -i cpu<o:p></o:p></span></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><span style="font-family:"Arial","sans-serif"">-rw-r--r-- 1 xymon xymon 19640 Apr 18 13:43 vm_cpu,cpuuse.rrd<o:p></o:p></span></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><span style="font-family:"Arial","sans-serif"">-rw-r--r-- 1 xymon xymon 38624 Sep 3 18:32 vm_cpu.rrd<o:p></o:p></span></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><span style="font-family:"Arial","sans-serif"">-rw-r--r-- 1 xymon xymon 19640 Apr 18 13:43 vm_cpu,vcpurunning.rrd<o:p></o:p></span></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><span style="font-family:"Arial","sans-serif""><o:p> </o:p></span></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><span style="font-family:"Arial","sans-serif"">2.) How to understand the result ? There is a lot of numbers like:<o:p></o:p></span></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><span style="font-family:"Arial","sans-serif""><o:p> </o:p></span></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><span style="font-family:"Arial","sans-serif"">-8.1787151835e-04<o:p></o:p></span></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><span style="font-family:"Arial","sans-serif"">-8.3830185734e-03<o:p></o:p></span></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><span style="font-family:"Arial","sans-serif"">8.4392892148e-03<o:p></o:p></span></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><span style="font-family:"Arial","sans-serif"">8.5398628456e-03<o:p></o:p></span></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><span style="font-family:"Arial","sans-serif"">9.1766240439e-04<o:p></o:p></span></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><span style="font-family:"Arial","sans-serif"">-9.6038714038e-03<o:p></o:p></span></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><span style="font-family:"Arial","sans-serif"">9.9081238031e-04<o:p></o:p></span></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><span style="font-family:"Arial","sans-serif"">-9.9143698154e-04<o:p></o:p></span></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><b><span style="font-family:"Arial","sans-serif""><o:p> </o:p></span></b></span></p>
<p class="ParagraphStyle"><span class="FontStyle"><span style="font-family:"Arial","sans-serif"">3.) Is it a good way of fetching the max cpu usage value from the server ?<o:p></o:p></span></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">Thanks for Your help in advance.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif";mso-fareast-language:FR">Je reste à votre disposition pour tout complément d'informations. Cordialement.<br>
Regards / Z poważaniem / تحية خالصة / </span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:FR">敬礼</span><span style="font-size:12.0pt;font-family:"Arial","sans-serif";mso-fareast-language:FR"><br>
<br>
Michal Rozek<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
</div>
<p><br>
Ce message (et toutes ses pieces jointes eventuelles) est confidentiel et etabli a l'intention exclusive de ses destinataires.<br>
Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est<br>
interdite, sauf autorisation expresse.<br>
L'internet ne permettant pas d'assurer l'integrite de ce message, CNP Assurances et ses filiales declinent toute responsabilite<br>
au titre de ce message, s'il a ete altere, deforme ou falsifie.</p>
<p>*****</p>
<p>This message and any attachments (the "message") are confidential and intended solely for the addressees.<br>
Any unauthorised use or dissemination is prohibited.<br>
E-mails are susceptible to alteration.<br>
Neither CNP Assurances nor any of its subsidiaries or affiliates shall be liable for the message if altered, changed or falsified.</p></body>
</html>