[High.Performance.MySQL(3rd,2012.3)].Baron.Schwartz.之分析工具的使用

分析软件

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.