Monday, July 25, 2011

Install Maat-Kit

1.wget http://maatkit.googlecode.com/files/maatkit-7207.tar.gz
tar zxvf maatkit-7207.tar.gz
maatkit-7207/
maatkit-7207/Changelog
maatkit-7207/udf/
maatkit-7207/udf/fnv_udf.cc
maatkit-7207/udf/murmur_udf.cc
maatkit-7207/lib/
maatkit-7207/bin/
maatkit-7207/bin/mk-table-checksum
maatkit-7207/bin/mk-find
maatkit-7207/bin/mk-query-digest
maatkit-7207/bin/mk-kill
maatkit-7207/bin/mk-duplicate-key-checker
maatkit-7207/bin/mk-merge-mqd-results
maatkit-7207/bin/mk-purge-logs
maatkit-7207/bin/mk-archiver
maatkit-7207/bin/mk-loadavg
maatkit-7207/bin/mk-profile-compact
maatkit-7207/bin/mk-fifo-split
maatkit-7207/bin/mk-variable-advisor
maatkit-7207/bin/mk-slave-prefetch
maatkit-7207/bin/mk-slave-find
maatkit-7207/bin/mk-slave-delay
maatkit-7207/bin/mk-log-player
maatkit-7207/bin/mk-index-usage
maatkit-7207/bin/mk-slave-restart
maatkit-7207/bin/mk-error-log
maatkit-7207/bin/mk-query-advisor
maatkit-7207/bin/mk-show-grants
maatkit-7207/bin/mk-upgrade
maatkit-7207/bin/mk-heartbeat
maatkit-7207/bin/mk-deadlock-logger
maatkit-7207/bin/mk-parallel-dump
maatkit-7207/bin/mk-parallel-restore
maatkit-7207/bin/mk-checksum-filter
maatkit-7207/bin/mk-table-sync
maatkit-7207/bin/mk-query-profiler
maatkit-7207/bin/mk-slave-move
maatkit-7207/bin/mk-visual-explain
maatkit-7207/init/
maatkit-7207/init/maatkit
maatkit-7207/maatkit.pod
maatkit-7207/MANIFEST
maatkit-7207/README
maatkit-7207/Makefile.PL
maatkit-7207/COPYING
maatkit-7207/INSTALL
maatkit-7207/maatkit.spec

# cd maatkit-7207

# perl Makefile.PL
Checking if your kit is complete...
Looks good
Warning: prerequisite DBD::mysql 1 not found.
Writing Makefile for maatkit

# rpm -ivh --nodeps mysql-devel-5.0.45-7.el5.x86_64.rpm
準備中... ########################################### [100%]
1:mysql-devel ########################################### [100%]

# rpm -ivh --nodeps perl-DBD-MySQL-3.0007-1.fc6.x86_64.rpm
準備中... ########################################### [100%]
1:perl-DBD-MySQL ########################################### [100%]


still facing the same issue
run
perl -MCPAN -e 'install Bundle::DBD::mysql'

