This is a sneak peek video introduction/preview of an in-development free and open source server side debugger & debugging API for MySQL stored routines.

MySQL does not provide server side debugging capabilities for stored routines. Some tools exist, including MySQL's own, that assist in stored routine debugging. These are all GUI based and, to the best of my knowledge, MS Windows based. There is one solution in alpha stage that is developed for Java/eclipse; I did not look at the code. See discussion here and here.

An ideal solution would be to have debugging API in the server itself - independently of your client, programming language or operating system. To the

I feel a sense of pride when I think that I was involved in the development and maintenance of what was probably the first piece of software accepted into Debian which then had and still has direct up-stream support from Microsoft. The world is a better place for having Microsoft in it. The first operating system I ever ran on an 08086-based CPU was MS-DOS 2.x. I remember how thrilled I was when we got to see how my friend’s 80286 system ran BBS software that would cause a modem to dial a local system and display the application as if it were running on a local machine. Totally sweet.

When we were living at 6162 NE Middle in the nine-eight 292, we got an 80386 which ran Doom. Yeah, the original one, not the fancy new one with the double barrel shotgun, but it would probably run that one, too.

Jono Bacon recently spoke with Luke Kowalski, Oracle VP in the Corporate Architecture Group, about community in the context of MySQL. I’ve known Jono for sometime now, and I first met Luke at the MySQL Conference & Expo 2010 – I found out that we have a common shared interest: Formula One racing! Jono is somewhat of an expert in online, opensource communities – he after all did write the definitive book that O’Reilly published titled The Art of Community.

