MySQL must master the tools Pt-query-digest
Ancient Cloud: 工欲善其事, its prerequisite. As a good MySQL DBA also needs to have a few useful MySQL management tools, so I have been sorting and looking for some easy to manage MySQL tool. Over the next period of time, you will spend a large part of your energy searching for these tools.
Performance management has always been the first, and many of the DBA's work management are not able to see or measure value, but if a system slows down like a snail, DBAs can pull the system back from the edge of the crash to the high-speed rail era by monitoring the tuning. This value and touch should be huge. (Many business leaders think that the system will need to change faster CPU, larger memory, faster storage, and this is not a few, so the value of the DBA has not been reflected, the salary will not be very high)
MySQL log is the fastest and most direct way to track MySQL performance bottlenecks, the system can bottleneck, the first to open the slow query log, to track; this time about the management and review of slow query log has been organized two articles, Inadvertently found a tool to view the slow query log: mk-query-digest, the tool online is known as MySQL DBA must master the top ten tools.
1: Installation of Perl-related modules
Yum Install perl-dbiyum install perl-dbd-mysqlyum installperl-time-Hiresyum Install Perl- Io-socket-ssl
2: Download and install the Percona Toolkit package
http://pkgs.repoforge.org/perl-TermReadKey/(Key)
https://www.percona.com/downloads/percona-toolkit/(tool)
wget http://pkgs.repoforge.org/perl-termreadkey/perl-termreadkey-2.30-1.el3.rf.x86_64.rpmrpm- IVH perl-termreadkey-2.30-1. El3.rf.x86_64.rpmwget https:// www.percona.com/downloads/percona-toolkit/2.2.14/RPM/percona-toolkit-2.2.14-1.noarch.rpmRPM-IVH percona-toolkit-2.2. 1. noarch.rpm
Note: The Term::readkey package needs to be installed, otherwise it will be reported to Perl (Term::readkey) is needed by Percona-toolkit-2.2.14-1.noarch
Introduction and installation of the Percona-toolkit series
MySQL must master the tool Pt-query-digest installation