#!/bin/bash

RED='\033[0;31m'
BLUE='\033[0;34m'
NC='\033[0m'


echo -e "${BLUE}Showing top 20 processes consuming most rss${NC}\n"
ps -eo pid,ppid,cmd,%mem,rss --sort=-rss | head -n 20 | awk '{printf "%-6s %-6s %-30s %-5s %d MB\n", $1, $2, $3, $4, $5/1024}'

echo -e "\n\n${RED}Showing MySQL usage${NC}\n"
ps aux | grep mysql | awk '{sum+=$6}{avail+=$5} END {print "Total mysql Memory Usage: " sum/1024 " MB out of: "avail/1024 " MB" }'