/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

2 votes135 views1 answer
Plsql left() function
SQL
4 votes162 views2 answers
Dbms output
SQL
14 votes131 views2 answers
How to auto increment in sql
SQL
0 vote140 views1 answer
Mysql date time string format python
SQL
0 vote153 views1 answer
How to insert same table data using mysql query
SQL
8 votes149 views1 answer
Oracle search text in all packages
SQL
2 votes135 views1 answer
Possgress drop if exists table
SQL
0 vote145 views1 answer
Add timestamp column to existing table t-sql
SQL
0 vote146 views1 answer
Mysql update set sum
SQL
6 votes130 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL