There was a small bug in the dbt2-0.37.36 version I uploaded which
I have now fixed in the new dbt2-0.37.37 version.

There has also been some interesting benchmark tests done where
we have run DBT2 on a T5220 box (Niagara II chips). We can show
the scalable performance benefits here as well. We've been able
to run with 20 data nodes on 1 box (these boxes can run up to
64 threads at a time) with scalable performance increase from
4 nodes.

We had a developer meeting a few weeks ago and there were lots of
activities. Personally I had most fun seeing the demo of
Parallel ALTER TABLE. We loaded a table with 10 million 70-80 byte
rows. We had access to a machine with 64 GB of memory and
16 cores. It was very interesting to run one SQL command and
see the load in top of mysqld go to 1600%. Altering a 10 million
row table in 2.5 seconds I …

I thought I'd share a note I sent earlier in the week to Sun's leaders - about the turmoil we're seeing in the markets, and how I want our team focusing their efforts.

_______________________________________________________________________________

Begin forwarded message:
From: Jonathan Schwartz
Date: September 30, 2008 12:02:29 AM PDT
To: All Sun
Subject: Headlines, Financial Crisis, etc.

You can't have missed today's headlines - the American Congress failed to pass a critical bill authorizing the Treasury to put a floor under the US banking sector. The market swooned, and politicians in the US, and across the world, are bickering over the right long term answer - jump in and take action to save the troubled institutions, or step aside and …

One of the nice things about MySQL PS, is that there is no pressure on us at all to "upsell", to pitch additional products and services to our clients for the purpose of adding to our bottom line.

One of the big fears with being bought by Sun is that Sun will start "encouraging" us to start pushing Sun's hardware and proprietary software, but that threat has not yet materialized.

On the other hand, on the last 3 gigs, I have sold a handful of copies of High Performance MySQL, and probably three tickets to the O'Reilly MySQL Conference.

Maybe O'Reilly should be paying me a kickback. :)

It may be rather obvious to some folks that I’ve been doing a lot of work on Drizzle since Brian released it. The great news is that my employer thinks this is a good thing, and is actually now paying me to work on Drizzle as a day job.

So as of yesterday I am no longer a member of the MySQL Professional Services team, and instead will be sitting on my couch all day annoying my wife and hacking on Drizzle.

The last three years I’ve been a consultant for MySQL have been wonderful. I’ve gotten to work with a whole load of bright people and many of the big exciting shops and large projects out there. I’ve also done some work with companies not much bigger than 2 or 3 people. I can truthfully say there is an almost never ending supply of interesting things people are trying.

At the same time, I can’t tell you about most of them, which is the downside to being a consultant. There are many upsides, …

We’re migrating from MySQL 4.1.x to 5.0.x at work and one of the key features we need is the ability to freeze InnoDB and prevent it from writing to disk.

We do this to aid in syncing masters and slaves and performing backups.

Basically we freeze a master, copy the data to a new slave, unfreeze the master, bring up the new slave, and then setup replication to start from right after we froze the master.

It’s MUCH faster than performing a mysqldump (20x faster). A mysqldump tends to both do a ton of random seeks on disk as well as burn up a single core.

This type of ‘innodb hot copy’ is only bottlenecked on disk and gigabit ethernet IO.

In theory you can sync at 125MB/s…

David ended up spending the time to isolate, test, and retarget the patch for various MySQL versions.

One of the (many) ongoing discussions in the Drizzle developer community is the level of support the database server kernel should provide for non-Unicode character set encodings. Actually, when I say non-Unicode, I actually mean non-UTF8, since we've stripped out all other character sets and "standardized" on 4-byte UTF8. I'll come back to why exactly I put standardized in quotes in just a bit...but to sum up, in childish terms, my thoughts after spending 4 hours tonight reading about character sets and collations, here is an exchange between Toru and myself on Freenode #drizzle:

<jaypipes> tmaesaka: how do you write "I wish everyone would just speak English" in …

Wow!

I just read Martin "MC" Brown's blog announcing that a number of chapters are now available online for preview.

Personally, I think this is a good move. I think the online chapters provide a nice insight what the book is like. I can ensure you that there is lots and lots more to see in the other chapters. I can honestly and without reservation recommend this book to everybody that wants to read a recent reference book on MySQL Cluster, and those that want to obtain the 5.1 Cluster DBA certification exam in particular.

Now it must be noted that I am a co-author for this book, and author of the MySQL 5.1 Cluster DBA exam so my …

There are still a few impediments, but the database group …

Well, as Giuseppe announced, I am leaving the MySQL Community Team after almost three years. I'll still be working at Sun, but as a staff engineer on the Drizzle project in the Sun CTO organization. We are looking for someone to pick up the reins in the North American MySQL community and assume the role as Community Relations manager. Interested? Get in touch with Giuseppe or myself after reading his article about the requirements of the job.

I should add that candidates should be advised about Giuseppe. As your team lead, he may subject you such horrors as excellent project and managerial skills, a kind and encouraging shoulder on which to vent, and a deep, heartfelt connection with open source and community issues. In addition, you can look forward to working with …

The MySQL Community Team is about to lose a valuable member. In a few weeks, Jay Pipes, Community Relations Manager for North America, is joining the Drizzle project, under a different organization within Sun, and he won't be much available for MySQL community matters anymore.

On one hand, I am glad for Jay. He has been craving for more technical work, and he happily jumped at the offer from the Drizzle team. On the other hand, I have now the hard task of finding a worthy replacement. It won't be easy. For several years we have taken Jay's presence for granted, and he has done incredibly remarkable things, like creating MySQL Forge (v1 and v2) and organizing two MySQL Users Conferences and two MySQL Camps.

So, here I am, shouting to the world my need for a new manager. What am I looking for? What makes a good Community Relations Manager? …