分析软件
The second technique is capturing TCP network traffic and inspecting it, then decoding
the MySQL client/server protocol. You can use tcpdump to save the traffic to disk, then use pt-query-digest with the--type=tpcdump
option to decode and analyze the queries.
Generating a profile from the slow query log requires a good log analysis tool. We suggest pt-query-digest, which is arguably the most powerful tool available for MySQL query log analysis. It supports a large variety of functionality, including the ability to save query reports to a database and track changes in workload over time.