Shulou(Shulou.com)06/01 Report--

Today optimize Box Anemometer slow log import script, pt-query-digest has been stuck in Reading from STDIN... No movement, and another machine successfully executed. view help

pt-query-digest --help

pt-query-digest analyzes MySQL queries from slow, general, and binary log files.

It can also analyze queries from C and MySQL protocol data

from tcpdump. By default, queries are grouped by fingerprint and reported in

descending order of query time (i.e. the slowest queries first). If no C

are given, the tool reads C. The optional C is used for certain

options like L and L. For more details, please use the

--help option, or try 'perldoc /usr/local/percona-toolkit/bin/pt-query-digest'

for complete documentation.

This means that if there is no FILE given, wait for input, ls command verification is that the file does not exist, the reason is different from the file name of another machine, copy command to directly execute it must not work, change the file name to the slow log name of the machine can be executed

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.