Shell script analyzes mysql slow query log (slow log) and mysqlslow

Shell script analyzes mysql slow query log (slow log) and mysqlslow

Percona pt-query-digest is used to analyze slow query logs. The analysis and statistics results are clear.

#! /Bin/sh

Slowlog_path =/root/slow_query_log
Everyslow =/tmp/everydayslow
# Download pt-query-digest
Pt_digest =/root/pt-query-digest

Start_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 })

# Analyze logs if start_string is not empty
If [-z "$ {start_string}"];
Then exit 1
Else
Grep-I "$ {start_string}"-A $ {print_linecnt }$ {slowlog_path }>$ {everyslow}
/Usr/bin/perl $ {pt_digest }$ {everyslow}>/tmp/anaslowlog _ 'date + % Y-% m-% d'
Fi

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.