Percona-Toolkit命令集合工具，Mysql不可或缺的必备利器之一

最新推荐文章于 2024-06-04 07:30:23 发布
最新推荐文章于 2024-06-04 07:30:23 发布
阅读量2k 收藏
点赞数
分类专栏： Mysql-工具
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/songxixi/article/details/8746088
版权

Percona Toolkit for MySQL is a collection of advanced command-line tools used by Percona MySQL support staff to perform a variety of MySQL server and system tasks that are too difficult or complex to perform manually, including:

1.对主从复制数据的一致性校验；

2.有效的对相关的行数据进行归档操作；

3.查到相关的重复的索引；

4.归总大批量Mysql服务的维护运维工作；

5.问题发生时收集重要的系统信息；

官网项目地址；

http://www.percona.com/software/percona-toolkit/ 

相关配置如下：

[root@Slave02 local]# wget percona.com/get/percona-toolkit.tar.gz
--2013-04-01 13:20:06--  http://percona.com/get/percona-toolkit.tar.gz
Resolving percona.com... 74.121.199.234
Connecting to percona.com|74.121.199.234|:80... connected.
HTTP request sent, awaiting response... 302 Found
Location: http://www.percona.com/get/percona-toolkit.tar.gz [following]
--2013-04-01 13:20:07--  http://www.percona.com/get/percona-toolkit.tar.gz
Resolving www.percona.com... 74.121.199.234
Reusing existing connection to percona.com:80.
HTTP request sent, awaiting response... 302 Found
Location: http://www.percona.com/downloads/percona-toolkit/2.2.1/percona-toolkit-2.2.1.tar.gz [following]
--2013-04-01 13:20:08--  http://www.percona.com/downloads/percona-toolkit/2.2.1/percona-toolkit-2.2.1.tar.gz
Reusing existing connection to percona.com:80.
HTTP request sent, awaiting response... 200 OK
Length: 1343968 (1.3M) [application/x-gzip]
Saving to: `percona-toolkit-2.2.1.tar.gz'

100%[======================================>] 1,343,968   26.9K/s   in 76s     

2013-04-01 13:21:24 (17.3 KB/s) - `percona-toolkit-2.2.1.tar.gz' saved [1343968/1343968]

[root@Slave02 local]# ls
bin                   mysql
cmake-2.8.5           mysqlsla-2.03
doc                   mysqlsla-2.03.tar.gz
etc                   percona-toolkit-2.2.1.tar.gz
games                 puppetlabs-release-6-1.noarch.rpm
include               sbin
innotop-1.8.1         share
innotop-1.8.1.tar.gz  software
lib                   src
libexec               xtrabackup-1.6.2
man                   xtrabackup-1.6.2.tar.gz
[root@Slave02 local]#

然后进行相关的perl配置包文件，如下：

进入cpan对其进行安装
#perl -MCPAN -e shell
cpan>install DBI
cpan>install DBD::mysql
cpan>install CGI

cpan[3]> install CGI                                                            
Running install for module 'CGI'
Running make for M/MA/MARKSTOS/CGI.pm-3.63.tar.gz
Fetching with LWP:
http://mirrors.sohu.com/CPAN/authors/id/M/MA/MARKSTOS/CGI.pm-3.63.tar.gz
Fetching with LWP:
http://mirrors.sohu.com/CPAN/authors/id/M/MA/MARKSTOS/CHECKSUMS
Checksum for /root/.cpan/sources/authors/id/M/MA/MARKSTOS/CGI.pm-3.63.tar.gz ok

  CPAN.pm: Building M/MA/MARKSTOS/CGI.pm-3.63.tar.gz

Checking if your kit is complete...
Looks good
Warning: prerequisite FCGI 0.67 not found.
Writing Makefile for CGI
Writing MYMETA.yml and MYMETA.json
---- Unsatisfied dependencies detected during ----
----        MARKSTOS/CGI.pm-3.63.tar.gz       ----
    FCGI [requires]
Shall I follow them and prepend them to the queue
of modules we are processing right now? [yes] yes
Running make test
  Delayed until after prerequisites
Running make install
  Delayed until after prerequisites
