mysqlsla v1.8 is available at:
http://hackmysql.com/scripts/mysqlsla-1.8-DEBUG
I am releasing it publicly without updating the mysqlsla web page or documentation because, instead, I am waiting until I finish mysqlsla v2. After working with v1.8 I realized the code needed a major re-think and overhaul. v2 will reflect this and will be a far superior log hacking and analyzing tool, capable of far more than v1.8 is now.

But for now, 1.8 fixes several good (or bad?) bugs:

• –only-hosts did not work for general logs
• Multi-line comments using /* */ caused everything after the first line to be ignored in raw logs
• “Change user” commands were not handled in general logs
• CHANGE, DROP and RESET statements were filtered out
• A certain variant of the Connect command in general logs was not handled
• A few …

The "2008 MySQL Conference and Expo" previously known as the "MySQL Users Conference" is over and I finally have time to blog.

What I really like with the MySQL conference is that it shows the loyalty that MySQL has from it's users and community. Year after year I get the change to meet the same friendly (!) faces and every year the group grows notable bigger (more than 2000 attendees this year). It really feels amazing for me to that I have had a small share in making this happen!

A lot of things happened during the conference, some good, some bad and some ugly.

Lets start with the bad parts and then go to the good stuff.

The Ugly

The ugly part was of course the announcement that MySQL was planning to change the MySQL server from open source/free software to crippleware by only giving out key parts of MySQL online backup (a server component) as closed source within the …

The Users Conference 2008 is over.

Had a quiet day in Monterey with Jay and Beat, where we enjoyed a few hours of walking in the woods and some spectacular views, like these baby seals.

Back at the hotel, it was business as usual, where coders and beers coexist peacefully.

Thanks to the attendees, and thanks Jay Pipes for another splendid performance!

It’s very weird having mail arrive at different times… e.g. when in the US, it’s less likely for some peolpe to mail you in the middle of the night US time.

Back home… common to get response between local time 2-5am… which is rather not 2-5am their local time.

But my habit of pulling mail in the morning after having done so late at night…. hard to break.

If you fetch the latest snapshot you'll find the code has been relicensed under BSD.

Huh. Wonder what you could do with that :)

If you fetch the latest snapshot you'll find the code has been relicensed under BSD.

Huh. Wonder what you could do with that :)

Keith Murphy and his hard-working crew have released the spring 2008 issue of MySQL Magazine. Go take a look — it includes quite a few articles on various topics, even a mention of our upcoming book (High Performance MySQL, Second Edition).

Keith Murphy, mysql, MySQL Magazine

Here’s a rundown of Thursday (day 3) of the MySQL Conference and Expo. This day’s sessions were much more interesting to me than Wednesday’s, and in fact I wanted to go to several of them in a single time slot a couple of times.

Inside the PBXT Storage Engine

This session was, as it sounds, a look at the internals of PBXT, a transactional storage engine for MySQL that has some interesting design techniques. I had been looking forward to this session for a while, and Paul McCullagh’s nice explanations with clear diagrams were a welcome aid to understanding how PBXT works. Unlike some of the other storage engines, PBXT is being developed in full daylight, with an emphasis on community involvement and input. (Indeed, I may be contributing to it myself, in order to make its monitoring and tuning capabilities second to none).

PBXT has not only a unique design, but a …

MySQL will be in Beijing, China, this week. Well, not MySQL per se, but I will be there. As will Kaj Arno. I arrive on 21 April 2008 and depart on 24 April 2008. I expect to be busy during the days, but my nights should be free. Drop me email at colinATmysqlDOTcom if you’d like to catch up.

There’s an event, on the 23rd of April as well. Its part of the Sun-MySQL World Tour. You definitely should be there, I’m sure there will be some nice schwag involved as well :)

Sitting in San Francisco, getting a little bored before my flight to Beijing. And Twitter is down, for 1.5 hours, for what they seem to call database maintenance. Wonder why. At least there’s IRC…

Technorati Tags: beijing, …

What made Marie Digby? I’ve heard about her on the radio from time to time, while I do the unnatural act of driving somewhere. Now, I’ve been invited to an event, where the tagline says that she’s “a star born from YouTube”. I had to dig further.

Decided to watch the famous video. Its just her, sitting with her guitar, performing an acoustic version of Rihana’s Umbrella. Nothing fancy. I’m told she sat in front of her MacBook to make the “hit”.

Grassroots marketing? Bands try much harder, and still feel the pain of becoming somewhat famous. What makes her different? Beauty (she’s of Japanese-American heritage)? Sultry look?

I wonder what her tipping point was. …