Immediately after my presentation about my MySQL S3 storage engine, I was interviewed by Eric Lai, a reporter from ComputerWorld. The resulting article is here, and was abstracted by the conference here.

Also, Sheeri Kritzer recorded me. Here is the audio and the video.

When I get the larger form of the video, I'll push it into an S3 bucket/item and make it world readable...

When MySQL first came out and started popping up all over the web in the e-commerce arena, if you were like me you looked at it as a wannabe. 'Call me in a few years when you grow up'. Yea, sometimes the Oracle in us goes to our heads a little to fast...MySQL has really gone mainstream in the last few years. Companies that never would have considered MySQL in the past for critical database

Welcome to the 46th edition of Log Buffer, the weekly review of database blogs. PGCon 2007 has been happening just a few blocks from where I sit, and judging by what the bloggers have to say, organizer Dan Langille has done a great job putting together a very full conference. Let’s start with some blogs [...]

Inserting user-defined DTrace probes into MySQL source code is very useful to help user identify the performance problems in the application level and the database server, In addition, the cost of the USDT probe is basically neglectable. Each probes inserted into the src can be enabled by adding the code like:

 If (PROVIDER_PROBE_ENABLED()

{

                PROVIDER_PROBE(arg0,…);

}

The steps to add DTrace probes into MySQL is very straightforward.

Step 1: Figure out what probes are needed to insert into the source code

This is the difficult part that requires you understand the MySQL implementation details. Generally, it is good to insert probes to clarify the DB response time distribution …

Inserting user-defined DTrace probes into MySQL source code is very useful to help user identify the performance problems in the application level and the database server, In addition, the cost of the USDT probe is basically neglectable. Each probes inserted into the src can be enabled by adding the code like:

 If (PROVIDER_PROBE_ENABLED()

{

                PROVIDER_PROBE(arg0,…);

}

The steps to add DTrace probes into MySQL is very straightforward.

Step 1: Figure out what probes are needed to insert into the source code

This is the difficult part that requires you understand the MySQL implementation details. Generally, it is good to insert probes to clarify the DB response time distribution …

The hot tub is still having an issue. I suspect that there is an air
bubble past the primary pump. Nothing seems to be working to get the
air bubble out. Either the pump is having issues, aka is clogged, or
priming is not working. The reason I suspect that it is priming is
because during the priming stage nothing is happening.

What I want is for the tub to work.

What would I like long term? Find a way to raise the temperature from
104 to 108. The tub has some sort of safety feature built in so that
this can not happen. I've studied the board that controls the hot
tub, and except for one jumper, I've been able to document them all
(and I suspect the one jumper is just for turning the ozone creator
on and off). To learn more I turned to google :)

Surprisingly little is out there on hot to hack your hot tub. No
conversations on any …

This is a review of Webyog's MONyog MySQL monitoring tool. The product is still in beta and has some rough edges, but holds promise. Its design includes some interesting architectural decisions I think will help distinguish it from MySQL's own Monitoring and Advisory Service.

With MySQL 5.0 the database provides trigger functionality on INSERT, REPLACE, UPDATE and DELETE.

Those of you who know some other RDBMS know, that there are also some system events where one would like to have triggers.

Unfortunately MySQL does not (yet) provide such functionality. This is sad because as database administrator this would be sometimes very helpful.

But you can build your own LOGON and STARTUP trigger.

MySQL provides some hooks for these events...

Complete Story (PDF 160 kbyte).

I was unable to attend JavaOne this year since I was at the Red Hat conference in San Diego. Still, I heard good things, especially about a new language and framework called Scala/lift.  Both Java Flex guru Bruce Eckel and scalability guru David Pollak commented on Scala. (More on that next week.) 

So my only way to find out what was going on was through blogs and news releases.  If you missed JavaOne, check out the links below.  Interesting highlights include Sun's announcement of …

With MySQL 5.0 the database provides trigger functionality on INSERT, REPLACE, UPDATE and DELETE.<br> Those from you who know some other RDBMS know, that there are also some system events where one would like to have triggers.<br> Unfortunately MySQL does not (yet) provide such functionality. This is sad because as database administrator this would be sometimes very helpful.<br> But you can build your own LOGON and STARTUP trigger.<br> MySQL provides some hooks for these events...<br>