Essays-66 Articles-0 comments-MySQL slow query (ii)-Pt-query-digest detailed slow query log one, Introduction Pt-query-digest is a tool for analyzing MySQL slow query, it can analyze Binlog, Gene RAL Log, Slowlog, can also be analyzed via
1. Introduction to ToolsPt-query-digest is a tool for analyzing slow queries for MySQL, which analyzes Binlog, general log, Slowlog, It can also be analyzed using showprocesslist or MySQL protocol data crawled by tcpdump. The analysis results can be
1. Introduction to ToolsPt-query-digest is a tool for analyzing slow queries for MySQL, which analyzes Binlog, general log, Slowlog, It can also be analyzed using showprocesslist or MySQL protocol data crawled by tcpdump. The analysis results can be
1. Introduction to ToolsPt-query-digest is a tool for analyzing slow queries for MySQL, which analyzes Binlog, general log, Slowlog, It can also be analyzed using showprocesslist or MySQL protocol data crawled by tcpdump. The analysis results can be
First, IntroductionPt-query-digest is a tool for analyzing slow queries for MySQL, which analyzes Binlog, general log, Slowlog, It can also be analyzed using showprocesslist or MySQL protocol data crawled by tcpdump. The analysis results can be
First, IntroductionPt-query-digest is a tool for analyzing slow queries for MySQL, which analyzes Binlog, general log, Slowlog, It can also be analyzed using showprocesslist or MySQL protocol data crawled by tcpdump. The analysis results can be
Original http://blog.csdn.net/seteor/article/details/240179131.percona-toolkit Installationwget http://www.percona.com/redir/downloads/percona-toolkit/2.1.1/percona-toolkit-2.1.1-1.noarch.rpmwget
If you ' re just completely itching to start using the This tool, here's what you need:1, a MySQL database to store query analysis data in.2, Pt-query-digest. You could as well just get the whole Percona Toolkit when you ' re at it:)3, a slow query
MySQL Performance Profiling Tool (pt-query-digest) is also from percona-toolkit
Other tools in this tool set
Troubleshooting of abnormal shutdown of MySQL Slave (pt-slave-restart)
Including
1. slow log (default)
2. tcpdump
3. general log
4.
[Git Note] "error: 0D0890A1: asn1 encoding routines: ASN1_verify: unknown message digest algorithm" solution, messagedigest
Note:The premise described in this note is that git has been successfully installed on the machine and supports obtaining
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.