Running install for module 'FCGI'
Running make for F/FL/FLORA/FCGI-0.74.tar.gz
Fetching with LWP:
http://mirrors.sohu.com/CPAN/authors/id/F/FL/FLORA/FCGI-0.74.tar.gz
Fetching with LWP:
http://mirrors.sohu.com/CPAN/authors/id/F/FL/FLORA/CHECKSUMS
Checksum for /root/.cpan/sources/authors/id/F/FL/FLORA/FCGI-0.74.tar.gz ok

  CPAN.pm: Building F/FL/FLORA/FCGI-0.74.tar.gz

Checking if your kit is complete...
Looks good
Writing Makefile for FCGI
Writing MYMETA.yml and MYMETA.json
Running ./configure for you
Please read configure.readme for information on how to run it yourself
checking for gcc... gcc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables... 
checking whether we are cross compiling... no
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking how to run the C preprocessor... gcc -E
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking for ssize_t... yes
checking for sun_len in sys/un.h... no
checking for fpos_t in stdio.h... yes
checking sys/socket.h usability... yes
checking sys/socket.h presence... yes
checking for sys/socket.h... yes
checking netdb.h usability... yes
checking netdb.h presence... yes
checking for netdb.h... yes
checking netinet/in.h usability... yes
checking netinet/in.h presence... yes
checking for netinet/in.h... yes
checking arpa/inet.h usability... yes
checking arpa/inet.h presence... yes
checking for arpa/inet.h... yes
checking sys/time.h usability... yes
checking sys/time.h presence... yes
checking for sys/time.h... yes
checking limits.h usability... yes
checking limits.h presence... yes
checking for limits.h... yes
checking sys/param.h usability... yes
checking sys/param.h presence... yes
checking for sys/param.h... yes
checking for unistd.h... (cached) yes
checking for a fileno() prototype in stdio.h... yes
checking whether cross-process locking is required by accept()... no
checking whether va_arg(arg, long double) crashes the compiler... no
checking for an ANSI C-conforming const... yes
configure: creating ./config.status
config.status: creating fcgi_config.h
/usr/bin/perl FCGI.PL FCGI.pm
Generating FCGI.pm
cp FCGI.pm blib/arch/FCGI.pm
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" FCGI.XL FCGI.xs
Generating FCGI.xs for Perl version 5.008008
/usr/bin/perl /usr/lib/perl5/5.8.8/ExtUtils/xsubpp  -typemap /usr/lib/perl5/5.8.8/ExtUtils/typemap -typemap typemap FCGI.xs > FCGI.xsc && mv FCGI.xsc FCGI.c
gcc -c  -I. -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables   -DVERSION=\"0.74\" -DXS_VERSION=\"0.74\" -fPIC "-I/usr/lib/perl5/5.8.8/i386-linux-thread-multi/CORE"   FCGI.c
FCGI.xs: In function 釬CGI_Finish?
FCGI.xs:187: warning: suggest parentheses around assignment used as truth value
FCGI.c: In function 釾S_FCGI__Stream_WRITE?
FCGI.c:674: warning: unused variable 鈚arg?
FCGI.c:673: warning: unused variable 釸ETVAL?
FCGI.c: In function 釾S_FCGI__Stream_GETC?
FCGI.c:775: warning: unused variable 釸ETVAL?
gcc -c  -I. -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables   -DVERSION=\"0.74\" -DXS_VERSION=\"0.74\" -fPIC "-I/usr/lib/perl5/5.8.8/i386-linux-thread-multi/CORE"   fcgiapp.c
gcc -c  -I. -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables   -DVERSION=\"0.74\" -DXS_VERSION=\"0.74\" -fPIC "-I/usr/lib/perl5/5.8.8/i386-linux-thread-multi/CORE"   os_unix.c
os_unix.c: In function 釵S_Accept?
os_unix.c:1169: warning: pointer targets in passing argument 3 of 鈇ccept?differ in signedness
os_unix.c: In function 釵S_IsFcgi?
os_unix.c:1269: warning: pointer targets in passing argument 3 of 鈍etpeername?differ in signedness
Running Mkbootstrap for FCGI ()
chmod 644 FCGI.bs
rm -f blib/arch/auto/FCGI/FCGI.so
gcc  -shared -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables -L/usr/local/lib FCGI.o fcgiapp.o os_unix.o  -o blib/arch/auto/FCGI/FCGI.so       \
                \
          
