Ministat - Revision history

Smsldoo at 11:41, 9 August 2014

2014-08-09T11:41:54Z

2012-02-17T17:41:30Z

2012-01-13T14:17:03Z

‎Script: Added service call to httpd request instead of trying to call the program directly.

2012-01-13T14:16:03Z

‎Usage

2012-01-13T14:12:02Z

‎Usage

2011-06-01T13:23:23Z

‎Usage

2011-05-20T16:30:52Z

‎Script

2011-05-20T15:40:26Z

‎Script

2011-05-18T13:30:01Z

‎Script

2011-05-18T13:00:08Z

‎Script

@@ Line 11: / Line 11: @@
 ==Script==
-<code>[bash,n]
+<source lang='bash'>
 #!/bin/bash
 function checkmysql {
@@ Line 75: / Line 75: @@
 	echo "$cmdapache" | head -$aline
 fi
-</code>
+</source>
 ==Usage==

← Older revision		Revision as of 17:41, 17 February 2012
Line 1:		Line 1:
		+	[[Category:Scripts]]
	==Overview==		==Overview==
	Down and dirty mini status viewer. Makes it easy to monitor several different sections of a server at the same time.		Down and dirty mini status viewer. Makes it easy to monitor several different sections of a server at the same time.

@@ Line 13: / Line 13: @@
 #!/bin/bash
 function checkmysql {
-	cmdmysql=`mysql --batch -e 'show processlist;' | grep -v "Id" | cut -f6,5,4,8 | sed -e 's/\t/ /g' | sort -nr --key=3 | sed -e 's/ /\|/' -e 's/ /\|/' -e 's/ /\|/' | awk 'BEGIN {FS="|"}; { printf "%-4s%-18s%-8s%-30s",$3,$1,$2,$4; print "" }'`
+	cmdmysql=`mysql --batch -e 'show processlist;' | grep -v "Id" | cut -f6,5,4,8 | sed -e 's/\t/ /g' | sort -nr --key=3 | sed -e 's/ /\|/' -e 's/ /\|/' -e 's/ /\|/' | awk -v termwidth="$termwidth" 'BEGIN {FS="|"}; {termwidth=termwidth - 39; query=$4; query=substr("'"${query}"'",1,termwidth) }; { printf "%-3s%-17s%7-s%-" termwidth "s%-1s",$3,$1,$2,$4,query; print ""; }' | sed '/^$/d' `
 	if [[ $cmdmysql != "" ]]
 	then
@@ Line 25: / Line 25: @@
 	if [ -d "/var/cpanel" ]
 	then
-		cmdapache=`httpd status 2>&1 | sed -n '/requests\/sec/,/Scoreboard/p' | sed 'N;$!P;$!D;$d' | grep "requests/sec" -A 999`
+		cmdapache=`service httpd status 2>&1 | sed -n '/requests\/sec/,/Scoreboard/p' | sed 'N;$!P;$!D;$d' | grep "requests/sec" -A 999`
 	else
 		cmdapache=`lynx --dump http://localhost/server-status 2>&1 | sed -n '/requests\/sec/,/Scoreboard/p' | sed 'N;$!P;$!D;$d' | grep "requests/sec" -A 999`
@@ Line 51: / Line 51: @@
+}
 cat /proc/loadavg
 addseperator

@@ Line 83: / Line 83: @@
 Direct download and execution of script (auto mode) from this server:
-<code>[bash,n]wget http://wiki.jamesdooley.us/scripts/ministat -O ministat; watch sh ministat; rm -f ministat</code>
+<code>[bash,n]wget http://svn.jamesdooley.us/svn/JDooley/Ministat/ministat.sh -O ministat; watch sh ministat; rm -f ministat</code>
 ==What to change==

@@ Line 79: / Line 79: @@
 Direct download and execution of script (auto mode) from ent.int server:
-<code>[bash,n]wget http://scripts.ent.liquidweb.com/ministat -O ministat; watch -n 10 sh ministat; rm -f ministat</code>
+<code>[bash,n]wget http://scripts.ent.liquidweb.com/ministat -O ministat; watch sh ministat; rm -f ministat</code>
 Direct download and execution of script (auto mode) from this server:
-<code>[bash,n]wget http://wiki.jamesdooley.us/scripts/ministat -O ministat; watch -n 10 sh ministat; rm -f ministat</code>
+<code>[bash,n]wget http://wiki.jamesdooley.us/scripts/ministat -O ministat; watch sh ministat; rm -f ministat</code>
 ==What to change==

@@ Line 13: / Line 13: @@
 #!/bin/bash
 function checkmysql {
-	cmdmysql=`mysqladmin proc stat 2>&1 | grep "|" | grep -v "Id" | awk 'BEGIN{FS="|"};{print $7,$6,$9}' | sort -n`
+	cmdmysql=`mysql --batch -e 'show processlist;' | grep -v "Id" | cut -f6,5,4,8 | sed -e 's/\t/ /g' | sort -nr --key=3 | sed -e 's/ /\|/' -e 's/ /\|/' -e 's/ /\|/' -e 's/ /\|/' | awk 'BEGIN {FS="|"}; { printf "%-4s%-15s%-8s%-30s",$3,$1,$2,$4; print "" }'`
-	wcmysql=`echo $cmdmysql | wc -l`
+	if [[ $cmdmysql != "" ]]
 	return
+}
@@ Line 20: / Line 25: @@
 	if [ -d "/var/cpanel" ]
 	then
-		httpd status 2>&1 | sed -n '/requests\/sec/,/Scoreboard/p' | sed 'N;$!P;$!D;$d' | grep "requests/sec" -A $aline
+		cmdapache=`httpd status 2>&1 | sed -n '/requests\/sec/,/Scoreboard/p' | sed 'N;$!P;$!D;$d' | grep "requests/sec" -A 999`
 	else
-		lynx --dump http://localhost/server-status 2>&1 | sed -n '/requests\/sec/,/Scoreboard/p' | sed 'N;$!P;$!D;$d' | grep "requests/sec" -A $aline
+		wcapache=0
 	fi
 	return
@@ Line 44: / Line 55: @@
 checkmysql
 calclines
@@ Line 50: / Line 62: @@
 free | grep -v "cache:"
 </code>

@@ Line 18: / Line 18: @@
+}
 function checkapache {
-	httpd status 2>&1 | grep "requests/sec" -A6
+	if [ -d "/var/cpanel" ]
 	return
+}
 function calclines {
-	nline=`tput lines | awk '{print int(($1 - 18) / 2)}'`
+	nline=`tput lines | awk '{print int(($1 - 14) / 3)}'`
 	if [ $nline -gt $wcmysql ]
 	then
@@ Line 49: / Line 55: @@
 addseperator
-httpd status 2>&1 | grep "requests/sec" -A6
+checkapache
 </code>