DTrace Integration with MySQL 5

On April 15-16, we demoed a few DTrace probes for MySQL 5.0 integrated with Chime visualization Tool at MySQL users conference 2008. Here is an snapshot of the DTrace probes in chime showing the query execution time/count in Chime tool:

The DTrace probes inserted into MySQL 5.0 in the demo are:

provider mysql {
    probe data__receive__start(int);
    probe data__receive__finish(int);
    probe query__plan__start(char \*);
    probe query__plan__finish(char \*);
    probe query__execute__start(void \*, char \*, char \*, …

DTrace Integration with MySQL 5

On April 15-16, we demoed a few DTrace probes for MySQL 5.0 integrated with Chime visualization Tool at MySQL users conference 2008. Here is an snapshot of the DTrace probes in chime showing the query execution time/count in Chime tool:

The DTrace probes inserted into MySQL 5.0 in the demo are:

provider mysql {
    probe data__receive__start(int);
    probe data__receive__finish(int);
    probe query__plan__start(char \*);
    probe query__plan__finish(char \*);
    probe query__execute__start(void \*, char \*, char \*, …

The weekly run-down of MFotD

(See this post for background information on MySQL Function of the Day)

Week Six:

• Monday, April 14th 2008:REVERSE()
• Tuesday, April 15th 2008: CEILING()
• Wednesday, April 16 2008: BENCHMARK()
• Thursday, April 17 2008: MD5()
• Friday, April 18 2008: CRC32()

(more…)

This past week I was out in the Bay Area for the MySQL Conference and Expo.  I hit the pre-event parties and attended the conference's opening day.   The first day featured a great set of opening keynotes from Marten Mickos, Jonathan Schwartz and Werner Vogel, CTO of Amazon. 

Marten Mickos, tellin' like it is. 

 
Jonathan Schwartz divulging Sun's "secret plot." 

The main reason for my attendance at the Conference was to get a bunch of podcast interviews as well as to be interviewed by the press as Sun's "Linux Guy."  I ended talking to the Register, Information Week and DevX as an interviewee. 

…

Send in by Ruben Daniels

Lustre is one of the most popular upcoming open source cluster file systems out there. When you want to run Xen’s from a SAN using Lustre you need to support both in the Linux kernel. Both XEN and Lustre are near mature products. This means there is support for it. But it’s quite difficult to find the right source and to combine it with the right kernel source of each. It took me a week of trial and erroring until I found a combination that worked. Since Google wasn’t much help I wrote this article so it might help you. This installation is Ubuntu Gutsy specific. You can start out with a basic Gutsy installation. Hardy is getting Lustre support, but at the time of this writing the package doesnt match the default kernel of Hardy.

First we apt-get some utilities and Xen packages

apt-get install quilt libc6-xen libxen3.1 …

MySQL announcement during the 2008 User Conference really sparked some responses from the community. Many comments on Slashdot. More on Jeremy's blog, and still more on Mike Krukenberg's blog.

Will MySQL closing enterprise source impact you? Please take the poll, it's open until 06/01/08!MySQL DBA & Programming Blog by Mark Schoonover

Once again I spent a week in the San Francisco Bay Area. This time around it was for LugRadio Live USA 2008 and the MySQL Conference & Expo 2008.

I flew in on April 12 (from FRA via LAX to SJC) and arrived in the hotel, the Hyatt Regency Santa Clara, in the afternoon.

The next morning I left the hotel around 7:00 in the morning for a genuine experience of what they call public transportation in the bay area. It took me three hours to travel the distance of …

*Disclosure: I am an advisor to TargetSource see: TargetSource Official Launch

1. How did you get started?

After 7 years effort on open source community and 3 years business practice on open source services in China, we think it is a right time for us to start up TargetSource. More and more companies always ask us to help them to solve problems when they use open source, sometime if you are just a individual, it is not a long term strategy for company to get support on open source software. That’s why we started TargetSouce, an open source service company which delivers to end customers by a global collaboration network with partners base on the open source software.

2. What is your product?

TargetSource strategy is not building a single open source component or product such as JBoss, hibernate, Spring or so. From our …

With assistance from Antony Curtis who spent some coding time with me at the conf, and a number of helpful other individuals (Monty, Sergei, Timour, Igor, patg, Stewart, Brian, Mark, Paul, and others) who answered questions and looked things up, the earlier backend demo can now be executed from a MySQL 5.1 server with the OQGRAPH Engine plugin loaded. In other words, the basic glue has been completed, and the prototype works. Thanks all!

This was later in the week, so at the BoF Tuesday night we still had to make do with paper and the backend test tool, but Thursday evening and Friday I was able to demonstrate the real thing, including at the post-conf MySQL unconference at Google HQ. I was happy to see good interest in the GRAPH engine, and also received some very useful …

It seems there is interesting problem with compatibility of MySQL binaries and binaries of third-party plugins.

I personally found and there is confirmation from InnoDB team that current InnoDB-plugin binaries do not work with lastest 5.1.24-rc binaries. It was very charming move from MySQL side to release new incompatible binary on the second day after the announce of InnoDB plugin. I do not think it was intentional, but still looks funny and shows broken communication between teams.

The more interesting becomes from Sergei Golubchik presentation on MySQL Conference, where Sergei says that in current API "versioning binds a plugin binary to specific server release". That simply means that InnoDB has to release binary for each binary of MySQL. I suppose it should …