For some reason my presentation slides have not been posted to on MySQL Users Conference site. Here it is, a pdf format of "Introduction to Using DTrace with MySQL".

The presentation slides for my Query Analysis talk here at the users conference are now available:

How I Used Query Analysis to Speed up My Applications

I’ll sort out the scripts and bits and pieces I use once I get back to the office next week, for those people waiting for that material.

My presentation slides for the Scale Up, Scale Out and High Availability tutorial here at the MySQL Users Conference are now available for download:

Scale Up, Scale Out and High Availability: Solutions and Combinations

These have been on the MySQL Conference website for days now, but for some reason they don’t seem to have been freed yet.

To those waiting I’m sorry for the delay in getting these uploaded.

In InnoDB there is an implementation of both mutexes
and RW-locks. The RW-locks implementation have been
improved by the Google SMP patches. Both of these
implementation relies on spin-loops as part of their
implementation. The defaults in InnoDB is to check
the condition, if it's not ok to enter to spin for
about 5 microseconds and then come back to check the
condition again.

If one reads the Intel manual how to do spin-loops
they propose to use a PAUSE instruction and then
check the condition again, so a much more active
checking of the condition. When we tried this out
using the sysbench benchmark we found that using
the Intel approach worsened performance. So instead
we tried an approach of putting the PAUSE instruction
into the InnoDB spinloop instead.

This approach turned out to be a success. Even on
machines with only one …

What: Sydney Oracle Meetup #3 - Focus on E-Business Suite + Oracle/Sun deal
When: April 28, 2009 5:30 PM
Where: As usual - Sydney Mechanics School of Art
How: just register at the SOM website.

We have to limit the number of people to 40 this time so make sure you RSVP timely!

We are gathering at 5:30pm and technical goodies are starting at 6pm so use this time to catch up with other members. We should finish by 8:30pm including a beaks and some post follow up. The presentation schedule is a bit floating this time.

As usual, we should have some pizza and beverages facilitating seamless peer networking. ;-)

In addition to the main topic, we plan to have some overview of Oracle / Sun deal and share what everyone thinks about it + report from the …

A number of developers look at SQL tuning hints as a way to performance tune queries. Where the best way to tune SQL code is not to use hints. Hints add high maintenance code and try to influence the Cost Based Optimizer which can have negative impacts in the future. What if the data distributions change or the optimizer adds new features in the future? The best way to tune SQL code is to

Kazuho Oku of Cybozu Labs, Inc., a community contributor to MySQL and SCA signatory, gives a talk on Q4M, a message queue stroage engine for MySQL.

Kazuho Oku of Cybozu Labs, Inc., a community contributor to MySQL and SCA signatory, gives a talk on Q4M, a message queue stroage engine for MySQL.

OurDelta builds of MySQL 5.0.77-d8 for Ubuntu 9.04 (Jaunty) builds are done, thanks to some smart and fast work by Peter. The packages are getting copied to the main site right now, and the mirrors should be up-to date within half a day or so.

I arrived at the MySQL Users Conference just in time for the The Great Open Cloud Shootout.

Kaj Arno was asking questions to the invited panelists shown in the picture above. Here is a partial discussion:

What is cloud ?