At today's keynote by Mark Callaghan one of the new options he talked about are table change logs. He mentioned they might be of use to external applications, like Flexviews, which he mentioned but not directly. He asked if the guy who wrote it was in the audience, so I got to wave my hand and yell 'Flexviews!'.

I caught up with Mark at the Facebook party this evening. I had a chance to talk to him not only about the change logs, but also about Kickfire and the SQL chip. He asked me what I thought about working at Kickfire and I smiled and said I love it. I think I said "I've never been able to join a billion row table to a hundred million row table, sort, group and get results back in less than a minute" and I'm sure the smile never left my face.

As far as the table change logs, he verified:

• 
  
• The global transaction id will be stored in the table
  
• OLD and NEW …

I presented on Creating Quick and Powerful Web Applications with MySQL, GlassFish, and NetBeans. The key messages conveyed during the preso are:

• GlassFish is an open source community and delivers production-quality Java EE compliant Application Server.
• GlassFish v2 is the Java EE 5 Reference Implementation and GlassFish v3 for Java EE 6. Read complete difference here.
• Java Persistence API makes it really easy to create database-backed Web applications. It even creates MySQL-specific queries, when possible.
• The web-based administration …

I presented on Creating Quick and Powerful Web Applications with MySQL, GlassFish, and NetBeans. The key messages conveyed during the preso are:

• GlassFish is an open source community and delivers production-quality Java EE compliant Application Server.
• GlassFish v2 is the Java EE 5 Reference Implementation and GlassFish v3 for Java EE 6. Read complete difference here.
• Java Persistence API makes it really easy to create database-backed Web applications. It even creates MySQL-specific queries, when possible.
• The web-based administration …

I had the pleasure of having a quick video interview with Chuck Hagenbuch and Leigh Heyman, both from Blue State Digital, and people that helped run the my.barackobama.com campaign. They’re giving the closing keynote at the MySQL Conference & Expo 2009 alongside three engineers from Google, and its going to be great.

If you missed the embed, here’s the video. Don’t forget to see them, at their closing keynote titled Database We Can Believe In: Stories from the Front Lines (and Server Rooms) of Barack Obama’s Online Presidential Campaign.

…

All the sessions for all the MySQL Camp days can be seen at, but here is today’s schedule in a nutshell (all sessions in Bayshore, on the mezzanine level of the hotel):

Tuesday 10:50 am - 11:35 pm

Matt Yonkovit (Sun/MySQL, Waffle Grid, Big DBA Head, [blog]) presents Learning from others’ MySQL Performance Mistakes. Matt has spent the last couple of years helping customers who are all dealing with the same MySQL related problems over and over again. During this session he will give you some of the most common issues in MySQL deployments he sees on a day to day basis, and how to fix or avoid them. These include:

* More is not always better
* Text Fields are not cool
* Data Size does matter
* Fun with Data Conversions
* Its all about IO
* Left join love
* Self Induced fragmentations
* MySQL is not Oracle

and more!!!! …

Today, for me is day 1 of the MySQL Confernece & Expo 2009. It seems to be going pretty well - and its only 2.45pm.

If you follow Planet MySQL, or happen to just have random conversations with people, the main buzz for the day is “Oracle buying Sun”. But let me not bore you with that. I just want to log some of my interesting conversations.

Over lunch I had a good discussion with users of MySQL, and one potential user of MySQL (his company uses Oracle, MS SQL Server, Sybase, and are now looking at MySQL). We talked about quite a number of things:

• The documentation (which I, and the rest of the MySQL users use) seems to not be complete for an Oracle person. Why? It seems we’re missing out on things like the models. We lack enough theory. People would like to “see” (visually) what the InnoDB buffer pool does, not just read about it. In fact, it also seems like we might need to be clearer with the use of …

oracle!

While everyone is sleeping and preparing for four busy days of MySQL Conference, here, in Santa Clara – I started getting SMSes asking if I already learnt PL/SQL, and here, I’m jetlagged, and finding out that I work for another company.

If they don’t kill MySQL, InnoDB and MySQL will finally be together.

If they kill MySQL, I’ll have to look for a job. Will anyone use MySQL then, or will I have to fall back to more generic non-MySQL work I’ve been doing for my hobby projects, teeeheeee.

And for now, I see 6AM faces showing up, and greeting Oracle buddies – some jetlagged, some just early birds.

While Zack covered the storage engine and appliances sessions pretty well, I feel he’s missed out on a few important new engines (or engine related talks):

• DDEngine will be represented, speaking about Automated data versioning with a storage engine
• Long time MySQL Community Member Beat Vontobel, will be presenting on the SeqEngine, in Solving Common SQL Problems with the SeqEngine
• Kazuho Oku, from Cybozu Labs in Japan, will be talking about Q4M, a queuing engine for MySQL. Mixi.jp uses it for their Twitter like service, so I’d …

This is a “first-timer’s” guide to the MySQL Conference & Expo 2009. It is by no means official, but are things I think are somewhat important. Its broken down into sections: What days to attend, What to bring, Laptop, Blogging, Twittering, etc…, Be Social, The Attendee Directory, Evenings, and Did I miss something? Its long, but do bear with me — its just some friendly advice after attending this conference for quite the number of years.

What days to attend

The conference runs from Monday to Thursday. Monday is tutorial day, and Tuesday, Wednesday and Thursday are days where you have the conference proper.

Tuesday and Wednesday are days the Expo Hall is open. Go there, visit the place, learn about the ecosystem, and probably walk away with goodies while you’re at it. Don’t forget the DotOrg Pavilion, as there are plenty of open source …

I’m very proud to share with you a few things: Sheeri K. Cabral, Nick Westerlund, Paul Vallée, Peter Ling, and I (Augusto Bott) will be in Santa Clara, CA for the MySQL Conference and Expo, MySQL Camp, and the Percona Performance Conference, next week.

Nick and I will be presenting a session called Proactive Operational Measures on the Percona Conference, and another session called 8 Rules for Designing More Secure Applications at the MySQL Camp.

Sheeri will be presenting Understanding How MySQL …