Presentations/Videos

MySQL User Group Videos

2009 Boston MySQL User Group Videos:

Dec 2009 - Time Zones in MySQL (Sheeri K. Cabral) - video - PDF presentation - Description

Nov 2009 - How InnoDB works: Exploring SHOW ENGINE INNODB STATUS (Sheeri K. Cabral) - video - PDF presentation - Description

Eric Day and Patrick Galbraith speak about Drizzle at the July 2009 Boston MySQL User Group

Eric Day and Patrick Galbraith spoke on Drizzle, Gearman and Narada at the July 2009 Boston MySQL User Group. This is part 1 of the video, which is about an hour long and is about Drizzle.

"We will explain what the Drizzle project is, what we aim to accomplish, and an overview of where we are at."

The slides can be downloaded from http://www.oddments.org/notes/DrizzleGearmanBoston2009.pdf

The User Group calendar item for this event is http://www.meetup.com/mysqlbos/calendar/10607736/

Video: Chasing Bottlenecks

Video for the presentation at the 2009 MySQL Camp:
Chasing Bottlenecks
by Morgan Tocker

Description:
The best way to performance tune a system is to find out what your bottlenecks are, and attacking those first. In the first part of this session, I'll be looking at some of the issues faced with common database workloads. From there, I'll then be showing how you can get more information out of MySQL and your Operating System to find out about your workload. This session is designed for beginner to intermediate MySQL users.

How I hacked the HP Mini Mobile drive port to be a normal USB port

So I got my hands on an HP mini 1000 last week. Not bad for $250 at Best Buy, although it has needed some help, namely:

- External USB hard drive - I got the Mini 1000 that comes with a 16 Gb SSD, and want this to be my primary computer (I'm not a gamer, just web surfing and *occasional* video editing). I bought a 320Gb Buffalo Mini Station, for about $60 at Microcenter.

- 2 Gb RAM - already had a stick, free for me (otherwise $20), easy to pop in.

- USB to VGA adapter - HP has a nice proprietary VGA port, to which they didn't have an adapter for a long time (6 months or so)....now, the adapters exist, but they're out of stock. I bought a USB to VGA adaptor at Microcenter for about $70.

Making Drupal Dance: Techniques for Non-obvious Theme Manipulations

John Albin Wilkins presents "Making Drupal Dance: Techniques for Non-obvious Theme Manipulations at the 2009 Design 4 Drupal conference in Boston. Unfortunately the beginning is cut off; however there is still over 40 minutes of video and plenty of good information in the video.

Video: MySQL 5.4

Giuseppe Maxia spoke at the May 2009 Boston MySQL User Group about MySQL 5.4 and what it can do, the new performance features, etc.

SPIDER Storage Engine: Database Sharding by Storage Engine

Video for the presentation at the 2009 MySQL Conference:
SPIDER Storage Engine: Database Sharding by Storage Engine
Kentoku SHIBA (ST Global.,Inc)

The official conference page is at
http://www.mysqlconf.com/mysql2009/public/schedule/detail/6837

Download the slides (ZIP archive).

Video: The State of Open Source Databases Brian Aker

Video for the presentation at the 2009 MySQL Camp:
Closing Keynote: The State of Open Source Databases
Brian Aker, Sun Microsystems

Unleash the Power of Your Data Using Open Source Business Intelligence

Video for the presentation at the 2009 MySQL Conference:

Unleash the Power of Your Data Using Open Source Business Intelligence
Christopher Lavigne (Breadboard BI, Inc.)

The official conference description is at: http://www.mysqlconf.com/mysql2009/public/schedule/detail/5593

Download the PPT slides.

Video: Map/Reduce and Queues for MySQL Using Gearman

Video for the presentation at the 2009 MySQL Conference:
Map/Reduce and Queues for MySQL Using Gearman
Eric Day (Sun Microsystems), Brian Aker (Sun Microsystems, Inc.)

The official conference page is at
http://www.mysqlconf.com/mysql2009/public/schedule/detail/7346

Download the PDF slides.

Video: Optimizing MySQL Performance with ZFS

Video for the presentation at the 2009 MySQL Conference:

Optimizing MySQL Performance with ZFS
Allan Packer (Sun Microsystems), Neelakanth Nadgir (Sun Microsystems)

The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7121

Watch the video at

Video: Top 10 MySQL Pet Peeves and How to Workaround Them

Video for the presentation at the 2009 MySQL Camp:
Top 10 MySQL Pet Peeves and How to Workaround Them
Jeremy Zawodny

Watch it online here:

Download the 106 Mb .mov file at <

Video: Grand Tour of the Information Schema and its Applications

Video for the presentation at the 2009 MySQL Camp:
Grand Tour of the Information Schema and its Applications
Roland Bouman

Description:
The following topics will be covered:
- Introduction of the information schema and it’s components
- How to generate WIKI documentation from the information schema
- Generating code (triggers, SPs) to maintain a rich history database
- Creating a stored procedure to check violated foreign key constraints
- Creating a stored procedure to create federated tables

Crash Recovery and Media Recovery in InnoDB

Video for the presentation at the 2009 MySQL Conference:
Crash Recovery and Media Recovery in InnoDB
Heikki Tuuri (Innobase / Oracle Corp.)

The official conference page is at
http://www.mysqlconf.com/mysql2009/public/schedule/detail/6843

Video: ScaleDB Storage Engine

Video for the presentation at the 2009 MySQL Conference:

The ScaleDB Storage Engine: Enabling High Performance and Scalability Using Materialized Views and a Shared-Disk Clustering Architecture
Moshe Shadmon (ScaleDB)

Slides

The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7112