chmod 755 blib/arch/auto/FCGI/FCGI.so
cp FCGI.bs blib/arch/auto/FCGI/FCGI.bs
chmod 644 blib/arch/auto/FCGI/FCGI.bs
Manifying blib/man3/FCGI.3pm
FCGI.pm:306: Unknown command paragraph "=HEAD1 LIMITATIONS"
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" echo.PL echo.fpl
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" remote.PL remote.fpl
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" threaded.PL threaded.fpl
  FLORA/FCGI-0.74.tar.gz
  /usr/bin/make -- OK
Running make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-Iblib/lib" "-Iblib/arch" test.pl
1..1
# Running under perl version 5.008008 for linux
# Current time local: Mon Apr  1 13:40:50 2013
# Current time GMT:   Mon Apr  1 05:40:50 2013
# Using Test.pm version 1.25
ok 1
  FLORA/FCGI-0.74.tar.gz
  /usr/bin/make test -- OK
Running make install
Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Installing /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/FCGI.pm
Installing /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/FCGI/FCGI.bs
Installing /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/FCGI/FCGI.so
Installing /usr/share/man/man3/FCGI.3pm
Appending installation info to /usr/lib/perl5/5.8.8/i386-linux-thread-multi/perllocal.pod
  FLORA/FCGI-0.74.tar.gz
  /usr/bin/make install  -- OK
Running make for M/MA/MARKSTOS/CGI.pm-3.63.tar.gz
  Has already been unwrapped into directory /root/.cpan/build/CGI.pm-3.63-dl05L8

  CPAN.pm: Building M/MA/MARKSTOS/CGI.pm-3.63.tar.gz

cp lib/CGI/Switch.pm blib/lib/CGI/Switch.pm
cp lib/CGI/Cookie.pm blib/lib/CGI/Cookie.pm
cp lib/CGI/Pretty.pm blib/lib/CGI/Pretty.pm
cp lib/CGI.pm blib/lib/CGI.pm
cp lib/CGI/Carp.pm blib/lib/CGI/Carp.pm
cp lib/CGI/Apache.pm blib/lib/CGI/Apache.pm
cp lib/CGI/Util.pm blib/lib/CGI/Util.pm
cp lib/CGI/Push.pm blib/lib/CGI/Push.pm
cp lib/CGI/Fast.pm blib/lib/CGI/Fast.pm
Manifying blib/man3/CGI::Switch.3pm
Manifying blib/man3/CGI::Cookie.3pm
Manifying blib/man3/CGI::Pretty.3pm
Manifying blib/man3/CGI.3pm
Manifying blib/man3/CGI::Carp.3pm
Manifying blib/man3/CGI::Apache.3pm
Manifying blib/man3/CGI::Util.3pm
Manifying blib/man3/CGI::Push.3pm
Manifying blib/man3/CGI::Fast.3pm
  MARKSTOS/CGI.pm-3.63.tar.gz
  /usr/bin/make -- OK