The video has made its way online, and Jono wrote a brief (and you can watch the video within his

Here’s a matrix of all the videos up on YouTube for the 2010 O’Reilly MySQL Conference and Expo. The matrix includes the title, presenter, slide link (if it exists), video link, and link to the official conference detail page, where you can rate the session and provide feedback that the presenter will see. They are grouped mostly by topic, except for the main stage events (keynote, ignite) and interviews.

If there’s a detail missing (ie, slides, or there are other videos you know about), please add a comment so I can make this a complete matrix.TitlePresenterSlidesVideo link
(hr:min:sec)Details (Conf. site link)

Keynotes

Here’s a sneak peek at a video matrix — this is all the videos that include Pythian Group employees at the MySQL conference. I hope to have all the rest of the videos processed and uploaded within 24 hours, with a matrix similar to the one below (but of course with many more sessions).

TitlePresenterSlidesVideo link
(hr:min:sec)Details (Conf. site link)

I’ve been offline (mostly) for the past week while at Tracker School and over the next few days I’ll be catching up on what happened while I was out. You guys were busy. As I pulled into my garage after a long drive this song came on shuffle and I wanted to share it with you guys — Nina Simone’s Feeling Good:

Last month at the Boston MySQL User Group, I went through the meanings of INNER, LEFT/RIGHT OUTER, CROSS, NATURAL joins, how to do a FULL OUTER JOIN in MySQL, and what STRAIGHT_JOIN means. I also explained how to recognize when you want those types of joins, and best practices for the semantics of writing joins and design patterns. Subqueries were explained in this session, and some examples of how to think differently so that you end up writing JOINs instead of subqueries. The slides (slightly different from the slides in the video — due to error correction) can be found at http://technocation.org/files/doc/2010_01MySQLJoins.pdf.

Here’s the video:

Another video from the recent OpenSQLCamp in Portland, Oregon….Earlier today I uploaded the Lightning Talk Videos. Due to the holiday I am unsure when the rest of the videos will be ready. When they are, I will do one blog post featuring them all.

However, I have had several requests for this specific video, so here is Brian Aker speaking about Drizzle.

The slides are up at http://www.slideshare.net/brianaker/drizzle-opensql-camp, and here’s the video:

(Note, I will not do a post for each video…..but since this one is up and ready, I figured I’d do it before I leave for the holiday).

OpenSQLCamp was a huge success! Not many folks have blogged about what they learned there….if you missed it, all is not lost. We did take videos of most of the sessions (we only had 3 video cameras, and 4 rooms, and 2 sessions were not recorded).

All the videos have been processed, and I am working on uploading them to YouTube and filling in details for the video descriptions. Not all the videos are up right now….right now all the lightning talks are up.

• All the lightning talks belowin one continuous video (just over 54 minutes total)
  
• The Graph Engine (Antony Curtis)


• Cluster/J, a new set of Java APIs to

Last night at the Boston MySQL User Group I presented on how to get a consistent snapshot to build a slave, how to use mk-table-checksum to check for differences between masters and slaves on an ongoing basis, and how to use tools such as mk-table-sync and mysqldump to sync the data if there are any discrepancies.

The slides are online at http://technocation.org/files/doc/slave_sync.pdf.

The video can be watched on youtube at http://www.youtube.com/watch?v=Un0wqYKmbWY or directly in your browser with the embedded player below:

The attendees were not satisfied with the first answer RMS gave to Brian, that Harish Pillay (Chief Technical Architect, Red Hat Singapore), chose to ask RMS what more he had to say, with regards to the letter he’d written. He answered quite candidly in this video, which Brian chimed in for as well.

The back channel for all this was Twitter… Don’t hesitate to follow @harishpillay, @brianaker, @piawaugh or even

At foss.my 2009, Brian Aker asked Richard Stallman at his keynote, about the Oracle/Sun acquisition (with a focus on MySQL), with regards to the parallel licensing approach used by MySQL. Brian was referring to:

As only the original rights holder can sell commercial licenses, no new forked version of the code will have the ability to practice the parallel licensing approach, and will not easily generate the resources to support continued development of the MySQL platform.

from Richard’s Letter to the EC opposing Oracle’s acquisition of MySQL. Listen to the discussion between Brian and Richard.

One of my all-time favorite services, Animoto, has teamed up with SmugMug to make truly epic professional quality videos from both your stills and your video clips.  I’ve wanted this partnership since 2007, but Animoto’s had their hands full dealing with explosive growth, so it took us a little longer to sit in that tree together than we thought.

We had my good friend, Robert Scoble, over last night to demo for him, and you can see the video below (or click here to view it on blip.tv):

The really great thing about this is that it’s totally full-circle and tightly integrated.  Find your favorite photos on SmugMug, send them over to Animoto right from SmugMug’s interface (look

Wow, Pulitzer-Prize winning photographer Vincent Laforet has done it again! This time with Canon’s brand-new 1D Mark IV and a film shot at ISO6400. And SmugMug’s got it in all it’s full 1080p hi-def glory, of course.

UPDATE: Canon, whom I love, has requested that Vincent take the video down.  As a courtesy to both Vincent and Canon, we have done so, but hope to put it back up again as soon as they give us the green light.  Read more about it over on Vincent’s blog.  Sorry for the inconvenience.

Related posts:

• Amazing Canon 5D MkII HD video

At the May 2009 Boston MySQL User Group, Giuseppe Maxia of Sun Microsystems gave a presentation about MySQL 5.4 with use cases and benchmarks to show how it outperforms all other current MySQL releases (including the Google patches and the OurDelta/Percona releases).

The slides can be downloaded from http://www.slideshare.net/datacharmer/mysql-54-theory-and-practice

The video can be watched below, or directly on YouTube at http://www.youtube.com/watch?v=giT4SYXuVqA&hl

The tasty new logo

We’ve been busy lately here at WordPress.com — we’ve had an announcement of a new or updated feature for you every day this week. Today, you’re getting a two-fer!

Earlier this week, we announced VideoPress, the great new video feature for WordPress.com. Now VideoPress has its own home on the web at VideoPress.com. We’ve also got a great video introduction created by our company auteur Michael Pick, so be sure to head over and check it out. We’ll be continuing to add features to VideoPress, including support for WordPress.org users, so stay

You may have noticed that videos around here have been getting higher and higher quality.

I don’t just mean the cool content from WordPress.tv, but the video player and video/audio quality itself.

We’ve rewritten how videos work here on WordPress.com from the ground-up and taken inspiration from the great products at Vimeo and Smugmug, and are pleased to formally offer our video upgrade to everyone. Here’s a sample of what it can do especially for those sweltering in the heat right now:

With the video upgrade (available on your upgrades page, bottom left of dashboard navigation) when you upload a video of almost any format we’ll crunch it into several different formats just right for streaming on the web, DVD quality, HD quality, and even

At the MySQL Conference, I had the chance to interview Rohit Nadhani, founder of Webyog, the folk that make SQLyog and MONyog. Watch the video, for more.

Generally based out of Bangalore (I visited them when I was last there), Webyog just started an office in Santa Clara, and are expanding. They boast 15,000 paid customers so far, with some big name customers: Google, Yahoo!, executive office to the US president, and more.

SQLyog is termed as an upgrade from phpMyAdmin. There is a GPL community edition, with some “power tools” that is part of the Enterprise Edition. It is very Win32 based, but easy enough to run on other OSes via WINE or some sort of

While at the MySQL Conference, I caught up with Barry Abrahamson, the systems wrangler/de-facto DBA behind Wordpress.com (and all other Automattic properties). Watch the video.

You probably already know that Wordpress itself is built on top of MySQL. And despite everything you might have heard about our (MySQL/Sun’s) new founders, Wordpress is MySQL today, and for the foreseeable future. Anyway, I digress.

Wordpress.com has about 70 million tables, and tens of thousands of blogs. Large amount of tables,