Mysql管理必備工具maatkit(安裝)

This is perl, v5.8.8 built for x86_64-linux-thread-multi

Copyright 1987-2006, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl".  If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.

載入模組
# vi /etc/ld.so.conf
/opt/app/mysql5/lib/mysql
# ldconfig

3.DBI安裝

tar zxf DBI-1.58.tar.gz

cd DBI-1.58

perl Makefile.pl

make

make test

make

make install

4.安裝data-showtable

tar -zxvf Data-ShowTable-3.3.tar.gz

cd Data-ShowTable-3.3

perl Makefile.PL

make

make install

5.安裝msql-mysql-modules

cd MMsql-Mysql-modules-1.2219

perl Makefile.PL

在 "perl Makefile.PL" 期間，會向你提出一些問題。特別是你必須選擇安裝驅動器(MySQL, mSQL2 and/or mSQL1)。MySQL驅動程式叫
 
DBD::mysql，單獨的mSQL驅動程式叫DBD::mSQL。如果你想支援mSQL1和mSQL2，用DBD::mSQL1。

make

make test

make install

6.安裝DBD-mysql

安裝DBD: DBD-mysql-4.005

然後再重新安裝DBD: DBD-mysql-4.005

perl Makefile.PL --mysql_config=/opt/app/mysql5/bin/mysql_config

make

make test

make install

7.安裝maatkit

tar zxvf   maatkit-2325.tar.gz

cd maatkit-2325

perl Makefile.PL

make install

[root@linux-mysql bin]# ls mk-*
mk-archiver               mk-loadavg           mk-slave-find
mk-audit                  mk-log-player        mk-slave-move
mk-checksum-filter        mk-parallel-dump     mk-slave-prefetch
mk-deadlock-logger        mk-parallel-restore  mk-slave-restart
mk-duplicate-key-checker  mk-profile-compact   mk-table-checksum
mk-fifo-split             mk-query-digest      mk-table-sync
mk-find                   mk-query-profiler    mk-upgrade
mk-heartbeat              mk-show-grants       mk-visual-explain
mk-kill                   mk-slave-delay

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/15456724/viewspace-631663/，如需轉載，請註明出處，否則將追究法律責任。