Latest code of MySQL Connector/Python on launchpad has support for multiple result sets when you execute a stored procedure. We also changed the way the actual result of the routine is returned to conform to PEP249.

Here is some example code: it creates a stored procedure which generates 2 result sets. You can get the result by calling next_resultset(), which is returning a MySQLCursorBuffered.

    cur = cnx.cursor()

    cur.execute("DROP PROCEDURE IF EXISTS multi")
    proc = """
      CREATE PROCEDURE multi(IN pFac1 INT, IN pFac2 INT, OUT pProd INT)
      BEGIN
        SELECT 1,'a' as FooBar;
        SELECT 2;
        SET pProd := pFac1 * pFac2;
      END""" …

Sheeri has posted an awesome list of talks with links to videos and slides from the MySQL conference. She did a lot of the video recording herself. I don’t know how she could have posted them so fast — it’s a lot of work.

Related posts:

1. Slides from my session on mk-query-digest at PgEast 2010 After two
2. I’ll be speaking at the O’Reilly MySQL Conference 2010 I’m
3. Submit your proposals for MySQL …

The O’Reilly MySQL Conference & Expo 2010 is over. I hope all of you had a good time. I have plenty of blog posts and thoughts lined up about this, but first, I’d like to point out something that has become a tradition, that was continued in 2010: the O’Reilly MySQL Conference Community Award Winners.

Tim O’Reilly was kind enough to hand out the awards this year. In case people were wondering, the awards were pewter wine goblets from Royal Selangor.

Selection of the award winners happened via voting from the alumni of winners, and was all done in a rather short period of time. Kudos to the entire team that voted. Now for …

I did two talks on replication and clustering at the recent MySQL Conference in Santa Clara.  Thanks to all of you who attended as well as the fine O'Reilly folks who organized everything.  Slides are posted on the talk descriptions at the following URLs: 

• Clustering for the Masses - A Gentle Introduction to Tungsten for MySQL

• Not Your Grandpa’s Replication-The New Wave of MySQL Replication and How It Helps Your Applications (A collaborative talk with Jay Pipes)

Conferences like the MySQL UC are fun because you get to see all your virtual pals …

Sheeri has posted an awesome list of talks with links to videos and slides from the MySQL conference. She did a lot of the video recording herself. I don’t know how she could have posted them so fast – it’s a lot of work.

I will try to tell you how we reduced mutex contention on LOCK_open. Corrections are welcome. This code is complex and in flux from 5.0 to 5.5. This change is in the Facebook patch for MySQL 5.1.

Table handler instances are needed for each table used in a query. They are either fetched from a cache or opened at the start of a query and then either closed or returned to the cache at the end of the query. Some of the work done to open a table handler instance is serialized. This is done by locking the LOCK_open mutex for the duration of the call to the handler::open method. Sometimes a lot of work is done during the call to handler::open. Index cardinality statistics must be computed the first time a table is opened for InnoDB tables as it does not store statistics on disk. Cardinality statistics are computed by sampling 8 leaf blocks …

This is the first part of an ongoing series about my experiences while writing the MySQL Admin Cookbook for Packt Publishing. All parts can be found under the mysql-admin-cookbook label.

In a few past posts I wrote about different aspects of my book writing project already. However those posts were not very contiguous, and I was asked a few times what my general experiences were and what caveats to look out for when taking on such a project for the first time. It might be of interest to some if I write down my experiences in a little more structured form.

This will be a series of several posts, because for one I do not think it would be feasible to …

Welcome to the 186th Edition of Log Buffer. Lots to report this week, so read on…

In Oracle news:

We begin with Gary Myers at the Sydney Oracle Lab who mixes GUI and CLI and shows how to manage your database from EMACS. You have to read a post that starts with: “There is a place of shadow, a place between the dark lands of the command-line interface, and the shining brightness of the GUI. In the days of yore, many dwelled in the shadow lands, but almost all have been attracted to the lights of SQL Developer…”

Tanel Poder gives a step by step tour of his …

The White House contributes to OSS. Growth for Pentaho and MuleSoft. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

# The White House released some of the custom code it has developed for whitehouse.gov as open source.

# Pentaho reported 229% bookings growth and 177% Enterprise Edition customer growth in Q2.

# MuleSoft grew bookings by 140% in Q1.

# The beta of Red Hat Enterprise Linux 6 is now available, without Xen.

…

We’re now about a week away from WordCamp San Francisco 2010. I am extremely excited about the speaker lineup this year (6-7 not listed yet), we’ll have a jazz performance, awesome shirts… best WordCamp SF yet. Get your tickets ASAP if you hope to attend.