/SQL/Shell script to log mysql cpu usage

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

Similar codes

0 vote208 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote214 views1 answer
Sql remove last 2 digit
SQL
0 vote204 views2 answers
How to generate a unique random number in mysql
SQL
8 votes217 views1 answer
Oracle add datafile to tablespace
SQL
0 vote244 views1 answer
Get last inserted primary key
SQL
0 vote215 views3 answers
How to assign custom id in mysql
SQL
1 vote204 views1 answer
Oracle check table space
SQL
0 vote220 views1 answer
How to alter length character varying postgres
SQL
0 vote215 views1 answer
MySQL INSERT IGNORE Statement
SQL
24 votes198 views4 answers
Mssql get all table names
SQL