Once again, I was unable to attend all of the sessions I wanted to at this year's User Converence, but I was happy to make it to Bob Burgess' talk on bash scripting with mysql. The slides and examples aren't up yet, but when they are (which may be as you read this, check the last link), they would probably also be a great tutorial.

So, I got bore\^D\^D\^D\^D inspired later that day to put some of the practices into use, and worked up a script to run mysqlslap in various ways against a server, and then added a couple funcitons to try it out on each storage engine. The script is below in its entirety - bash scripters, please be kind in your comments. No, I didn't write all this just for the pun in the …

I'm incredibly elated to announce the release of DBD::drizzle 0.100. What is different about this release? It uses Eric Day's new client library, libdrizzle! This means we could eventually package the client with DBD::drizzle, eliminating the issues I have with DBD::mysql where code doesn't compile because of trying to compile DBD::drizzle against a MySQL client binary produced on a different machine with a different compiler and compile flags.

I want to thank Clint Byrum - immense thanks- for his work, which the majority of, made this possible. He and I spent the last several days together at the users conference going over the code, getting it to work. We achieved together more in hours time what would have taken days or even weeks. I'm also glad to have gotten to know Clint-- it's great to make new friends!

The next step is that we'll probably write this from scratch at some point. Right now, this is a retro-fit of …

Mike Hillyer talks about MySQL Workbench. Very nice workshop! (Hillyer will make slides and screen recording of his talk available.)

This is a great platform-native application. All presentation code is written for each specific platform. It is the second most-popular download and the second most purchased product in the MySQL online shop.  There's a community edition and there's a standard edition of the Workbench. People in the workshop got a 1 year subscription to the commercial, standard edition.

I'm sitting in the room here in MySQL Conference. I'm running a WB 5.1 edition I've built on my MacBook Pro laptop.

Mike Hillyer talks about MySQL Workbench. Very nice workshop! (Hillyer will make slides and screen recording of his talk available.)

This is a great platform-native application. All presentation code is written for each specific platform. It is the second most-popular download and the second most purchased product in the MySQL online shop.  There's a community edition and there's a standard edition of the Workbench. People in the workshop got a 1 year subscription to the commercial, standard edition.

I'm sitting in the room here in MySQL Conference. I'm running a WB 5.1 edition I've built on my MacBook Pro laptop.

Hi,

First let me start by making sure you know Sun's MySQL Cluster 7.0 has been released as GA. The was announced at the MySQL Users Conference this week.

You can read more about the release at:

http://www.mysql.com/products/database/cluster/
http://www.mysql.com/news-and-events/generate-article.php?id=2009_06

Now, on to the topic.

Disclaimer:
All performance numbers released here are used for development purpose only and are not intended for marketing. The systems are not set for optimal throughput and the results of tests are "only" used to ensure that we have not lost performance from commit to commit or to, as in this case, track down issues.

Moreover, the TPC-"B" test is a retired test from www.tpc.org, but is still a very useful test when looking at simple transaction and scalability of simple transactions w/ a low probability of deadlocks …

“We’re both in the transportation business. We have a 747, and they have a Toyota.”

The comparison of Oracle’s database and MySQL, made by Oracle president Charles Phillips at the 2004 Vortex Conference was undoubtedly meant as a criticism, but it so graphically demonstrated the differing business strategies and selling-points of the two products that MySQL executives began citing it themselves.

It is also a comparison that explains how the two products could potentially co-exist within a single company, as they seem likely to do following the announcement that Sun has agreed to be acquired by Oracle.

Much of the MySQL-related coverage of the impending acquisition has focused on the likelihood of Oracle killing-off the …

Jonas in the Cluster team reported on his work on executing
joins in the NDB kernel for MySQL Cluster here.

This is a very interesting work we have in progress at MySQL.
We are working on an extension of the Storage Engine API
where the MySQL Server will present an Abstract Query Tree
to the Storage Engine. The Storage Engine can then decide to
execute the query on his own or decide that the MySQL Server
should execute it in the classic manner. In the first prototype
the optimisation will be done as usual and only after the
optimisation phase will we present the join to the storage
engine. However the specification also covers work on
integrating this with the optimiser and also enabling the
possibility for the storage engine to execute parts of the
query and not the entire one. The specification …

Had a fun time being on Percona’s performance panel late last night. For those who were there,  I was probably the only guy you did not recognize:)   The  panel of Ronald Bradford,  Mark Callaghan, Cary Millsap, Jay Pipes, Michael “Monty” Widenius, and myself spent the evening answering questions from the audience and of course drinking Monty’s famous black vodka.  While a lot of the questions drifted away from performance I think everyone had a good time and found the session to be informative.  Now the question i have is : does anyone have any good photo’s of the event?

If you like to sift through tons of benchmark data about various
MySQL versions, Dimitri at the Sun Benchmark Labs have published
a serious amount of benchmark data in a report published here.

The report shows that the new MySQL 5.4.0 release
have a very good performance. The report also shows how the day
of a developer of performance improvements and the massive amount
of benchmark data that needs to be analysed and sifted through
to understand the impact of new performance improvements.

I personally met Dimitri the first time in 2002 when I was working
together with him for a couple of weeks on a benchmark on NDB Cluster
(the storage engine of MySQL Cluster). Our goal then was to perform
1 million reads per second on a 72-cpu SPARC box with …

I arrived late for this talk yesterday. Don't know what was said before I arrived.Was working on my presentation, putting on a few finishing touches, during the BoF session.Asked about WorkLog visibility.Asked about reviewer availability.Take away quotations:"Contributions will be reviewed in reverse order of size (complexity).""Contributions will be tracked in bugdb.""WorkLog will be replaced,