Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "installation and introduction of maatkit in Mysql". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Maatkit is a baron.schwartz-led, open source Mysql tool that provides a lot of features that Mysql officially does not implement. Greatly facilitate and strengthen the monitoring and management of Mysql. The following is a brief introduction to installation and use.

Official website: http://www.maatkit.org/

Document address: http://maatkit.sourceforge.net/doc/maatkit.html

Google home page and download: http://code.google.com/p/maatkit/

Installation is very simple, such as I downloaded maatkit-2725.zip, after the release of the entire folder to the server, for the software environment requirements, generally are DBD::mysql and DBI, of course, without perl. It takes only a few commands to install:

# cd maatkit-2725/

# perl Makefile.PL

# make

# make install

You can use it. Here are some useful features.

1. A tool for mk-table-checksum to check whether the master-slave tables are consistent and valid.

2. Mk-table-sync tools that make tables consistent can ensure consistency without having to overload slave tables.

3. Mk-visual-explain exlpain interpretation tool

4. Mk-heartbeat master-slave synchronization monitoring tool, which can give how much the slave lags behind the master.

5. Mysqldump tools for mk-parallel-dump multithreading

6. Mk-parallel-restore multithreaded table repair tool

7. Mk-query-profiler query detection and analysis tool

8. Recording tool for mk-deadlock-logger deadlock

9. Mk-duplicate-key-checker key detection tools

10. Mk-show-grants Rights Management display tool

11. Mk-slave-restart slave detection and restart tools

12. Tools for mk-slave-delay slave delay replication

Mk-archiver Archive rows from a MySQL table into another table or a file.

Mk-audit Analyze, summarize and report on MySQL config, schema and operation

Mk-checksum-filter Filter checksums from mk-table-checksum.

Mk-deadlock-logger Extract and log MySQL deadlock information.

Mk-duplicate-key-checker Find possible duplicate indexes and foreign keys on MySQL tables.

Mk-fifo-split Split files and pipe lines to a fifo without really splitting.

Mk-find Find MySQL tables and execute actions, like GNU find.

Mk-heartbeat Monitor MySQL replication delay.

Mk-log-parser Analyze and review MySQL logs.

Mk-log-player Split and play MySQL slow logs.

Mk-log-server Serve MySQL binary logs.

Mk-parallel-dump Dump sets of MySQL tables in parallel.

Mk-parallel-restore Load files into MySQL in parallel.

Mk-profile-compact Compact the output from mk-query-profiler.

Mk-query-profiler Execute SQL statements and print statistics, or measure activity caused by other processes.

Mk-show-grants Canonicalize and print MySQL grants so you can effectively replicate, compare and version-control them.

Mk-slave-delay Make a MySQL slave server lag behind its master.

Mk-slave-find Find MySQL replication slaves and execute commands on them.

Mk-slave-move Move a MySQL slave around in the replication hierarchy.

Mk-slave-prefetch Pipeline relay logs on a MySQL slave to pre-warm caches.

Mk-slave-restart Watch and restart MySQL replication after errors.

Mk-table-checksum Perform an online replication consistency check, or checksum MySQL tables efficiently on one or many servers.

Mk-table-sync Synchronize MySQL tables efficiently.

Mk-visual-explain Format EXPLAIN output as a tree.

This is the end of the introduction to the installation and introduction of maatkit in Mysql. Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.