Shulou(Shulou.com)05/31 Report--

This article mainly explains "slow log analysis of the execution time of a query in mysql". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "mysql slow log analysis of a query execution point in time" it!

Slow log analysis of the point in time when a query is executed

# Statistics slow log

$> tail-80000 / usr/local/mysql/data/log-slow-queries.log > / tmp/1

$> mysqldumpslow-s at-t 10 / tmp/1

Www.2cto.com

# doubt a query and want to get the specific time of the query

$> tail-80000 / usr/local/mysql/data/log-slow-queries.log | grep-B3 "select count (\ *) from group_members" | grep-I 'set timestamp' | awk-F =' {print $2}'| sed-e's sed / e's / ^ / @ /'> / tmp/2

$> date-f / tmp/2

At this point, I believe you have a deeper understanding of the "slow log analysis of a query execution point in mysql". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.