1.perl

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.

2.编译安装mysql5.1.41.tar.gz

加载模块
# 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博客

Mysql管理必备工具maatkit(安装)

最新文章