Maatkit / News: Recent posts

This release is a bugfix and maintenance release. Many of the changes are minor tweaks to shared code. I've also partially moved to a new documentation system that will ensure the embedded documentation is authoritative and accurate.

Changelog for mk-archiver:

2008-06-02: version 1.0.9

* Updated common code.

Changelog for mk-deadlock-logger:

2008-06-02: version 1.0.10

* Generate command-line options from POD.... read more

Maatkit contains essential command-line utilities for MySQL, such as table checksums, a query profiler, and a visual EXPLAIN tool. It provides missing features such as checking whether slaves have the same data as the master.

Download:
http://sourceforge.net/project/showfiles.php?group_id=189154

This release contains minor bug fixes and new features.

Changelog for mk-heartbeat:

2008-02-10: version 1.0.7... read more

Maatkit 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.

Download:
http://sourceforge.net/project/showfiles.php?group_id=189154

This release contains bug fixes and new features. It also contains a new tool.

Changelog for mk-archiver:... read more

Maatkit 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.

Download:
http://sourceforge.net/project/showfiles.php?group_id=189154

This release contains bug fixes and new features.

Changelog for mk-archiver:

2008-01-05: version 1.0.6... read more

Maatkit (formerly MySQL 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.

Download:
http://sourceforge.net/project/showfiles.php?group_id=189154

This release contains bug fixes and new features.

Changelog for mk-heartbeat:... read more

Maatkit (formerly MySQL 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.

Download:
http://sourceforge.net/project/showfiles.php?group_id=189154

This release contains minor bug fixes and functionality changes, including some new debugging features in shared code.... read more

Maatkit (formerly MySQL 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.

Download:
http://sourceforge.net/project/showfiles.php?group_id=189154

This release is a complete rewrite of mk-table-sync. It also fixes several bugs with other tools.... read more

Maatkit (formerly MySQL 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.

Download:
http://sourceforge.net/project/showfiles.php?group_id=189154

This release fixes several minor bugs. It also renames all the tools to avoid trademark violation.... read more

This release is a significant update to MySQL Table Checksum (which will be renamed soon to avoid trademark violations):

2007-11-18: version 1.1.19

* Check for needed privileges on --replicate table before beginning.
* Made some error messages more informative.
* Fixed child process exit status with 8-bit right-shift.
* Improved checksumming code auto-detects best algorithm and function.
* Added --ignoreengine option; ignores federated and merge by default.
* Added --columns and --checksum options.
* Removed --chunkcol, --chunksize-exact, --index options.
* --chunksize can be specified as a data size now.
* Improved chunking algorithm handles more cases and uses fewer chunks.
* Do not print --replcheck results for servers that are not slaves.
* Create only one DB connection for each host, not one per host/tbl/chunk.
* Code assumed backtick quoting, broke on SQL_MODE=ANSI (bug #1813030).
* There were many potential bugs with database and table name quoting.
* Child exit status errors could be masked by subsequent successes.

MySQL Toolkit infringes on MySQL AB's trademark. The project's new name is Maatkit. I'll be updating links and other names as I find time and as I discover things that need to be updated.

MySQL 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.

Download:
http://sourceforge.net/project/showfiles.php?group_id=189154

This release of MySQL Toolkit fixes several bugs (mostly caused in the last release), and finishes the initial functionality for MySQL Parallel Dump and MySQL Parallel Restore.... read more

MySQL 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.

Download:
http://sourceforge.net/project/showfiles.php?group_id=189154

This release fixes some minor bugs. It also adds a few major new features to several of the tools. The command-line option and help functionality, as well as several other pieces of common functionality, has been replaced with common modules that have a test suite. This is the first step towards a gradual rewrite to replace untested 'script' code with tested, maintainable code.... read more

MySQL 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.

Download:
http://sourceforge.net/project/showfiles.php?group_id=189154

This release adds a new tool and makes minor changes to an existing tool.

Changelog for mysql-parallel-dump:... read more

MySQL 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.

Download:
http://sourceforge.net/project/showfiles.php?group_id=189154

This release of MySQL Toolkit updates MySQL Parallel Dump.

Changelog for mysql-parallel-dump:... read more

MySQL 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.

MySQL Toolkit version numbers are based on Subversion revision number. This release is the first past the 1,000-commit milestone. It also marks several days of being in Sourceforge's top 100 most active projects.... read more

MySQL 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.

This release of MySQL Toolkit fixes some minor bugs in mysql-heartbeat and mysql-find, and adds major new functionality to mysql-parallel-dump.

Download:

http://sourceforge.net/project/showfiles.php?group_id=189154 ... read more

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.

This release of MySQL Toolkit adds a new tool, and fixes some minor bugs.

Download:

http://sourceforge.net/project/showfiles.php?group_id=189154

Changelog for mysql-parallel-dump:... read more

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.

This release of MySQL Toolkit adds a new tool, fixes some minor bugs and adds new functionality (especially the ability to run as a daemon) to several of the tools.... read more

This release of MySQL Toolkit fixes some minor bugs and adds new functionality to four of the tools.

Changelog for mysql-duplicate-key-checker:

2007-09-01: version 1.1.0

* Column printout was misaligned one space.
* Refactored into a runnable module and added tests.
* Redundant indexes were only detected if the shorter index was first.
* Redundant foreign keys sometimes weren't detected.
* All indexes on MEMORY tables were reported as HASH.
* Added --clustered option to report appended PK columns as dupes for InnoDB and solidDB.... read more

MySQL Visual Explain is a unique tool that generates a tree view of MySQL's query execution plan from EXPLAIN output. This is significantly easier to understand than EXPLAIN.

MySQL Visual Explain is part of the MySQL Toolkit.

Homepage:

http:mysqltoolkit.sourceforge.net/

Download:

http://sourceforge.net/project/showfiles.php?group_id=189154

For bug reports, questions, or support use the tracker, mailing lists and forums:... read more

This release is mostly a documentation release, but several packages have significant bug fixes or functionality changes, and there is one new package. Here is a unified change log:

Changelog for mysql-archiver:

2007-06-22: version 0.9.3

Changes:
* Added more hooks for plugins before and after archiving.
* Documentation.
* Made --time suffix optional.

Bugs fixed:
* MySQL Archiver could crash on a lock wait timeout when --txnsize was not set... read more

Now you can get the newest version of all tools with one download. Just choose the most recent version of the mysqltoolkit package.

I will be releasing Debian files soon, and possibly other Linux distributions as well. This will also make it reasonable for packagers to keep up with MySQL Toolkit without making many packages, so perhaps it will now find its way into FreeBSD and other operating systems.

I have released new versions of all packages. Part of the reason was a change in the way I version packages, but there are also some bug fixes and feature additions. Here is a unified changelog:

mysql-show-grants
2007-06-10: version 1.0.1

* Added --defaults-file option.
* Added standard --version command-line option.
* Added --defaults-file option.

mysql-find
2007-06-10: version 0.9.2

* --pid had a race condition.
* Unrecognized --sprintf directives could cause crashes.
* Added --defaults-file option.
* Added standard --version command-line option. ... read more

This release fixes some minor bugs and adds plugin capability. Now you can extend MySQL Archiver with your own code easily, without touching MySQL Archiver's code. You can use this to run setup and tear-down, hook code into the archiving process, and more. Possibilities include using this to build a data warehouse during archiving, or applying advanced logic to determine which rows to archive.

2007-06-09: version 0.9.2... read more

This is the initial (re)release of a new tool for archiving and purging OLTP tables to file and/or to another table. This tool implements the archiving strategy I described at http://www.xaprb.com/blog/2006/05/02/how-to-write-efficient-archiving-and-purging-jobs-in-sql/.

This release fixes a bug in query WHERE clauses in the original release, which could cause the wrong data to be archived.

Download:
http://sourceforge.net/project/showfiles.php?group_id=189154