percona-toolkit dba必备工具包安装及冲突处理
一、顺利安装# rpm -qa |grep percona
# netstat -ntlp|grep mysql
tcp 0 0 :::3306 :::* LISTEN 2685/mysqld
# cd /tmp
# ls
hsperfdata_hadooporbit-gdm pulse-pQJ5sFdWhlEW
hsperfdata_root percona-toolkit-2.2.19-1.noarch.rpmpulse-YGSUaxgYKMIW
# rpm -ivh percona-toolkit-2.2.19-1.noarch.rpm
warning: percona-toolkit-2.2.19-1.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
error: Failed dependencies:
perl(DBI) >= 1.13 is needed by percona-toolkit-2.2.19-1.noarch
perl(DBD::mysql) >= 1.0 is needed by percona-toolkit-2.2.19-1.noarch
perl(Time::HiRes) is needed by percona-toolkit-2.2.19-1.noarch
perl(IO::Socket::SSL) is needed by percona-toolkit-2.2.19-1.noarch
perl(Term::ReadKey) is needed by percona-toolkit-2.2.19-1.noarch
# yum install percona-toolkit-2.2.19-1.noarch.rpm
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Install Process
Examining percona-toolkit-2.2.19-1.noarch.rpm: percona-toolkit-2.2.19-1.noarch
Marking percona-toolkit-2.2.19-1.noarch.rpm to be installed
Determining fastest mirrors
base | 4.0 kB 00:00
Resolving Dependencies
--> Running transaction check
---> Package percona-toolkit.noarch 0:2.2.19-1 will be installed
--> Processing Dependency: perl(DBI) >= 1.13 for package: percona-toolkit-2.2.19-1.noarch
--> Processing Dependency: perl(DBD::mysql) >= 1.0 for package: percona-toolkit-2.2.19-1.noarch
--> Processing Dependency: perl(Time::HiRes) for package: percona-toolkit-2.2.19-1.noarch
--> Processing Dependency: perl(IO::Socket::SSL) for package: percona-toolkit-2.2.19-1.noarch
--> Processing Dependency: perl(Term::ReadKey) for package: percona-toolkit-2.2.19-1.noarch
--> Running transaction check
---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed
---> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed
---> Package perl-IO-Socket-SSL.noarch 0:1.31-2.el6 will be installed
--> Processing Dependency: perl(Net::SSLeay) >= 1.21 for package: perl-IO-Socket-SSL-1.31-2.el6.noarch
--> Processing Dependency: perl(Net::LibIDN) for package: perl-IO-Socket-SSL-1.31-2.el6.noarch
---> Package perl-TermReadKey.x86_64 0:2.30-13.el6 will be installed
---> Package perl-Time-HiRes.x86_64 4:1.9721-136.el6 will be installed
--> Running transaction check
---> Package perl-Net-LibIDN.x86_64 0:0.12-3.el6 will be installed
---> Package perl-Net-SSLeay.x86_64 0:1.35-9.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=========================================================================================================================
Package Arch Version Repository Size
===========================================================================================
Installing:
percona-toolkit noarch 2.2.19-1 /percona-toolkit-2.2.19-1.noarch 5.7 M
Installing for dependencies:
perl-DBD-MySQL x86_64 4.013-3.el6 base 134 k
perl-DBI x86_64 1.609-4.el6 base 705 k
perl-IO-Socket-SSL noarch 1.31-2.el6 base 69 k
perl-Net-LibIDN x86_64 0.12-3.el6 base 35 k
perl-Net-SSLeay x86_64 1.35-9.el6 base 173 k
perl-TermReadKey x86_64 2.30-13.el6 base 31 k
perl-Time-HiRes x86_64 4:1.9721-136.el6 base 48 k
Transaction Summary
===========================================================================================
Install 8 Package(s)
Total size: 6.8 M
Total download size: 1.2 M
Installed size: 8.6 M
Is this ok : y
Downloading Packages:
(1/7): perl-Net-LibIDN-0.12-3.el6.x86_64.rpm |35 kB 00:00
(2/7): perl-IO-Socket-SSL-1.31-2.el6.noarch.rpm |69 kB 00:00
(3/7): perl-DBD-MySQL-4.013-3.el6.x86_64.rpm | 134 kB 00:00
(4/7): perl-DBI-1.609-4.el6.x86_64.rpm | 705 kB 00:00
(5/7): perl-TermReadKey-2.30-13.el6.x86_64.rpm |31 kB 00:00
(6/7): perl-Net-SSLeay-1.35-9.el6.x86_64.rpm | 173 kB 00:00
(7/7): perl-Time-HiRes-1.9721-136.el6.x86_64.rpm |48 kB 00:00
-------------------------------------------------------------------------------------------------------------------------
Total 19 MB/s | 1.2 MB 00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : perl-DBI-1.609-4.el6.x86_64 1/8
Installing : perl-DBD-MySQL-4.013-3.el6.x86_64 2/8
Installing : 4:perl-Time-HiRes-1.9721-136.el6.x86_64 3/8
Installing : perl-Net-SSLeay-1.35-9.el6.x86_64 4/8
Installing : perl-TermReadKey-2.30-13.el6.x86_64 5/8
Installing : perl-Net-LibIDN-0.12-3.el6.x86_64 6/8
Installing : perl-IO-Socket-SSL-1.31-2.el6.noarch 7/8
Installing : percona-toolkit-2.2.19-1.noarch 8/8
Verifying: perl-Net-LibIDN-0.12-3.el6.x86_64 1/8
Verifying: perl-IO-Socket-SSL-1.31-2.el6.noarch 2/8
Verifying: perl-DBD-MySQL-4.013-3.el6.x86_64 3/8
Verifying: perl-DBI-1.609-4.el6.x86_64 4/8
Verifying: perl-TermReadKey-2.30-13.el6.x86_64 5/8
Verifying: perl-Net-SSLeay-1.35-9.el6.x86_64 6/8
Verifying: 4:perl-Time-HiRes-1.9721-136.el6.x86_64 7/8
Verifying: percona-toolkit-2.2.19-1.noarch 8/8
Installed:
percona-toolkit.noarch 0:2.2.19-1
Dependency Installed:
perl-DBD-MySQL.x86_64 0:4.013-3.el6 perl-DBI.x86_64 0:1.609-4.el6 perl-IO-Socket-SSL.noarch 0:1.31-2.el6
perl-Net-LibIDN.x86_64 0:0.12-3.el6 perl-Net-SSLeay.x86_64 0:1.35-9.el6perl-TermReadKey.x86_64 0:2.30-13.el6
perl-Time-HiRes.x86_64 4:1.9721-136.el6
Complete!
二、冲突解决
报错
Transaction Check Error:
file /usr/share/mysql/charsets/Index.xml from install of mysql-libs-5.1.71-1.el6.x86_64 conflicts with file from package MySQL-server-5.6.25-1.el6.x86_64
file /usr/share/mysql/charsets/armscii8.xml from install of mysql-libs-5.1.71-1.el6.x86_64 conflicts with file from package MySQL-server-5.6.25-1.el6.x86_64
file /usr/share/mysql/charsets/ascii.xml from install of mysql-libs-5.1.71-1.el6.x86_64 conflicts with file from package MySQL-server-5.6.25-1.el6.x86_64
file /usr/share/mysql/charsets/cp1250.xml from install of mysql-libs-5.1.71-1.el6.x86_64 conflicts with file from package MySQL-server-5.6.25-1.el6.x86_64
file /usr/share/mysql/charsets/cp1256.xml from install of mysql-libs-5.1.71-1.el6.x86_64 conflicts with file from package MySQL-server-5.6.25-1.el6.x86_64
file /usr/share/mysql/charsets/cp1257.xml from install of mysql-libs-5.1.71-1.el6.x86_64 conflicts with file from package MySQL-server-5.6.25-1.el6.x86_64
file /usr/share/mysql/charsets/cp850.xml from install of mysql-libs-5.1.71-1.el6.x86_64 conflicts with file from package MySQL-server-5.6.25-1.el6.x86_64
file /usr/share/mysql/charsets/cp852.xml from install of mysql-libs-5.1.71-1.el6.x86_64 conflicts with file from package MySQL-server-5.6.25-1.el6.x86_64
安装MySQL-shared-compat-5.6.25-1.linux_glibc2.5.x86_64.rpm 来解决
下载软件包，上传，安装，再重新安装percona-toolkit
# rpm -ivh MySQL-shared-compat-5.6.25-1.linux_glibc2.5.x86_64.rpm
Preparing... ###########################################
1:MySQL-shared-compat ###########################################
# yum install percona-toolkit-2.2.19-1.noarch.rpm
页:
[1]