[root@garey-mysql2 ~]# mytop
install_driver(mysql) failed: Can't load '/usr/lib64/perl5/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.16: cannot open shared object file: No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 200.
at (eval 12) line 3
Compilation failed in require at (eval 12) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /usr/bin/mytop line 235
[root@garey-mysql2 ~]# yum install perl-DBD-MySQL
Loaded plugins: fastestmirror
Setting up Install Process
Loading mirror speeds from cached hostfile
* base: centos-hn.viettelidc.com.vn
* epel: mirror.premi.st
* extras: centos-hn.viettelidc.com.vn
* updates: centos-hn.viettelidc.com.vn
Package perl-DBD-MySQL-4.013-3.el6.x86_64 already installed and latest version
Nothing to do
[root@garey-mysql2 ~]# rpm -qa | grep -i dbd
perl-DBD-MySQL-4.013-3.el6.x86_64
[root@garey-mysql2 ~]# rpm -e --nodeps perl-DBD-MySQL-4.013-3.el6.x86_64
[root@garey-mysql2 ~]# rpm -qa | grep dbd
[root@garey-mysql2 ~]# yum install perl-DBD-mysql
Loaded plugins: fastestmirror
Setting up Install Process
Loading mirror speeds from cached hostfile
* base: centos-hn.viettelidc.com.vn
* epel: mirror.premi.st
* extras: centos-hn.viettelidc.com.vn
* updates: centos-hn.viettelidc.com.vn
Resolving Dependencies
--> Running transaction check
---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: perl-DBD-MySQL-4.013-3.e l6.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Running transaction check
---> Package mysql-libs.x86_64 0:5.1.73-7.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
===============================================================================================================
Package Arch Version Repository Size
===============================================================================================================
Installing:
perl-DBD-MySQL x86_64 4.013-3.el6 base 134 k
Installing for dependencies:
mysql-libs x86_64 5.1.73-7.el6 base 1.2 M
Transaction Summary
===============================================================================================================
Install 2 Package(s)
Total download size: 1.4 M
Installed size: 4.4 M
Is this ok [y/N]: y
Downloading Packages:
(1/2): mysql-libs-5.1.73-7.el6.x86_64.rpm | 1.2 MB 00:00
(2/2): perl-DBD-MySQL-4.013-3.el6.x86_64.rpm | 134 kB 00:00
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 39 kB/s | 1.4 MB 00:35
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
** Found 4 pre-existing rpmdb problem(s), 'yum check' output follows:
mytop-1.7-3.b737f60.el6.noarch has missing requires of perl(DBD::mysql) >= ('0', '1', None)
2:postfix-2.6.6-6.el6_7.1.x86_64 has missing requires of libmysqlclient.so.16()(64bit)
2:postfix-2.6.6-6.el6_7.1.x86_64 has missing requires of libmysqlclient.so.16(libmysqlclient_16)(64bit)
2:postfix-2.6.6-6.el6_7.1.x86_64 has missing requires of mysql-libs
Installing : mysql-libs-5.1.73-7.el6.x86_64 1/2
warning: /etc/my.cnf created as /etc/my.cnf.rpmnew
Installing : perl-DBD-MySQL-4.013-3.el6.x86_64 2/2
Verifying : perl-DBD-MySQL-4.013-3.el6.x86_64 1/2
Verifying : mysql-libs-5.1.73-7.el6.x86_64 2/2
Installed:
perl-DBD-MySQL.x86_64 0:4.013-3.el6
Dependency Installed:
mysql-libs.x86_64 0:5.1.73-7.el6
Complete!
[root@garey-mysql2 ~]# rpm -qa | grep -i dbd
perl-DBD-MySQL-4.013-3.el6.x86_64
[root@garey-mysql2 ~]# mytop
MySQL on localhost (5.6.24-log) up 4+03:52:10 [15:38:39]
Queries: 7.0 qps: 0 Slow: 0.0 Se/In/Up/De(%): 14/00/00/00
Key Efficiency: 100.0% Bps in/out: 0.0/ 0.0
Id User Host/IP DB Time Cmd Query or State
-- ---- ------- -- ---- --- ----------
4 root localhost test 0 Query show full processlist
1 system us 359512 Connec Slave has read all relay log; waiting for the slave I/O thread to update it
2 system us 359513 Connec Connecting to master