• Baron Schwartz presents
• only works for SELECTs
• nobody dares admit if they've never seen EXPLAIN
• MySQL actually executes the query
• at each JOIN, instead of executing the query, it fills the EXPLAIN result set
• everything is a JOIN (even SELECT 1)
• Columns in EXPLAIN
  • id: which SELECT the row belongs to
  • select_type
    • simple
    • subquery
    • derived
    • union
    • union result
  • table: the table accessed or its alias
  • type:
    • join
    • range
    • …
  • possible_keys: which indexes looked useful to the …

Speaker: Mike Zinner

Developed a design tool called DBDesigner4 as his own schema design tool, had 1.5 million downloads. Tool was built on Delphi, became outdated. Project brought him to the attention of MySQL AB, resulted in a job offer.

After signing on he began work on basic MySQL GUI tools such as MySQL Administrator, MySQL Query Browser, Migration Toolkit, and MySQL Windows installer and configuration wizard.

Project existed from DBDesigner, then in 2005 a preview version of Workbench was released. Workbench was re-architected in 2007-2008 and was released in April 2008.

Workbench is a fully featured schema design tool for MySQL developers. Two editions: one open source and one commercial. Commercial version has additional functionality.

Intended for developers, architects, DBAs.

Provides schema design features, schema documentation features, database sync, schema validation, internal …

In case anyone is wondering, I will be at two birds of a feather sessions today, one with the PHP/Zend crowd and another with the good folks over at Wavemaker.

MySQL and PHP: Joined at the Hip

It's no secret I'm a huge fan of PHP, so it should be no surprise I'll be joining the fun over in Ballroom H, from 7:30-8:30pm tonight to discuss all things PHP and MySQL.

Be a Web 2.0 Rock Star

OK, I'm a sucker for competitions, and this one definitely looks like fun!

It's Tuesday evening, tonight, April 15, at 8:30 in Ballroom E. For rock stars, compete against other Ajax experts to build the coolest Web 2.0 app in 30 minutes and win your very own copy of the Rock Band video game. For newbies, get an up-close look at the latest Ajax …

So, I have been mistaken in thinking that the MySQL Conference web system was set up for providing online feedback for speakers. Apparently, there is a 3rd party online service in use for providing speaker feedback. The link to it is available here.

Cheers. I'm off to run more benchmarks for tomorrow's presentation with Tobias.

The slides from my tutorial yesterday are up at develooper.com. 189 slides this year! A handful of people have told me today (and more yesterday obviously) that they learned a lot and got new ideas for how to build things - yay!

I’m considering putting up a version of the slides with sound. Would anyone want a 3 hour quicktime movie of that?

Well, maybe split up into smaller bits, but you get the idea. You wouldn’t get the hand waving, but you would get a bunch more detail, obviously.

I actually had audio recorded, but I haven’t checked how it came out, yet, and I’d have to make a synchronized movie version of the slides (and …

A

We are proud to announce that MySQL Workbench has reached GA (General Availability)
status and the final version - 5.0.19 - is available on our mirrors.

We managed to get another 32 bugs fixed since the last Release Candidate and hopefully there aren’t many still hidden in our code. We are planning to release a new Version of Workbench every three weeks so if new bugs are found and reported we’ll fix them and supply a improved build quickly.

Get a copy of our OSS Edition from Servers now and start designing your databases.
If you want all the time-saving features (including direct connection to DB, Validation of your models, …) you could invest 99 USD on the Standard Edition - please go to http://shop.mysql.com and get your license there! (Our web-shop is currently being prepared so Workbench will be available there at 4pm PST)

Diamond NotesApril 16, 2008Faster, Greener, Cheaper (Why every MySQL server will one day have a SQL chip) (http://www.paragon-cs.com/wordpress/2008/04/16/raj-cherabuddi-faster-greener-cheaper-why-every-mysql-server-will-one-day-have-a-sql-chip-uc/)

Hi there!

I arrived at Santa Clara yesterday, just in time for the MySQL Community dinner (check this post on Arjen’s blog). It was a lot of fun, not to mention the opportunity to talk to developers and other folks from MySQL/Sun.

Unfortunately, I forgot to pack in my luggage a card reader or a proper cable for my camera, so pictures will have to wait a few days. To mitigate this problem, I’ll try to hunt down more posts from other guys, but in the meantime, you might want to check the 2008 MySQL Users Conference & Expo group at Flickr.

Yesterday was the “Tutorials Day”. I’ve been to many of them. The subjects were so interesting I just couldn’t stay put for the whole session so, I kept jumping from one to the other. A few quite interesting sessions: …

I’ll be blogging and posting photos from the 2008 MySQL Conference.

My photos can be seen in a Flickr set at  http://www.flickr.com/photos/mhillyer/sets/72157604556435611/

Watch this space for session notes.