Running make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/headers/*.t
t/apache.t ............... ok   
t/autoescape.t ........... ok     
t/can.t .................. ok   
t/carp.t ................. ok     
t/charset.t .............. ok   
t/checkbox_group.t ....... ok   
t/cookie.t ............... ok     
t/delete.t ............... ok    
t/Dump.t ................. ok   
t/end_form.t ............. ok   
t/fast.t ................. ok   
t/form.t ................. ok    
t/function.t ............. ok     
t/headers.t .............. ok    
t/hidden.t ............... ok   
t/html.t ................. ok     
t/http.t ................. ok   
t/init.t ................. ok   
t/multipart_init.t ....... ok   
t/no_tabindex.t .......... ok     
t/param_fetch.t .......... ok   
t/popup_menu.t ........... ok   
t/pretty.t ............... ok     
t/push.t ................. ok     
t/query_string.t ......... ok   
t/request.t .............. ok     
t/rt-52469.t ............. ok   
t/save_read_roundtrip.t .. ok   
t/start_end_asterisk.t ... ok     
t/start_end_end.t ........ ok     
t/start_end_start.t ...... ok     
t/switch.t ............... ok   
t/tmpdir.t ............... skipped: Root can write to 'unwritable files', so many of these tests don't make sense for root.
t/unescapeHTML.t ......... ok   
t/upload.t ............... ok    
t/uploadInfo.t ........... ok   
t/url.t .................. 1/? Use of uninitialized value in scalar assignment at t/url.t line 28.
Use of uninitialized value in scalar assignment at t/url.t line 29.
Use of uninitialized value in scalar assignment at t/url.t line 30.
Use of uninitialized value in scalar assignment at t/url.t line 31.
t/url.t .................. ok   
t/user_agent.t ........... ok   
t/utf8.t ................. ok   
t/util-58.t .............. ok   
t/util.t ................. ok     
All tests successful.
Files=41, Tests=700,  2 wallclock secs ( 0.15 usr  0.02 sys +  1.20 cusr  0.13 csys =  1.50 CPU)
Result: PASS
  MARKSTOS/CGI.pm-3.63.tar.gz
  /usr/bin/make test -- OK
Running make install
Installing /usr/lib/perl5/5.8.8/CGI.pm
Installing /usr/lib/perl5/5.8.8/CGI/Switch.pm
Installing /usr/lib/perl5/5.8.8/CGI/Push.pm
Installing /usr/lib/perl5/5.8.8/CGI/Apache.pm
Installing /usr/lib/perl5/5.8.8/CGI/Fast.pm
Installing /usr/lib/perl5/5.8.8/CGI/Pretty.pm
Installing /usr/lib/perl5/5.8.8/CGI/Util.pm
Installing /usr/lib/perl5/5.8.8/CGI/Carp.pm
Installing /usr/lib/perl5/5.8.8/CGI/Cookie.pm
Installing /usr/share/man/man3/CGI::Apache.3pm
Installing /usr/share/man/man3/CGI::Cookie.3pm
Installing /usr/share/man/man3/CGI::Fast.3pm
Installing /usr/share/man/man3/CGI::Push.3pm
Installing /usr/share/man/man3/CGI::Util.3pm
Installing /usr/share/man/man3/CGI::Pretty.3pm
Installing /usr/share/man/man3/CGI.3pm
Installing /usr/share/man/man3/CGI::Switch.3pm
Installing /usr/share/man/man3/CGI::Carp.3pm
Appending installation info to /usr/lib/perl5/5.8.8/i386-linux-thread-multi/perllocal.pod
  MARKSTOS/CGI.pm-3.63.tar.gz
  /usr/bin/make install  -- OK

cpan[4]>
然后开始编译相关的percona-toolkit工具； 

[root@Slave02 local]# tar zxvf percona-toolkit-2.2.1.tar.gz 
percona-toolkit-2.2.1/
percona-toolkit-2.2.1/README
percona-toolkit-2.2.1/COPYING
percona-toolkit-2.2.1/Makefile.PL
percona-toolkit-2.2.1/lib/
percona-toolkit-2.2.1/MANIFEST
percona-toolkit-2.2.1/INSTALL
percona-toolkit-2.2.1/bin/
percona-toolkit-2.2.1/bin/pt-query-digest
percona-toolkit-2.2.1/bin/pt-archiver
percona-toolkit-2.2.1/bin/pt-index-usage
percona-toolkit-2.2.1/bin/pt-mysql-summary
percona-toolkit-2.2.1/bin/pt-table-checksum
percona-toolkit-2.2.1/bin/pt-visual-explain
percona-toolkit-2.2.1/bin/pt-show-grants
percona-toolkit-2.2.1/bin/pt-ioprofile
percona-toolkit-2.2.1/bin/pt-fifo-split
percona-toolkit-2.2.1/bin/pt-kill
percona-toolkit-2.2.1/bin/pt-align
percona-toolkit-2.2.1/bin/pt-slave-restart
percona-toolkit-2.2.1/bin/pt-slave-find
percona-toolkit-2.2.1/bin/pt-table-usage
percona-toolkit-2.2.1/bin/pt-fk-error-logger
percona-toolkit-2.2.1/bin/pt-online-schema-change
percona-toolkit-2.2.1/bin/pt-upgrade
percona-toolkit-2.2.1/bin/pt-heartbeat
percona-toolkit-2.2.1/bin/pt-config-diff
percona-toolkit-2.2.1/bin/pt-slave-delay
percona-toolkit-2.2.1/bin/pt-duplicate-key-checker
percona-toolkit-2.2.1/bin/pt-find
percona-toolkit-2.2.1/bin/pt-sift
percona-toolkit-2.2.1/bin/pt-pmp
percona-toolkit-2.2.1/bin/pt-deadlock-logger
percona-toolkit-2.2.1/bin/pt-variable-advisor
percona-toolkit-2.2.1/bin/pt-stalk
percona-toolkit-2.2.1/bin/pt-fingerprint
percona-toolkit-2.2.1/bin/pt-summary
percona-toolkit-2.2.1/bin/pt-table-sync
percona-toolkit-2.2.1/bin/pt-mext
percona-toolkit-2.2.1/bin/pt-diskstats
percona-toolkit-2.2.1/Changelog
percona-toolkit-2.2.1/docs/
percona-toolkit-2.2.1/docs/percona-toolkit.pod
[root@Slave02 local]# cd percona-toolkit-2.2.1
[root@Slave02 percona-toolkit-2.2.1]# perl Makefile.PL 
Checking if your kit is complete...
Looks good
Writing Makefile for percona-toolkit
Writing MYMETA.yml and MYMETA.json
[root@Slave02 percona-toolkit-2.2.1]# make
cp bin/pt-mysql-summary blib/script/pt-mysql-summary
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-mysql-summary
cp bin/pt-pmp blib/script/pt-pmp
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-pmp
cp bin/pt-kill blib/script/pt-kill
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-kill
cp bin/pt-online-schema-change blib/script/pt-online-schema-change
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-online-schema-change
cp bin/pt-align blib/script/pt-align
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-align
cp bin/pt-heartbeat blib/script/pt-heartbeat
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-heartbeat
cp bin/pt-table-sync blib/script/pt-table-sync
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-table-sync
cp bin/pt-upgrade blib/script/pt-upgrade
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-upgrade
cp bin/pt-table-usage blib/script/pt-table-usage
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-table-usage
cp bin/pt-slave-delay blib/script/pt-slave-delay
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-slave-delay
cp bin/pt-sift blib/script/pt-sift
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-sift
cp bin/pt-fifo-split blib/script/pt-fifo-split
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-fifo-split
cp bin/pt-slave-find blib/script/pt-slave-find
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-slave-find
cp bin/pt-ioprofile blib/script/pt-ioprofile
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-ioprofile
cp bin/pt-diskstats blib/script/pt-diskstats
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-diskstats
cp bin/pt-find blib/script/pt-find
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-find
cp bin/pt-archiver blib/script/pt-archiver
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-archiver
cp bin/pt-deadlock-logger blib/script/pt-deadlock-logger
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-deadlock-logger
cp bin/pt-fingerprint blib/script/pt-fingerprint
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-fingerprint
cp bin/pt-visual-explain blib/script/pt-visual-explain
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-visual-explain
cp bin/pt-variable-advisor blib/script/pt-variable-advisor
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-variable-advisor
cp bin/pt-mext blib/script/pt-mext
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-mext
cp bin/pt-index-usage blib/script/pt-index-usage
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-index-usage
cp bin/pt-slave-restart blib/script/pt-slave-restart
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-slave-restart
cp bin/pt-summary blib/script/pt-summary
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-summary
cp bin/pt-duplicate-key-checker blib/script/pt-duplicate-key-checker
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-duplicate-key-checker
cp bin/pt-fk-error-logger blib/script/pt-fk-error-logger
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-fk-error-logger
cp bin/pt-table-checksum blib/script/pt-table-checksum
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-table-checksum
cp bin/pt-query-digest blib/script/pt-query-digest
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-query-digest
cp bin/pt-show-grants blib/script/pt-show-grants
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-show-grants
cp bin/pt-config-diff blib/script/pt-config-diff
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-config-diff
cp bin/pt-stalk blib/script/pt-stalk
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pt-stalk
Manifying blib/man1/pt-mysql-summary.1p
Manifying blib/man1/pt-kill.1p
Manifying blib/man1/pt-online-schema-change.1p
Manifying blib/man1/pt-table-sync.1p
Manifying blib/man1/pt-upgrade.1p
Manifying blib/man1/pt-table-usage.1p
Manifying blib/man1/pt-fifo-split.1p
Manifying blib/man1/pt-slave-find.1p
Manifying blib/man1/pt-ioprofile.1p
Manifying blib/man1/pt-find.1p
Manifying blib/man1/pt-archiver.1p
Manifying blib/man1/pt-deadlock-logger.1p
Manifying blib/man1/pt-fingerprint.1p
Manifying blib/man1/pt-mext.1p
Manifying blib/man1/pt-slave-restart.1p
Manifying blib/man1/pt-summary.1p
Manifying blib/man1/pt-fk-error-logger.1p
Manifying blib/man1/pt-table-checksum.1p
Manifying blib/man1/pt-query-digest.1p
Manifying blib/man1/pt-show-grants.1p
Manifying blib/man1/percona-toolkit.1p
Manifying blib/man1/pt-pmp.1p
Manifying blib/man1/pt-align.1p
Manifying blib/man1/pt-heartbeat.1p
Manifying blib/man1/pt-slave-delay.1p
Manifying blib/man1/pt-sift.1p
Manifying blib/man1/pt-diskstats.1p
Manifying blib/man1/pt-visual-explain.1p
Manifying blib/man1/pt-variable-advisor.1p
Manifying blib/man1/pt-index-usage.1p
Manifying blib/man1/pt-duplicate-key-checker.1p
Manifying blib/man1/pt-config-diff.1p
Manifying blib/man1/pt-stalk.1p
[root@Slave02 percona-toolkit-2.2.1]#
[root@Slave02 percona-toolkit-2.2.1]# make install
Installing /usr/share/man/man1/pt-pmp.1p
Installing /usr/share/man/man1/pt-upgrade.1p
Installing /usr/share/man/man1/pt-fk-error-logger.1p
Installing /usr/share/man/man1/pt-visual-explain.1p
Installing /usr/share/man/man1/pt-ioprofile.1p
Installing /usr/share/man/man1/pt-fifo-split.1p
Installing /usr/share/man/man1/pt-heartbeat.1p
Installing /usr/share/man/man1/pt-table-sync.1p
Installing /usr/share/man/man1/pt-slave-restart.1p
Installing /usr/share/man/man1/pt-align.1p
Installing /usr/share/man/man1/pt-find.1p
Installing /usr/share/man/man1/pt-summary.1p
Installing /usr/share/man/man1/pt-slave-find.1p
Installing /usr/share/man/man1/pt-fingerprint.1p
Installing /usr/share/man/man1/pt-show-grants.1p
Installing /usr/share/man/man1/pt-duplicate-key-checker.1p
Installing /usr/share/man/man1/pt-config-diff.1p
Installing /usr/share/man/man1/pt-variable-advisor.1p
Installing /usr/share/man/man1/pt-kill.1p
Installing /usr/share/man/man1/pt-sift.1p
Installing /usr/share/man/man1/pt-diskstats.1p
Installing /usr/share/man/man1/pt-online-schema-change.1p
Installing /usr/share/man/man1/pt-stalk.1p
Installing /usr/share/man/man1/pt-slave-delay.1p
Installing /usr/share/man/man1/pt-table-checksum.1p
Installing /usr/share/man/man1/pt-deadlock-logger.1p
Installing /usr/share/man/man1/pt-index-usage.1p
Installing /usr/share/man/man1/pt-mext.1p
Installing /usr/share/man/man1/pt-table-usage.1p
Installing /usr/share/man/man1/percona-toolkit.1p
Installing /usr/share/man/man1/pt-archiver.1p
Installing /usr/share/man/man1/pt-mysql-summary.1p
Installing /usr/share/man/man1/pt-query-digest.1p
Installing /usr/bin/pt-online-schema-change
Installing /usr/bin/pt-table-usage
Installing /usr/bin/pt-sift
Installing /usr/bin/pt-archiver
Installing /usr/bin/pt-visual-explain
Installing /usr/bin/pt-heartbeat
Installing /usr/bin/pt-query-digest
Installing /usr/bin/pt-find
Installing /usr/bin/pt-config-diff
Installing /usr/bin/pt-table-sync
Installing /usr/bin/pt-fk-error-logger
Installing /usr/bin/pt-mext
Installing /usr/bin/pt-mysql-summary
Installing /usr/bin/pt-duplicate-key-checker
Installing /usr/bin/pt-table-checksum
Installing /usr/bin/pt-stalk
Installing /usr/bin/pt-show-grants
Installing /usr/bin/pt-ioprofile
Installing /usr/bin/pt-diskstats
Installing /usr/bin/pt-variable-advisor
Installing /usr/bin/pt-summary
Installing /usr/bin/pt-index-usage
Installing /usr/bin/pt-slave-find
Installing /usr/bin/pt-slave-restart
Installing /usr/bin/pt-kill
Installing /usr/bin/pt-upgrade
Installing /usr/bin/pt-deadlock-logger
Installing /usr/bin/pt-slave-delay
Installing /usr/bin/pt-fifo-split
Installing /usr/bin/pt-align
Installing /usr/bin/pt-pmp
Installing /usr/bin/pt-fingerprint
Appending installation info to /usr/lib/perl5/5.8.8/i386-linux-thread-multi/perllocal.pod
[root@Slave02 percona-toolkit-2.2.1]#
然后就可以使用各种包里的相关命令集合了，呵呵，比如：

pt-duplicate-key-checker，pt-online-schema-change，pt-query-advisor，pt-show-grants，pt-upgrade等等各种命令！

[root@Slave02 percona-toolkit-2.2.1]# pt-duplicate-key-checker --host=localhost 
--user=root --password=root --databases=prod
# ########################################################################
# prod.customers                                                          
# ########################################################################

# customer_name_i is a duplicate of sss
# Key definitions:
#   KEY `customer_name_i` (`CUSTOMER_NAME`),
#   KEY `sss` (`CUSTOMER_NAME`)
# Column types:
#         `customer_name` varchar(40) not null
# To remove this duplicate index, execute:
ALTER TABLE `prod`.`customers` DROP INDEX `customer_name_i`;

# ########################################################################
# Summary of indexes                                                      
# ########################################################################

# Size Duplicate Indexes   4238388
# Total Duplicate Indexes  1
# Total Indexes            15
[root@Slave02 percona-toolkit-2.2.1]# pt-duplicate-key-checker --host=localhost 
--user=root --password=root --databases=book
# ########################################################################
# book.artist                                                             
# ########################################################################

# type is a left-prefix of type_2
# Key definitions:
#   KEY `type` (`type`),
#   KEY `type_2` (`type`,`gender`,`country_id`),
# Column types:
#         `type` enum('band','person','unknown','combination') not null
#         `gender` enum('male','female') default null
#         `country_id` smallint(5) unsigned default null
# To remove this duplicate index, execute:
ALTER TABLE `book`.`artist` DROP INDEX `type`;

# ########################################################################
# Summary of indexes                                                      
# ########################################################################

# Size Duplicate Indexes   582368
# Total Duplicate Indexes  1
# Total Indexes            7
[root@Slave02 percona-toolkit-2.2.1]#



太阳上有风
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
Percona toolkit
12-17
percona-toolkit对服务器和Mysql的监控、故障分析和性能调整等很有帮助
docker-percona-toolkit:Percona工具包的Docker映像
05-12
Percona Toolkit forMySQL:registered:是由Percona技术人员开发和使用的高级开源命令行工具的集合，这些工具被设计用于执行各种MySQL和系统任务，这些任务很难或太复杂而无法手动执行。 Percona Toolkit支持Percona ...
percona-toolkit工具包的安装和使用
weixin_33920401的博客
05-12 118
percona-toolkit工具包的安装和使用 PT工具是使用Perl语言编写和执行的，所以需要系统中有Perl环境。rpm -qaperl-DBIperl-DBD-MySQLperl-Time-HiResperl-IO-Socket-SSL如果有依赖包确实，可以使用下面的命令安装：yum install perl-DBI yum install perl-DB...
深度解析Percona Toolkit工具集
最新发布
qq_34692500的博客
06-04 488
介绍 Percona Toolkit是一套专业的MySQL和MariaDB数据库管理工具，涵盖了从性能优化到数据同步和备份恢复的多个方面。本文将深入探讨Percona Toolkit工具集的核心功能和使用场景，帮助你更好地理解和利用这些强大的数据库工具。主要功能和用途性能优化和分析:l使用pt-query-digest分析慢查询，优化数据库性能。l使用pt-index-usage检查和...
percona-toolkit安装
weixin_34092455的博客
05-07 133
一、获取源码包https://www.percona.com/software/database-tools/percona-toolkit 根据版本和包的种类选取并下载源码包“source code” 二、安装依赖包比较认可的说法，是将perl包全部安装，否则编译通过后，执行命令也会报错。yum install perl-* 三、安装tar -zxvf percona-toolkit-3.0.9...
Percona Toolkit mysql辅助利器
weixin_33847182的博客
01-19 1157
1 PT介绍 Percona Toolkit简称pt工具—PT-Tools，是Percona公司开发用于管理MySQL的工具，功能包括检查主从复制的数据一致性、检查重复索引、定位IO占用高的表文件、在线DDL等，DBA熟悉掌握后将极大提高工作效率。 2 PT 安装 下载地址 ：https://www.percona.com/downloads/percona-toolkit/ 下载完...
Percona Toolkit
地 衣
10-15 615
1、简介： percona-toolkit是一组高级命令行工具的集合，用来执行各种通过手工执行非常复杂和麻烦的mysql和系统任务，这些任务包括： 检查master和slave数据的一致性 有效地对记录进行归档 查找重复的索引 对服务器信息进行汇总 分析来自日志和tcpdump的查询 当系统出问题的时候收集重要的系统信息 2、软件下载: 地址：https://www.percon
percona-toolkit-3.3.1-1-最新版.zip
03-29
1、percona-toolkit-3.3.1-1-最新版.zip 2、支持centos、redhat、orace linux、ubuntu、debian、麒麟V10、欧拉系统等个版本Linux系统。 3、内部各版本安装包列表如下： percona-toolkit-3.3.1-1.el7.x86_64.rpm、 ...
docker-percona-toolkit:Docker Percona工具包存储库
04-27
docker-percona-toolkit状态 docker-percona-toolkit 可以运行Alpine Docker映像。 pt对齐 pt存档器 pt-config-diff pt-deadlock-logger pt-diskstats pt-重复键检查器 pt-fifo-split pt查找 pt指纹 pt-fk错误...
使用percona-toolkit操作MySQL的实用命令小结
12-15
这个工具只是归档旧的数据，不会对线上数据的OLTP查询造成太大影响，你可以将数据插入另外一台服务器的其他表中，也可以写入到一个文件中，方便使用load data infile命令导入数据。另外你还可以用它来执行delete操作...
percona-toolkit-3.zip
03-15
1、percona-toolkit-3 rpm包，含 CentOS 6和7版本 2、直接rpm -ivh安装即可，安装好后里面有如下常用命令 3、pt-table-checksum 检测MySQL主从数据一致性 4、pt-table-sync 修复主从数据不一样的记录 3、pt-online-...
percona-toolkit-3.0.2
04-02
percona-toolkit-3.0.2-1.el6.x86_64
percona-toolkit-3.0.4
01-18
percona工具已经成为DBA不可或缺的使用工具 这里提供了很多对我们有帮助的工具 一起一探究竟吧
percona-toolkit --centos7
08-28
percona-toolkit 下载，测试可用，centos7兼容版本，共享出来
percona-toolkit工具
weixin_47680367的博客
05-26 410
percona-toolkit工具
mysql percona-toolkit_Percona_Toolkit 简介及安装 -- MySQL管理员必备的工具包
weixin_28718769的博客
01-27 296
Percona_ToolkitPercona Toolkit 的简介：(来自官方的简介)Percona Toolkit for MySQL is a collection for advanced command-line tools userd by Percona MySQL staff to perform a variety of MySQL server and system tasks...
监控mysql主从数据一致,Mysql主从同步percona-toolkit数据一致性监测
weixin_34725745的博客
03-27 425
本文源链接地址：https:www.93bok.com引言在mysql工作中接触最多的就是mysql replication，mysql在复制方面还是会有一些常规问题，比如主库宕机或者从库宕机有可能会导致复制中断，通常需要进行人为修复，或者很多时候需要把一个从库提升为主库，但对从库和主库的数据一致性不能保证一样。这种情况下就需要使用percona-toolkit工具的pt-table-checks...
MySQL DBA必备工具使用的6大锦囊妙计
wangjinbao5566的博客
08-15 931
今儿给大家分享一篇，关于MySQL DBA必备工具的使用。可以方便帮助我们管理我们的数据库，让我们的工作更高效。 这款工具是 MySQL 一个重要分支 percona 的，名称叫做 percona-toolkit（一把锋利的瑞士军刀），它呢是一组命令的集合。今儿给大家介绍几个我们在生产环境中最长用到的。 工具包的下载地址：https://www.percona.com/down
Percona_Toolkit 安装
李晓蒙的博客
04-19 675
252  wget http://percona.com/get/percona-toolkit.rpm   253  ls   254  yum install perl-DBD-MySQL   255  yum install perl-Time-HiRes   256  yum install perl-IO-Socket-SSL   264  yum install perl-T
掌握percona-toolkit：高效MySQL任务处理与系统监控教程
Percona Toolkit是一款强大的工具集，专为MySQL数据库管理...Percona Toolkit是一个不可或缺的数据库管理员工具箱，它为MySQL数据库的日常运维提供了强大的支持，是每一位关注数据库性能和稳定性的DBA值得掌握的技能。
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值