How To Install maatkit on Fedora 34

maatkit is Essential command-line utilities for MySQL

Introduction

In this tutorial we learn how to install maatkit on Fedora 34.

What is maatkit

This toolkit contains essential command-line utilities for MySQL, such as a table checksum tool and query profiler. It provides missing features such as checking slaves for data consistency, with emphasis on quality and scriptability.

We can use yum or dnf to install maatkit on Fedora 34. In this tutorial we discuss both methods but you only need to choose one of method to install maatkit.

Install maatkit on Fedora 34 Using dnf

Update yum database with dnf using the following command.

sudo dnf makecache --refresh

The output should look something like this:

Fedora 34 - x86_64                               20 kB/s | 6.6 kB     00:00
Fedora 34 openh264 (From Cisco) - x86_64        1.4 kB/s | 989  B     00:00
Fedora Modular 34 - x86_64                       68 kB/s | 6.5 kB     00:00
Fedora 34 - x86_64 - Updates                    3.5 kB/s | 6.2 kB     00:01
Fedora Modular 34 - x86_64 - Updates             17 kB/s | 5.9 kB     00:00
Metadata cache created.

After updating yum database, We can install maatkit using dnf by running the following command:

sudo dnf -y install maatkit

Install maatkit on Fedora 34 Using yum

Update yum database with yum using the following command.

sudo yum makecache --refresh

The output should look something like this:

Fedora 34 - x86_64                               20 kB/s | 6.6 kB     00:00
Fedora 34 openh264 (From Cisco) - x86_64        1.4 kB/s | 989  B     00:00
Fedora Modular 34 - x86_64                       68 kB/s | 6.5 kB     00:00
Fedora 34 - x86_64 - Updates                    3.5 kB/s | 6.2 kB     00:01
Fedora Modular 34 - x86_64 - Updates             17 kB/s | 5.9 kB     00:00
Metadata cache created.

After updating yum database, We can install maatkit using yum by running the following command:

sudo yum -y install maatkit

How To Uninstall maatkit on Fedora 34

To uninstall only the maatkit package we can use the following command:

sudo dnf remove maatkit

maatkit Package Contents on Fedora 34

/usr/bin/mk-archiver
/usr/bin/mk-checksum-filter
/usr/bin/mk-config-diff
/usr/bin/mk-deadlock-logger
/usr/bin/mk-duplicate-key-checker
/usr/bin/mk-error-log
/usr/bin/mk-fifo-split
/usr/bin/mk-find
/usr/bin/mk-heartbeat
/usr/bin/mk-index-usage
/usr/bin/mk-kill
/usr/bin/mk-loadavg
/usr/bin/mk-log-player
/usr/bin/mk-merge-mqd-results
/usr/bin/mk-parallel-dump
/usr/bin/mk-parallel-restore
/usr/bin/mk-profile-compact
/usr/bin/mk-purge-logs
/usr/bin/mk-query-advisor
/usr/bin/mk-query-digest
/usr/bin/mk-query-profiler
/usr/bin/mk-show-grants
/usr/bin/mk-slave-delay
/usr/bin/mk-slave-find
/usr/bin/mk-slave-move
/usr/bin/mk-slave-prefetch
/usr/bin/mk-slave-restart
/usr/bin/mk-table-checksum
/usr/bin/mk-table-sync
/usr/bin/mk-table-usage
/usr/bin/mk-tcp-model
/usr/bin/mk-upgrade
/usr/bin/mk-variable-advisor
/usr/bin/mk-visual-explain
/usr/share/doc/maatkit
/usr/share/doc/maatkit/COPYING
/usr/share/doc/maatkit/Changelog
/usr/share/doc/maatkit/INSTALL
/usr/share/man/man1/maatkit.1p.gz
/usr/share/man/man1/mk-archiver.1p.gz
/usr/share/man/man1/mk-checksum-filter.1p.gz
/usr/share/man/man1/mk-config-diff.1p.gz
/usr/share/man/man1/mk-deadlock-logger.1p.gz
/usr/share/man/man1/mk-duplicate-key-checker.1p.gz
/usr/share/man/man1/mk-error-log.1p.gz
/usr/share/man/man1/mk-fifo-split.1p.gz
/usr/share/man/man1/mk-find.1p.gz
/usr/share/man/man1/mk-heartbeat.1p.gz
/usr/share/man/man1/mk-index-usage.1p.gz
/usr/share/man/man1/mk-kill.1p.gz
/usr/share/man/man1/mk-loadavg.1p.gz
/usr/share/man/man1/mk-log-player.1p.gz
/usr/share/man/man1/mk-merge-mqd-results.1p.gz
/usr/share/man/man1/mk-parallel-dump.1p.gz
/usr/share/man/man1/mk-parallel-restore.1p.gz
/usr/share/man/man1/mk-profile-compact.1p.gz
/usr/share/man/man1/mk-purge-logs.1p.gz
/usr/share/man/man1/mk-query-advisor.1p.gz
/usr/share/man/man1/mk-query-digest.1p.gz
/usr/share/man/man1/mk-query-profiler.1p.gz
/usr/share/man/man1/mk-show-grants.1p.gz
/usr/share/man/man1/mk-slave-delay.1p.gz
/usr/share/man/man1/mk-slave-find.1p.gz
/usr/share/man/man1/mk-slave-move.1p.gz
/usr/share/man/man1/mk-slave-prefetch.1p.gz
/usr/share/man/man1/mk-slave-restart.1p.gz
/usr/share/man/man1/mk-table-checksum.1p.gz
/usr/share/man/man1/mk-table-sync.1p.gz
/usr/share/man/man1/mk-table-usage.1p.gz
/usr/share/man/man1/mk-tcp-model.1p.gz
/usr/share/man/man1/mk-upgrade.1p.gz
/usr/share/man/man1/mk-variable-advisor.1p.gz
/usr/share/man/man1/mk-visual-explain.1p.gz
/usr/share/perl5/vendor_perl/maatkit.pod

References

Summary

In this tutorial we learn how to install maatkit on Fedora 34 using yum and dnf.