Counting your slow queries by seconds
I needed to check the performance of a database after some changes. This gets me some raw numbers on the performance of the slow queries log in MySQL: tail -n 10000 log-slow-queries.log|grep Query|awk ‘{print $3}’|awk -F . ‘{print $1}’|sort -n|uniq -c|awk ‘{print $2″ “$1}’ It outputs seconds taken, and number …