Centos 安装Percona Toolkit工具集

时间：2020-12-16 20:55:10

1、下载

下载地址：   https://www.percona.com/downloads/percona-toolkit/LATEST/

Centos 安装Percona Toolkit工具集

[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.-.el7.x86_64.rpm

warning: percona-toolkit-3.0.-.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.-.el7.x86_64

        perl(DBD::mysql) >= 1.0 is needed by percona-toolkit-3.0.-.el7.x86_64

        perl(IO::Socket::SSL) is needed by percona-toolkit-3.0.-.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.-.el7.x86_64.rpm

warning: percona-toolkit-3.0.-.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 8507efa5: NOKEY

Preparing...                          ################################# [%]

Updating / installing...

   :percona-toolkit-3.0.-.el7     ################################# [%]

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

相关文章