1、下载
下载地址： https://www.percona.com/downloads/percona-toolkit/LATEST/
[root@bogon ~]# wget https://www.percona.com/downloads/percona-toolkit/3.0.13/binary/redhat/7/x86_64/percona-toolkit-3.0.13-re85ce15-el7-x86_64-bundle.tar
2、安装
[root@bogon ~]# rpm -ivh percona-toolkit-3.0.13-1.el7.x86_64.rpm warning: percona-toolkit-3.0.13-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 8507efa5: NOKEY error: Failed dependencies: perl(DBI) >= 1.13 is needed by percona-toolkit-3.0.13-1.el7.x86_64 perl(DBD::mysql) >= 1.0 is needed by percona-toolkit-3.0.13-1.el7.x86_64 perl(IO::Socket::SSL) is needed by percona-toolkit-3.0.13-1.el7.x86_64
缺少 perl-DBI perl-DBD-MySQL perl-IO-Socket-SSL 依赖包，通过yum安装即可
再次安装 percona-toolkit-3.0.13-1.el7.x86_64.rpm
[root@bogon ~]# rpm -ivh percona-toolkit-3.0.13-1.el7.x86_64.rpm warning: percona-toolkit-3.0.13-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 8507efa5: NOKEY Preparing... ################################# [100%] Updating / installing... 1:percona-toolkit-3.0.13-1.el7 ################################# [100%]
3、检验安装结果
[root@bogon ~]# pt-duplicate-key-checker --help pt-duplicate-key-checker examines MySQL tables for duplicate or redundant indexes and foreign keys. Connection options are read from MySQL option files. For more details, please use the --help option, or try 'perldoc /usr/bin/pt-duplicate-key-checker' for complete documentation. Usage: pt-duplicate-key-checker [OPTIONS] [DSN] Options: --all-structs Compare indexes with different structs (BTREE, HASH, etc) --ask-pass Prompt for a password when connecting to MySQL --charset=s -A Default character set --[no]clustered PK columns appended to secondary key is duplicate ( default yes) --config=A Read this comma-separated list of config files; if specified, this must be the first option on the command line --databases=h -d Check only this comma-separated list of databases --defaults-file=s -F Only read mysql options from the given file --engines=h -e Check only tables whose storage engine is in this comma- separated list --help Show help and exit --host=s -h Connect to host --ignore-databases=H Ignore this comma-separated list of databases --ignore-engines=H Ignore this comma-separated list of storage engines --ignore-order Ignore index order so KEY(a,b) duplicates KEY(b,a) --ignore-tables=H Ignore this comma-separated list of tables --key-types=s Check for duplicate f=foreign keys, k=keys or fk=both ( default fk) --password=s -p Password to use when connecting --pid=s Create the given PID file --port=i -P Port number to use for connection --set-vars=A Set the MySQL variables in this comma-separated list of variable=value pairs --socket=s -S Socket file to use for connection --[no]sql Print DROP KEY statement for each duplicate key ( default yes) --[no]summary Print summary of indexes at end of output (default yes) --tables=h -t Check only this comma-separated list of tables --user=s -u User for login if not current user --verbose -v Output all keys and/or foreign keys found, not just redundant ones --version Show version and exit --[no]version-check Check for the latest version of Percona Toolkit, MySQL, and other programs (default yes) Option types: s=string, i=integer, f=float, h/H/a/A=comma-separated list, d=DSN, z=size, m=time Rules: This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. DSN syntax is key=value[,key=value...] Allowable DSN keys: KEY COPY MEANING === ==== ============================================= A yes Default character set D yes Default database F yes Only read default options from the given file P yes Port number to use for connection S yes Socket file to use for connection h yes Connect to host p yes Password to use when connecting u yes User for login if not current user If the DSN is a bareword, the word is treated as the 'h' key. Options and values after processing arguments: --all-structs FALSE --ask-pass FALSE --charset (No value) --clustered TRUE --config /etc/percona-toolkit/percona-toolkit.conf,/etc/percona-toolkit/pt-duplicate-key-checker.conf,/root/.percona-toolkit.conf,/root/.pt-duplicate-key-checker.conf --databases (No value) --defaults-file (No value) --engines (No value) --help TRUE --host (No value) --ignore-databases --ignore-engines --ignore-order FALSE --ignore-tables --key-types fk --password (No value) --pid (No value) --port (No value) --set-vars --socket (No value) --sql TRUE --summary TRUE --tables (No value) --user (No value) --verbose FALSE --version FALSE --version-check TRUE