# perl Makefile.PL
Writing Makefile for maatkit
# make
cp maatkit.pod blib/lib/maatkit.pod
cp bin/mk-slave-prefetch blib/script/mk-slave-prefetch
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-slave-prefetch
cp bin/mk-query-profiler blib/script/mk-query-profiler
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-query-profiler
cp bin/mk-profile-compact blib/script/mk-profile-compact
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-profile-compact
cp bin/mk-log-player blib/script/mk-log-player
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-log-player
cp bin/mk-slave-move blib/script/mk-slave-move
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-slave-move
cp bin/mk-index-usage blib/script/mk-index-usage
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-index-usage
cp bin/mk-purge-logs blib/script/mk-purge-logs
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-purge-logs
cp bin/mk-upgrade blib/script/mk-upgrade
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-upgrade
cp bin/mk-find blib/script/mk-find
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-find
cp bin/mk-loadavg blib/script/mk-loadavg
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-loadavg
cp bin/mk-heartbeat blib/script/mk-heartbeat
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-heartbeat
cp bin/mk-variable-advisor blib/script/mk-variable-advisor
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-variable-advisor
cp bin/mk-parallel-restore blib/script/mk-parallel-restore
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-parallel-restore
cp bin/mk-slave-find blib/script/mk-slave-find
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-slave-find
cp bin/mk-fifo-split blib/script/mk-fifo-split
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-fifo-split
cp bin/mk-kill blib/script/mk-kill
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-kill
cp bin/mk-query-digest blib/script/mk-query-digest
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-query-digest
cp bin/mk-table-sync blib/script/mk-table-sync
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-table-sync
cp bin/mk-error-log blib/script/mk-error-log
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-error-log
cp bin/mk-slave-delay blib/script/mk-slave-delay
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-slave-delay
cp bin/mk-deadlock-logger blib/script/mk-deadlock-logger
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-deadlock-logger
cp bin/mk-query-advisor blib/script/mk-query-advisor
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-query-advisor
cp bin/mk-table-checksum blib/script/mk-table-checksum
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-table-checksum
cp bin/mk-archiver blib/script/mk-archiver
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-archiver
cp bin/mk-show-grants blib/script/mk-show-grants
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-show-grants
cp bin/mk-merge-mqd-results blib/script/mk-merge-mqd-results
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-merge-mqd-results
cp bin/mk-parallel-dump blib/script/mk-parallel-dump
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-parallel-dump
cp bin/mk-duplicate-key-checker blib/script/mk-duplicate-key-checker
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-duplicate-key-checker
cp bin/mk-checksum-filter blib/script/mk-checksum-filter
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-checksum-filter
cp bin/mk-visual-explain blib/script/mk-visual-explain
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-visual-explain
cp bin/mk-slave-restart blib/script/mk-slave-restart
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/mk-slave-restart
Manifying blib/man1/mk-slave-prefetch.1p
Manifying blib/man1/mk-query-profiler.1p
Manifying blib/man1/mk-profile-compact.1p
Manifying blib/man1/maatkit.1p
Manifying blib/man1/mk-log-player.1p
Manifying blib/man1/mk-slave-move.1p
Manifying blib/man1/mk-index-usage.1p
Manifying blib/man1/mk-purge-logs.1p
Manifying blib/man1/mk-upgrade.1p
Manifying blib/man1/mk-find.1p
Manifying blib/man1/mk-loadavg.1p
Manifying blib/man1/mk-heartbeat.1p
Manifying blib/man1/mk-variable-advisor.1p
Manifying blib/man1/mk-parallel-restore.1p
Manifying blib/man1/mk-slave-find.1p
Manifying blib/man1/mk-fifo-split.1p
Manifying blib/man1/mk-kill.1p
Manifying blib/man1/mk-query-digest.1p
Manifying blib/man1/mk-table-sync.1p
Manifying blib/man1/mk-error-log.1p
Manifying blib/man1/mk-slave-delay.1p
Manifying blib/man1/mk-deadlock-logger.1p
Manifying blib/man1/mk-query-advisor.1p
Manifying blib/man1/mk-table-checksum.1p
Manifying blib/man1/mk-archiver.1p
Manifying blib/man1/mk-show-grants.1p
Manifying blib/man1/mk-merge-mqd-results.1p
Manifying blib/man1/mk-parallel-dump.1p
Manifying blib/man1/mk-duplicate-key-checker.1p
Manifying blib/man1/mk-checksum-filter.1p
Manifying blib/man1/mk-visual-explain.1p
Manifying blib/man1/mk-slave-restart.1p

