执行pt-tool中pt-query-digest命令报错:
install_driver(mysql) failed: Attempt to reload DBD/mysql.pm aborted.
Compilation failed in require at (eval 31) line 3.at /usr/bin/pt-query-digest line 1001
failed
检查:
# dd /usr/lib64/perl5/auto/DBD/mysql/mysql.so
-
分析perl的mysql.so库文件的依赖库是否完整,可见缺失libmysqlclient.so.16
发现是缺包,到官网下载rpm包;Oracle Linux 6 (x86_64) MySQL 5.6 | Oracle, Software. Hardware. Complete.
找到自己安装的mysql版本和操作系统版本,我的是:5.6.27-2.el6
下载完了安装:
# rpm -ivh mysql-community-libs-compat-5.6.27-2.el6.x86_64.rpm
warning: mysql-community-libs-compat-5.6.27-2.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
error: Failed dependencies:
mysql-community-libs(x86-64) = 5.6.27-2.el6 is needed by mysql-community-libs-compat-5.6.27-2.el6.x86_64
如果报错那么加--nodeps --force
# rpm -ivh mysql-community-libs-compat-5.6.27-2.el6.x86_64.rpm --nodeps --force
warning: mysql-community-libs-compat-5.6.27-2.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing... ########################################### [100%]
1:mysql-community-libs-co########################################### [100%]
安装成功
参考文档:报错install_driver(mysql) failed: Attempt to reload DBD/mysql.pm_ITPUB博客