Changes

From SME Server
Jump to navigationJump to search
289 bytes added ,  22:18, 26 November 2015
no edit summary
Line 23: Line 23:  
  LOG=outlog.txt
 
  LOG=outlog.txt
 
  OUTPUT=$(ps -ylC httpd | awk '{x += $8;y += 1} END {print "Apache Memory Usage (MB): "x/1024; print ":Average Proccess Size (MB): "x/((y-1)*1024)}' && echo -n ':Apache Processes: ' && ps -C httpd --no-headers | wc -l  )
 
  OUTPUT=$(ps -ylC httpd | awk '{x += $8;y += 1} END {print "Apache Memory Usage (MB): "x/1024; print ":Average Proccess Size (MB): "x/((y-1)*1024)}' && echo -n ':Apache Processes: ' && ps -C httpd --no-headers | wc -l  )
 +
DAY=$(date +"%F"+"%T")
 +
now=$(date +'%Y-%m-%d %H:%M:%S')
 +
 +
echo $OUTPUT \'$DAY\' | awk  '{print "INSERT INTO performance (mem_used, process_size, processors_used,period) VALUES  ( "$5", "$10", "$13", "$14" );"}' | mysql --user=username --password=password database_name
 +
sleep 120
 +
done
80

edits

Navigation menu