Shell script analysis mysql slow query log (slowlog)
Percona pt-query-digest is used to analyze slow query logs. The analysis and statistics results are clear.
#! /Bin/shslowlog_path =/root/slow_query_logeveryslow =/tmp/everydayslow # need to download pt-query-digestpt_digest =/root/pt-query-digeststart_string = $ (grep 'date -- date = "0 days ago" + % y % m % d' $ {slowlog_path} | head-1) start_pos = $ (grep-n 'date -- date = "0 days ago" + % y % m % d' $ {slowlog_path} | head-1 | awk-F: '{print $1 }') end_pos = $ (grep-n 'date -- date = "0 days ago" + % y % m % d' $ {slowlog_path} | tail-1 | awk-F: '{print $1}') print_linecnt =$ (expr $ {end_pos}-$ {start_pos}) # If start_string is not empty, analyze the log if [-z "$ {start_string}"]; then exit 1 elsegrep-I "$ {start_string}"-A $ {print_linecnt }$ {slowlog_path }>$ {everyslow}/usr/bin/perl $ {pt_digest} $ {everyslow }>/tmp/anaslowlog _ 'date + % Y-% m-% d' fi