Real Time Data Warehousing Presentation

At the March Boston MySQL User Group meeting, Jacob Nikom of MIT's Lincoln Laboratory presented "Optimizing Concurrent Storage and Retrieval Operations for Real-Time Surveillance Applications." In the middle of the talk, Jacob said he sometimes calls what he did in this application as "real-time data warehousing", which was so accurate I decided to give that title to this blog post.

The slides can be downloaded in PDF format (1.3 Mb) at http://www.technocation.org/files/doc/Concurrent_database_performance_02.pdf.

Video: Partitioning in MySQL 5.1

At the January 2009 Boston User Group I presented a session on the new partitioning feature in MySQL 5.1. I go through how to define partitions, how partitioning makes queries faster, the different types of partitioning and when to use each type, and the restrictions and limitations of partitioning.

The slides are available at http://www.technocation.org/files/doc/2009_01_Partitioning.pdf. The video is embedded at the bottom of this post, and is also available at youtube at http://www.youtube.com/watch?v=zvN9XI-FraI.

New in MySQL 5.1: The Presentation

What's new, in a nutshell: http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html.

Release notes: http://dev.mysql.com/doc/refman/5.1/en/news-5-1-x.html (In the video, it's the page entitled "Changes in release 5.1.x").

And yes, very early on (at about 2 minutes in) I talk about my take on Monty's controversial post at http://monty-says.blogspot.com/2008/11/oops-we-did-it-again-mysql-51-released.html

OpenSQLCamp Video: How SQL Database Engines Work

Dr. Richard Hipp, creator of SQLite, presents "How SQL Database Engines Work" at OpenSQLCamp 2008.

The description:
To many programmers, SQL RDBMSes are a magical black box. A talk can help clear up a lot of the mystery. SQL users tend to make better use of the language once they have a rough idea of what is going on beneath the covers.


Moving Application Logic Into the Database by Bruce Momjian

Bruce Momjian talks about general strategies for moving application logic into databases, mostly why to do it and why to not do it. This talk is mostly DB agnostic. Note that the slides have a title of "Processing Data Inside PostgreSQL". The slides can be found at http://www.slideshare.net/EnterpriseDB/data-processing-inside-postgresql.

How to Stop Hating MySQL

At LISA 2008, I gave a presentation entitled "How to Stop Hating MySQL: Fixing Common Mistakes and Myths".

The presentation slides can be downloaded as a PDF at:


View the video online at http://www.youtube.com/watch?v=DylLYQlzuKo (or watch it at the bottom of this page).

Here are some notes and links I referred to:

Technocation, Inc containing free videos, a MySQL podcast (currently on hiatus) and blog posts about MySQL.

Load Testing Using Perl

Homer Hummel of the Computer Sciences Corporation gives a presentation on Load Testing Using Perl. A must-view!

Stream directly online at http://technocation.org/node/615/play or download the 247 Mb .wmv file at http://technocation.org/node/615/download.

OSCon 2008 Video: Perl Lightning Talks

The video starts after the presentation started. According to the schedule at http://www.justanotherperlhacker.org/lightning/2008oscon.shtml, pgtap is discussed first so there's not much missing on the video (the video starts with talking about pgtap).

Stream directly online at http://technocation.org/node/612/play or download the 257 Mb .wmv file at http://technocation.org/node/612/download.

OSCon 2008 Video: The Internet is an Ogre: Finding Art in the Software Architecture

Terry Chay of Tagged, Inc. gives an amusing an informative look at development in "The Internet is an Ogre: Finding Art in the Software Architecture."

Stream directly online at http://technocation.org/node/592/play or download the 356 Mb .wmv file at http://technocation.org/node/592/download.

From the official OSCon description:

Internet Software Architecture at its most basic consists of four goals: Stability, Scalability, Speed, and Security. A good engineer will answer the problems posed to them; a good software architect asks a different question. That’s the fairy tale we tell ourselves. But the real internet is an ogre. It never acts the way we expect and it bashes us in when we least expect it. Eventually security and stability may seem to us so much the Land of Make Believe as we deal with just keeping a site stable. This talk uses an example in each architectural area of the largest social networks on the internet to try to show that even then there can be art in asking a different question. (Even if our answers, painted using PHP, can look like a Jackson Pollock.)

Backups: A Video Presentation By Keith Murphy From the June 2008 Boston MySQL User Group

The Boston MySQL User Group was lucky enough to get Keith Murphy to speak at the June User Group meeting, about backups.

Links referred to in the presentation:

MyLVMBackup by Lenz Grimmer

InnoDB Hot Backup:
Prices are at:
and at the time of this writing are:
1-Year License € 390 USD$ 605 per server
Perpetual License € 990 USD$ 1540 per server