# make install
Installing /usr/lib/perl5/site_perl/5.8.8/maatkit.pod
Installing /usr/share/man/man1/mk-slave-delay.1p
Installing /usr/share/man/man1/mk-table-checksum.1p
Installing /usr/share/man/man1/mk-heartbeat.1p
Installing /usr/share/man/man1/mk-profile-compact.1p
Installing /usr/share/man/man1/mk-slave-prefetch.1p
Installing /usr/share/man/man1/mk-error-log.1p
Installing /usr/share/man/man1/mk-parallel-restore.1p
Installing /usr/share/man/man1/mk-purge-logs.1p
Installing /usr/share/man/man1/mk-visual-explain.1p
Installing /usr/share/man/man1/mk-loadavg.1p
Installing /usr/share/man/man1/mk-query-advisor.1p
Installing /usr/share/man/man1/mk-upgrade.1p
Installing /usr/share/man/man1/mk-log-player.1p
Installing /usr/share/man/man1/mk-table-sync.1p
Installing /usr/share/man/man1/mk-archiver.1p
Installing /usr/share/man/man1/mk-show-grants.1p
Installing /usr/share/man/man1/mk-checksum-filter.1p
Installing /usr/share/man/man1/mk-slave-move.1p
Installing /usr/share/man/man1/mk-index-usage.1p
Installing /usr/share/man/man1/mk-slave-restart.1p
Installing /usr/share/man/man1/mk-merge-mqd-results.1p
Installing /usr/share/man/man1/mk-query-digest.1p
Installing /usr/share/man/man1/mk-deadlock-logger.1p
Installing /usr/share/man/man1/mk-find.1p
Installing /usr/share/man/man1/mk-fifo-split.1p
Installing /usr/share/man/man1/mk-duplicate-key-checker.1p
Installing /usr/share/man/man1/mk-variable-advisor.1p
Installing /usr/share/man/man1/mk-query-profiler.1p
Installing /usr/share/man/man1/maatkit.1p
Installing /usr/share/man/man1/mk-kill.1p
Installing /usr/share/man/man1/mk-slave-find.1p
Installing /usr/share/man/man1/mk-parallel-dump.1p
Installing /usr/bin/mk-archiver
Installing /usr/bin/mk-query-advisor
Installing /usr/bin/mk-purge-logs
Installing /usr/bin/mk-fifo-split
Installing /usr/bin/mk-slave-move
Installing /usr/bin/mk-error-log
Installing /usr/bin/mk-duplicate-key-checker
Installing /usr/bin/mk-show-grants
Installing /usr/bin/mk-loadavg
Installing /usr/bin/mk-visual-explain
Installing /usr/bin/mk-table-sync
Installing /usr/bin/mk-merge-mqd-results
Installing /usr/bin/mk-find
Installing /usr/bin/mk-table-checksum
Installing /usr/bin/mk-deadlock-logger
Installing /usr/bin/mk-profile-compact
Installing /usr/bin/mk-upgrade
Installing /usr/bin/mk-query-digest
Installing /usr/bin/mk-kill
Installing /usr/bin/mk-query-profiler
Installing /usr/bin/mk-slave-delay
Installing /usr/bin/mk-variable-advisor
Installing /usr/bin/mk-slave-restart
Installing /usr/bin/mk-slave-find
Installing /usr/bin/mk-log-player
Installing /usr/bin/mk-heartbeat
Installing /usr/bin/mk-checksum-filter
Installing /usr/bin/mk-parallel-dump
Installing /usr/bin/mk-index-usage
Installing /usr/bin/mk-parallel-restore
Installing /usr/bin/mk-slave-prefetch
Writing /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/maatkit/.packlist
Appending installation info to /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/perllocal.pod

# mk-[tab]
mk-archiver mk-log-player mk-slave-find
mk-checksum-filter mk-merge-mqd-results mk-slave-move
mk-deadlock-logger mk-parallel-dump mk-slave-prefetch
mk-duplicate-key-checker mk-parallel-restore mk-slave-restart
mk-error-log mk-profile-compact mk-table-checksum
mk-fifo-split mk-purge-logs mk-table-sync
mk-find mk-query-advisor mk-upgrade
mk-heartbeat mk-query-digest mk-variable-advisor
mk-index-usage mk-query-profiler mk-visual-explain
mk-kill mk-show-grants
mk-loadavg mk-slave-delay

No comments:

Post a Comment