mysql管理必备工具_Mysql管理必备工具maatkit(安装)

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.gzcd DBI-1.58perl Makefile.plmakemake testmakemake install

4.安装data-showtable

tar -zxvf Data-ShowTable-3.3.tar.gzcd Data-ShowTable-3.3perl Makefile.PLmakemake install

5.安装msql-mysql-modules

cd MMsql-Mysql-modules-1.2219perl Makefile.PL在 "perl Makefile.PL" 期间，会向你提出一些问题。特别是你必须选择安装驱动器(MySQL, mSQL2 and/or mSQL1)。MySQL驱动程序叫

DBD::mysql，单独的mSQL驱动程序叫DBD::mSQL。如果你想支持mSQL1和mSQL2，用DBD::mSQL1。makemake testmake install

6.安装DBD-mysql

安装DBD: DBD-mysql-4.005然后再重新安装DBD: DBD-mysql-4.005perl Makefile.PL --mysql_config=/opt/app/mysql5/bin/mysql_configmakemake testmake install

7.安装maatkit

tar zxvf maatkit-2325.tar.gzcd maatkit-2325perl Makefile.PLmake 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