Installed MySQL monitoring artifact Innotop, is proud, Innotoop is not available, its error is install_driver (mysql) failed:can ' t load '/usr/lib64/perl5/vendor_perl/ 5.8.8/x86_64-linux-thread-multi/auto/dbd/mysql/mysql.so ' for module Dbd::mysql:libmysqlclient.so.15:cannot Open Shared Object file: ... After the investigation of the original is also the bane of the DBD, this problem has occurred several times.
1, fault phenomenon
[Email protected] ~]# cat/etc/issue
CentOS release 5.11 (Final)
Kernel \ r on an \m
[[Email protected]~]# Innotop
localhost processlist_no_is:install_driver (MySQL) failed:
Can ' t load '/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/dbd/mysql/mysql.so '
For module Dbd::mysql:libmysqlclient.so.15:cannot Open shared object file:no such file or directory at
/USR/LIB64/PERL5/5.8.8/X86_64-LINUX-THREAD-MULTI/DYNALOADER.PM Line 230. at (eval 504) Line 3
Compilation failed in require on (eval 504) Line 3.
Perhaps a required shared library or DLL isn ' t installed where expected
At/usr/bin/innotop Line 7601
2, installation Perl-dbd-mysql
[email protected] ~]# Yum install Perl-dbd-mysql
Loaded Plugins:fastestmirror, security
Repository base is listed more than once in the configuration
Repository updates is listed more than once in the configuration
Repository Extras is listed more than once in the configuration
Repository Centosplus is listed more than once in the configuration
Repository contrib is listed more than once in the configuration
Loading mirror speeds from cached hostfile
* base:mirrors.163.com
* epel:mirrors.ustc.edu.cn
* extras:mirrors.skyshe.cn
* updates:mirrors.pubyun.com
Setting up Install Process
Package perl-dbd-mysql-3.0007-2.el5.x86_64 already installed and latest version
Nothing to do
# # #上面描述已经perl-dbd-mysql has been installed and is the latest version
[Email protected] yum.repos.d]# Rpm-qa |grep-i dbd
Perl-dbd-mysql-3.0007-2.el5
# # #首先先卸载perl-dbd-mysql, then use Yum again to install
[Email protected] yum.repos.d]# rpm-e--nodeps perl-dbd-mysql-3.0007-2.el5
[Email protected] yum.repos.d]# Rpm-qa |grep-i dbd
[email protected] yum.repos.d]# Yum install Perl-dbd-mysql
Loaded Plugins:fastestmirror, security
Repository base is listed more than once in the configuration
Repository updates is listed more than once in the configuration
Repository Extras is listed more than once in the configuration
Repository Centosplus is listed more than once in the configuration
Repository contrib is listed more than once in the configuration
Loading mirror speeds from cached hostfile
* base:mirrors.163.com
* epel:mirrors.ustc.edu.cn
* extras:mirrors.skyshe.cn
* updates:mirrors.pubyun.com
Setting up Install Process
Resolving Dependencies
--Running Transaction check
---> Package perl-dbd-mysql.x86_64 0:3.0007-2.el5 Set updated
--processing dependency:libmysqlclient.so.15 (LIBMYSQLCLIENT_15) (64bit) for Package:perl-dbd-mysql
--processing dependency:libmysqlclient.so.15 () (64bit) for Package:perl-dbd-mysql
--Running Transaction check
---> Package mysql.x86_64 0:5.0.95-5.el5_9 Set updated
--Finished Dependency Resolution
Dependencies resolved
=============================================================================================================
Package Arch Version Repository Size
=============================================================================================================
Installing:
Perl-dbd-mysql x86_64 3.0007-2.el5 Base 148 k
Installing for dependencies:
MySQL x86_64 5.0.95-5.el5_9 base 4.9 M
Transaction Summary
=============================================================================================================
Install 2 package (s)
Upgrade 0 Package (s)
Total Download size:5.0 M
Is this OK [y/n]: Y
Downloading Packages:
(a): perl-dbd-mysql-3.0007-2.el5.x86_64.rpm | 148 KB 00:00
(2/2): mysql-5.0.95-5.el5_9.x86_64.rpm | 4.9 MB 00:11
-------------------------------------------------------------------------------------------------------------
Total 406 kb/s | 5.0 MB 00:12
Running Rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing:mysql 1/2
Warning:/etc/my.cnf created as/etc/my.cnf.rpmnew
Installing:perl-dbd-mysql 2/2
Installed:
Perl-dbd-mysql.x86_64 0:3.0007-2.el5
Dependency installed:
Mysql.x86_64 0:5.0.95-5.el5_9
complete!
# # #再次启用innotop正常
[Email protected] yum.repos.d]# Innotop
3, about Perl-dbd-mysql
Dbd::mysql is the PERL5 database Interface driver for the MySQL database. In other words:dbd::mysql are an interface between the Perl programming language and the MySQL programming API that comes With the MySQL relational database management system. Most functions provided by this programming API is supported. Some rarely used functions is missing, mainly because no-one ever requested them. :-)
http://search.cpan.org/dist/DBD-mysql/lib/DBD/mysql.pm
http://search.cpan.org/dist/DBD-mysql/
Encounter Dbd::mysql::d r::imp_data_size unexpectedly
Temporary failure in name resolution
Install_driver (MySQL) failed
