{"id":414,"date":"2011-01-28T00:30:38","date_gmt":"2011-11-06T21:51:50","guid":{"rendered":"http:\/\/kraftek.com\/blog\/stats-script-based-on-top-for-linux\/"},"modified":"2011-01-28T00:30:38","modified_gmt":"2011-11-06T21:51:50","slug":"stats-script-based-on-top-for-linux","status":"publish","type":"post","link":"\/blog\/index.php\/stats-script-based-on-top-for-linux\/","title":{"rendered":"Stats script based on top for Linux"},"content":{"rendered":"<p>The capture script is:<br \/>\n(date &#8220;+%d %m %H %M %S %Y&#8221;<br \/>\ntop -b -n 1 | head -5) &gt;&gt; \/var\/log\/top. log<br \/>\nThe script that generates the csv is:<br \/>\necho &#8220;date,time,loadavg1,loadavg5,loadavg10,processes,sleeping processes,on cpu,cpu idle,cpu user,cpu<br \/>\nkernel,cpu iowait,swap,swap used,swap free,swap cached,mem,mem used,mem free,mem buffers&#8221;<br \/>\ncat \/var\/log\/top.log | gawk &#8216;ORS=NR%6?&#8221; &#8220;:&#8221;n&#8221;&#8216; | while read l;do<br \/>\ndate=`echo $l | awk &#8216;{ print $1&#8243;\/&#8221;$2&#8243;\/&#8221;$6&#8243;,&#8221;$3&#8243;:&#8221;$4&#8221;:&#8221;$5 }&#8217;`<br \/>\nload=`echo $l | awk &#8216;{s=substr($0,index($0,&#8221;average: &#8220;)+9);print substr(s,1,index (s,&#8221;Tasks&#8221;)-1)}&#8217; | sed &#8216;s\/,\/<br \/>\n\/g&#8217;`<br \/>\npt=`echo $l | awk &#8216;{s=substr($0,index($0,&#8221;Tasks:&#8221;) +7);print substr(s,1,index (s,&#8221; &#8220;)-1)}&#8217;`<br \/>\nps=`echo $l | awk &#8216;{s=substr($0,index($0,&#8221;sleeping&#8221;)-4);print substr(s,1,index (s,&#8221; &#8220;)-1)}&#8217;`<br \/>\npr=`echo $l | awk &#8216;{s=substr($0,index($0,&#8221;running&#8221;)-3);print substr(s,1,index (s,&#8221;running&#8221;)-1) }&#8217;`<br \/>\ncid=`echo $l | awk &#8216;{s=substr($0,index($0,&#8221;id,&#8221;)-5) ;print substr(s,1,index (s,&#8221;,&#8221;)-1)}&#8217;|tr -d &#8216;[:alpha:]&#8217;`<br \/>\ncus=`echo $l | awk &#8216;{s=substr($0,index($0,&#8221;us,&#8221;)-5) ;print substr(s,1,index (s,&#8221;,&#8221;)-1)}&#8217;|tr -d &#8216;[:alpha:]&#8217;`<br \/>\nck=`echo $l | awk &#8216;{s=substr($0,index($0,&#8221;sy,&#8221;)-5) ;print substr(s,1,index (s,&#8221;,&#8221;)-1)}&#8217;|tr -d &#8216;[:alpha:]&#8217;`<br \/>\ncio=`echo $l | awk &#8216;{s=substr($0,index($0,&#8221;wa,&#8221;)-5) ;print substr(s,1,index (s,&#8221;,&#8221;)-1)}&#8217;|tr -d &#8216;[:alpha:]&#8217;`<br \/>\nswap=`echo $l | awk &#8216;{s=substr($0,index($0,&#8221;Swap:&#8221;)+5);print substr(s,1,index (s,&#8221;cached&#8221;)-1)}&#8217;|tr -d<br \/>\n&#8216;[:alpha:]&#8217; | sed &#8216;s\/,\/ \/g&#8217;`<br \/>\nmem=`echo $l | awk &#8216;{s=substr($0,index($0,&#8221;Mem:&#8221;)+4);print substr(s,1,index (s,&#8221;buffers&#8221;)-1) }&#8217;|tr -d &#8216;[:alpha:]&#8217;<br \/>\n| sed &#8216;s\/,\/ \/g&#8217;`<br \/>\necho &#8220;${date} ${load} ${pt} ${ps} ${pr} ${cid} ${cus} ${ck} ${cio} ${swap} ${mem}&#8221; | sed &#8216;s\/[ t]*$\/\/&#8217;| tr -s &#8216; &#8216;| sed<br \/>\n&#8216;s\/ \/,\/g&#8217;<br \/>\ndone<br \/>\n6\/433<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The capture script is: (date &#8220;+%d %m %H %M %S %Y&#8221; top -b -n 1 | head -5) &gt;&gt; \/var\/log\/top. log The script that generates the csv is: echo &#8220;date,time,loadavg1,loadavg5,loadavg10,processes,sleeping processes,on cpu,cpu idle,cpu user,cpu kernel,cpu iowait,swap,swap used,swap free,swap cached,mem,mem used,mem free,mem buffers&#8221; cat \/var\/log\/top.log | gawk &#8216;ORS=NR%6?&#8221; &#8220;:&#8221;n&#8221;&#8216; | while read l;do date=`echo $l | [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-414","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"\/blog\/index.php\/wp-json\/wp\/v2\/posts\/414","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=414"}],"version-history":[{"count":0,"href":"\/blog\/index.php\/wp-json\/wp\/v2\/posts\/414\/revisions"}],"wp:attachment":[{"href":"\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=414"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=414"},{"taxonomy":"post_tag","embeddable":true,"href":"\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}