Get the App
SLTechnology News&Howtos  ›  Database  › 

Pt-query-digest Reading from STDIN... problem

Shulou Source: shulou.com Published: 2022-06-01 10:33:28 10月03日 Update

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

Tags: File command filename log machine no success reason name meaning copy script C.Coe L.dint i.e. native help affirmation input verification Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Docker MariaDB Microsoft NVidia Xiaomi