Maatkit is a collection of essential command-line utilities for MySQL:
*Table Checksum* checks whether tables have the same data, ie check slaves for consistency with the master.
*Table Sync* efficiently finds/resolves differences between two tables.
*Show Grants* helps extract, compare, change, synchronize, and version control user privileges.
*Slave Restart* monitors a replication slave for errors and tries to restart it.
*Slave Delay* implements delayed replication.
*Find* is the MySQL counterpart to the UNIX ‘find’ command, for table metadata.
*Duplicate Key Checker* checks for whole or partial key duplication.
*Archiver* helps purge stale data.
also:
*Deadlock Logger*
*Query Profiler*
*Parallel Dump*
*Parallel Restore*
*Heartbeat*
*Visual Explain*
See homepage for more info
Updated 19 Jul 2008 08:47 UTC
Based on 3 user ratings.
Click to rate this project.
No links submitted so far. Submit your own links.
Percona is looking to hire someone to develop Maatkit, among other things.
If I weren’t having so much fun being the consulting team lead, I’d be doing it myself. (In fact, I’m still hacking on it a lot. Got some pretty fun stuff done this weekend.) I don’t know what the rest of [...]
Download Maatkit
Before I tell you what’s new, let me tell you how cool I think it would be if Maatkit were voted Sourceforge.net project of the year. Just something to think about :-) I suggest the “Best Tool or Utility for SysAdmins” category. You can actually click the Back button and nominate [...]
I have been using Maatkit in a different way since I joined Percona as a consultant. When I’m working on a system now, it’s a new, unfamiliar system — not one where I have already installed my favorite programs. And that means I want to grab my favorite productivity tools fast.
I intentionally wrote [...]
At least one person (Karanbir Singh) is working to get Maatkit into the CentOS repositories, and I believe there might be movement towards RHEL also. From an email to the Maatkit discussion list a little while ago,
I am in the process of getting maatkit into the CentOS-Extras
repositories. The first step for that is that [...]
Today is the first day at the conference (aside from the tutorials, which were yesterday). Here’s what I went to:
New Subquery Optimizations in 6.0
By Sergey Petrunia. This was a similar session to one I went to last year. MySQL has a few cases where subqueries are badly optimized, and this session went [...]
Project Cost |
|
|---|---|
| This calculator estimates how much it would cost to hire a team to write this project from scratch. More » | |
| Include | |
| Codebase | 52,597 |
| Effort (est.) | 13 Person Years |
| Avg. Salary | $ year |
| $ 705,345 | |