CODE EXAMPLE FOR SQL

shell script to log mysql cpu usage

# log a processed cpu usage every second
while [ 1 ]
do
    #change 25029 to process id to monitor
    top -b -n 2 -d 0.2 -p 25029 | tail -1 | awk '{print $9}'
    sleep 1
done