Ronald Bradford is a busy man. He has just finished Effective MySQL: Optimizing SQL Statements, the first in a series of MySQL books. There is a sample chapter at the link above.

The chapters on indexing will be valuable to novices. Ronald has distilled his presentation on the use of EXPLAIN into chapter that should be made mandatory reading. The book is free of fluff and full of information that you will reference well after the initial reading.

For those of you at Oracle Open World, this book and others are heavily discounted in the bookstore on the second level of Moscone West, near the MySQL Community Kiosk.

…

It's great to see so many presentations and activities surrounding MySQL at Oracle Open World this year.  There are a lot of Dolphins around the conference which is great to see as well.

They MySQL reception Tuesday evening is going to be a great opportunity to get caught up with everyone.

The MySQL Community Sessions at Oracle are going great. Good crowds, lots of questions about MySQL at the kiosk, and great presentations. Here Sarah Novotny gets camera time. I am not sure if her new show will be called ‘Two and a half DBAs’ or ‘The Big Data Theroy’.

…

I will be presenting at Oracle Open World but my presentation is not designed for a MySQL Audience. MySQL for Oracle DBAs or Speaking MySQL for Beginners will help Oracle DBAs embrace MySQL. Many Oracle shops also have MySQL and 11G or RAC DBAs can easily add MySQL skills to their existing set but can benefit from some gentle nudges in the right direction to get them started. Look for Session 15143 on Tuesday at 3:30 in Golden gate B at the Marriott Marquis. And do not forget the community reception after!

…

Virtualization is going to be one of the hottest topics at Oracle Open World 2011.   Here is a link to track a number of the virtualization presentations.

http://www.oracle.com/openworld/oow11-focuson-virtualization-485282.pdf

Be sure to drop by the MySQL Demo Pod while you are attending Oracle Open World. There you will see a demo of the changes in MySQL Cluster 7.2. My favorite part of this release is that you can access the same data via SQL, LDAP, REST, memcached or via APIs. You get the best of both SQLand NoSQL worlds in one. At the Demo Pod, you can see how to see how Adaptive Query Localization speed up joins. Plus the demo will preview the latest and
greatest 7.2 DMR capabilities, and also demonstrate how MySQL Cluster
remains operational during node failures, upgrades and re-configuration
and how simple it is to create a live cluster using MySQL Cluster Manager. In the past, many cluster users avoid joins and simply used primary key or key/value pairs. But Adaptive Query Localization gets the data nodes to do more of the work in parallel.

And Cluster Administration has been greatly streamlined. So less typing gets you more …

MySQL will be big at Oracle Open World. Not only are their demo pods, a community run area, and two community organized tracks on the first day! A full MySQL session track will be part of Open World for the first time. A full searchable list of all session with the options is available here a quick list of MySQL sessions is below. Note the sessions starting with IOUG are on Community Sunday on October 2nd. And the number after the title is the session id number.

If you register by August 12, there is a special early bird discount for the MySQL community. Use the code “MYSQL11″ during registration and save $1,000 over the on-site price.

1. Accelerating Telecom Transformation with Web 2.0 Data …

The OpenWorld early bird pricing ends this Friday, July 29!

This is the last week to use the “MYSQL11″ special MySQL discount code
and get $1,000 over regular price, so please take time to share the code
again with customers/prospects or remind them to register by Friday.

Register here and remember to enter Priority Code MYSQL11 during registration.

Oracle OpenWorld will be held on October 2-6, 2011 in San Francisco, CA. This year, we’re offering even more MySQL content and networking activities as a track under the Database Stream, including:

• 30+ Conference Sessions
• Sunday User Group Sessions
• 3 Demo Pods
• 1 Hands-on Lab
• MySQL Customer Advisory Forum
• MySQL Community Reception

If you register by …

Oracle Open World has a MySQL track this year and you can submit session proposal and vote on proposed sessions until June 19th!1 Please vote to help determine what you will see at OOW.

Before the regular OOW sessions, on Sunday October 2nd, MySQL will have two simultaneous tracks for Community Sunday. Session speakers are also needed and we do have two rooms to fill. So dust off that presentation idea you have been working on and get it polished. If you would like to present at on Sunday, please let me know and I will pass on the information to the MySQL Community Sunday Organizers.

And we will have a MySQL booth in the USer Group Area for you to drop[ in and talk about MySQL. And we need …