I’m returned from my 1-week vacation today and want to say - I’ve never been so productive as I was there Blue ocean, hot sun and white sand really helped me to finish my work on the first release of one really awesome project.

Today I’m proud to announce our first public release of the Data Recovery Toolkit for InnoDB - set of tools for checking InnoDB tablespaces and recovering data from damaged tablespaces or from dropped/truncated InnoDB tables.

This release already has a pretty decent set of features:

• Supports both REDUNDANT (pre mysql 5.0) and COMPACT (mysql 5.0+) versions of tablespaces
• Works with single tablespaces and file-per-table tablespaces
• Able to recover data even when processed InnoDB page has been reassigned …

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.

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

I have two ideas for hacking MySQL in a useful manner, in response to issues I've had using it:

InnoDB tablespace usage monitor

A really simple tool that would report the amount of innodb tablespace used by specific tables and, ideally, indexes too.

This is required as I'm fairly sure that there isn't a tool to do this at the moment.

MyISAM mmap() its index files

I'm having trouble tuning MyISAM's key_buffer for production use. We want to use delay_key_write to reduce the IO of a lot of inserts, but at the same time, I'd prefer it not to get too out of hand, as large flushes create a lot of I/O in one go.

Anyway perhaps that was a poor explanation of my motivation, however, the idea would be:

• 
  
• mmap() the whole of each index file when the table is opened.
  
• Leave the memory mapping in place …

As Peter mentioned in one of previous posts, we've done huge work developing robust strategies of InnoDB data recovery to provide our customers effective data recovery services and one of major parts of these strategies is our toolkit for InnoDB data recovery. Today I'm proud to announce its first public release which was used to help some of our customers to recover 95-100% of their deleted data.

This release already has a pretty decent set of features:

• Supports both REDUNDANT (pre mysql 5.0) and COMPACT (mysql 5.0+) versions of tablespaces
• Works with single tablespaces and file-per-table tablespaces
• Able to recover data even …

Have you ever wanted to know who’s the top committer in your company?
In my previous company we etablished the term “CVS King”, a title comparable to “Employee of the month”. The developer with the most cvs commits was the “CVS King of the month”. We determined who was the “CSV King” using commit emails that were sent to all developers on each cvs commit.
Two years ago we switched to Subversion, so now we’re talking about the “Subversion King”. Naturally all this is anything but serious ;)

Anyway, today i programmed a little php script that uses a different approach to determine who is the “Subversion King of the Month”. It’s counting the line delta directly from the svn repository using svnlook. So the developer with the most lines added to …

A while ago I asked for people and/or organizations to sponsor development on Maatkit (formerly MySQL Toolkit) so I could take a week off work and improve the Table Sync tool. I asked for $2500 USD, but several companies have graciously offered to cover that and then some.

I'm very happy about this, as it will allow me to dedicate a solid week to fixing bugs and adding features. There's a lot of demand for the tools, and there are a dozen or so bug reports unresolved for the table-sync tool, which I personally want to fix as much as anyone. So I'm very grateful for the support.

Here are the companies who have promised their financial support:

MySQL AB

…

foss.in, describes itself as India’s Premier FOSS Event. I’m excited to be participating in it, and am leaving to Bangalore this Saturday evening (01 December 2007).

Schedules are out, and I’m giving a talk on 07 December (Friday) from 11.30am - 1pm. The title is generally aptly titled, and a similar (shorter) talk is one I’ve submitted for the MySQL Conference & Expo 2008 titled “Paying it Forward: Harnessing the MySQL Contributory Resources”. I will tell you what we at MySQL have done to help increase external participation, to actually be more like an open source project, and so on. Since there will be plenty of time for Q&A, I hope to harness some collective knowledge and find ways in where we can improve some more (maybe help create a 2008 community roadmap).

You can still …

Ever have a good feeling about a release?

I just dropped version .11 of libmemcached onto the download servers. The library has been in production now at a number of sites for the last couple of versions, but I think that .11 should be the best of the bunch. The library has now a number of features:
Synchronous and Asynchronous support.
TCP and Unix Socket
A half dozen or so different hash algorithms
Implementations of the new cas, replace, and append operators
Man pages written up on the entire API.

http://tangent.org/552/libmemcached.html

I still have the UDP protocol to do, but other then that the basic library is at a good spot for doing development with. Looking at the calendar it has taken me about two months to make this happen (keep in mind that is not my day job).

Now to make …

A week ago, Mike Zinner and his team released the beta version of MySQL Workbench on http://dev.mysql.com/workbench/. MySQL Workbench is a visual database design tool that is developed by MySQL. It is the successor application of the DBDesigner4 project.

There are two different editions of MySQL Workbench at this point in time - an open source edition and a standard edition that is only available for paying customers.

This means that MySQL Workbench introduces a new concept for MySQL. Until now, MySQL products have either been open source or only available through a commercial subscription (such as MySQL Enterprise Monitor).

MySQL Workbench is …

In September, the Developer Zone featured Chapter 6 of Paul DuBois' MySQL, 3rd edition on Writing C Programs with the MySQL C API. This month, we continue in this series on developing MySQL applications in C with a tutorial from Mark Schoonover about using the Eclipse CDT (C Development Toolkit) as an IDE for developing C applications for MySQL.