sudo yum install perl-DBD-mysql for { install_driver(mysql) failed: Can’t locate DBD/mysql.pm }

mysqlreport makes a friendly report of important MySQL status values. mysqlreport transforms the values from SHOW STATUS into an easy-to-read report that provides an in-depth understanding of how well MySQL is running. mysqlreport is a better alternative (and practically the only alternative) to manually interpreting SHOW STATUS.

Also super-smack and other benchmark suites are a best idea but all gets you to a problem like “install_driver(mysql) failed: Can’t locate DBD/mysql.pm in @INC (@INC co” or something related to perl DBI.

Solutions is to try the below in your command prompt as super root.

[saffrongeek@nerd1 etc]$ cd /home/saffrongeek/Desktop/mysqlreport-3.5
[saffrongeek@nerd1 mysqlreport-3.5]$ ls
COPYING  mysqlreport  mysqlreportdoc.html  mysqlreportguide.html
[saffrongeek@nerd1 mysqlreport-3.5]$ ./mysqlreport -r 10 > report.txt
install_driver(mysql) failed: Can’t locate DBD/mysql.pm in @INC (@INC contains: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.7/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl/5.8.7 /usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 .) at (eval 7) line 3.
Perhaps the DBD::mysql perl module hasn’t been fully installed,
or perhaps the capitalisation of ‘mysql’ isn’t right.
Available drivers: DBM, ExampleP, File, Gofer, Pg, Proxy, Sponge.
at ./mysqlreport line 249
[saffrongeek@nerd1 mysqlreport-3.5]$ sudo yum update DBD
Password:
Setting up Update Process
Could not find update match for DBD
No Packages marked for Update
[saffrongeek@nerd1 mysqlreport-3.5]$ sudo yum install perl-DBD-mysql
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
–> Running transaction check
—> Package perl-DBD-MySQL.i386 0:4.005-2.fc8.1 set to be updated
–> Finished Dependency Resolution

Dependencies Resolved

=============================================================================
Package                 Arch       Version          Repository        Size
=============================================================================
Installing:
perl-DBD-MySQL          i386       4.005-2.fc8.1    fedora            143 k

Transaction Summary
=============================================================================
Install      1 Package(s)
Update       0 Package(s)
Remove       0 Package(s)

Total download size: 143 k
Is this ok [y/N]: y
Downloading Packages:
(1/1): perl-DBD-MySQL-4.0 100% |=========================| 143 kB    00:11
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing: perl-DBD-MySQL               ######################### [1/1]

Installed: perl-DBD-MySQL.i386 0:4.005-2.fc8.1
Complete!
[saffrongeek@nerd1 mysqlreport-3.5]$ ./mysqlreport -r 10 > report.txt
mysqlreport is writing relative reports to ‘/tmp/W8PwFrYYsU’.
[saffrongeek@nerd1 mysqlreport-3.5]$ sudo yum install perl-DBD-mysql perl-DBI
Setting up Install Process
Parsing package install arguments
Requested dep: perl-DBD-mysql is provided by installed package
Package perl-DBI – 1.58-2.fc8.i386 is already installed.
Nothing to do
[saffrongeek@nerd1 mysqlreport-3.5]$

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: