Jump to content

Maatkit: Difference between revisions

From Wikipedia, the free encyclopedia
Content deleted Content added
Notability? Removed second-person address
 
(19 intermediate revisions by 12 users not shown)
Line 1: Line 1:
<!-- Please do not remove or change this AfD message until the discussion has been closed. -->
{{AfDM|page=Maatkit (2nd nomination)|year=2024|month=November|day=29|substed=yes|origtag=afdx|help=off}}
<!-- End of AfD message, feel free to edit beyond this point -->
{{Notability|date=January 2022}}
'''Maatkit''' was a toolkit for development and administration of [[open-source]] [[databases]].<ref>[http://www.admin-magazine.com/Archive/2010/02/Maatkit-tools-for-database-administrators Maatkit Tools for Database Administrators] (ADMIN Magazine)</ref> Most of Maatkit’s functionality was designed for [[MySQL]], but it also supported [[PostgreSQL]] and other databases. It has been discontinued and merged into the [[Percona Toolkit]] as of 2011.<ref>* [http://www.mysqlperformanceblog.com/2011/09/07/percona-toolkit-1-0-1-released/ Percona Toolkit 1.0.1 release announcement]</ref>


==References==
{{notability}}
{{reflist}}
{{Infobox Software
| name = Maatkit
| developer = [[Baron Schwartz]]
| programming language = [[Perl]]
| operating_system= [[Cross-platform]]
| genre = [[Database Administration]]
| license = [[GPL]], [[Artistic License]]
| website = [http://www.maatkit.org/ www.maatkit.org]
}}
{{Portal|Free software}}
'''Maatkit''' is a toolkit for users, developers, and administrators of [[MySQL]] an open-source database. All tools are standalone, with minimal dependencies and no need for installation. It is claimed to make MySQL easier and safer to manage. Maatkit can be used to prove replication is working correctly, fix corrupted data, automate repetitive tasks, speed up your servers, and much more.

Maatkit now ships by default with several [[GNU/Linux]] distributions such as [[CentOS]] and [[Debian]] and packages are available for [[Fedora (operating system)|Fedora]] and [[Ubuntu (operating system)|Ubuntu]] as well.

Although most of Maatkit’s functionality is designed for MySQL, there is also support for [[PostgreSQL]] and [[Memcached]] (e.g. mk-query-digest).

As of late 2011, Maatkit is no longer developed, but Percona has continued development under the Percona Toolkit name.

==Included tools==
* mk-archiver Archive rows from a MySQL table into another table or a file.
* mk-checksum-filter Filter checksums from mk-table-checksum.
* mk-deadlock-logger Extract and log MySQL deadlock information.
* mk-duplicate-key-checker Find duplicate indexes and foreign keys on MySQL tables.
* mk-error-log Find new and different MySQL error log entries.
* 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-index-usage Read queries from a log and analyze how they use indexes.
* mk-kill Kill MySQL queries that match certain criteria.
* mk-loadavg Watch MySQL load and take action when it gets too high.
* mk-log-player Split and play MySQL slow logs.
* mk-merge-mqd-results Merge multiple mk-query-digest reports into one.
* mk-parallel-dump Dump MySQL tables in parallel.
* mk-parallel-restore Load files into MySQL in parallel.
* mk-profile-compact Compact the output from mk-query-profiler.
* mk-purge-logs Purge binary logs on a master based on purge rules.
* mk-query-digest Parses logs and more. Analyze, transform, filter, review and report on queries for MySQL, PostgreSQL, and memcached.
* 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 and print replication hierarchy tree of MySQL slaves.
* 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-upgrade Execute queries on multiple servers and check for differences.
* mk-visual-explain Format EXPLAIN output as a tree.


== External links ==
== External links ==
* [http://www.maatkit.org/ Official website]
* {{Official website|https://web.archive.org/web/20120103132321/http://www.maatkit.org/}}
* [http://packages.debian.org/search?searchon=sourcenames&keywords=maatkit Official Debian packages]
* [http://packages.debian.org/search?searchon=sourcenames&keywords=maatkit Official Debian packages]

* [http://www.admin-magazine.com/content/maatkit-tools-database-administrators Maatkit Tools for Database Administrators] (ADMIN Magazine)
* [http://www.mysqlperformanceblog.com/2011/09/07/percona-toolkit-1-0-1-released/ Percona Toolkit 1.0.1 release announcement]
[[Category:Free database management systems]]
[[Category:Free database management systems]]
[[Category:Discontinued software]]

{{database-stub}}

Latest revision as of 09:37, 29 November 2024

Maatkit was a toolkit for development and administration of open-source databases.[1] Most of Maatkit’s functionality was designed for MySQL, but it also supported PostgreSQL and other databases. It has been discontinued and merged into the Percona Toolkit as of 2011.[2]

References

[edit]
[edit]