Query Optimization

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.

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.

Video: Addressing Challenges of Data Warehousing - a Panel Discussion

At the 2008 MySQL Conference and Expo, there was a panel discussion on "Addressing Challenges of Data Warehousing - a Panel Discussion" including:

Robin Schumacher (Sun/MySQL) (moderator)

Brian Miezejewski (MySQL), Charles Hooper (Pro Relational Systems), Paul Whittington (NitroSecurity, Inc.), Raj Cherabuddi (Kickfire), Victoria Eastwood (InfoBright Inc.)

Video: The MySQL Query Cache

At the 2008 MySQL User Conference and Expo, Baron Schwartz spoke on "The MySQL Query Cache". Download the slides, see people's notes, and more on the MySQL Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008WednesdayNotes#The_MySQL_Query_Cache

MySQL Proxy Presentation at the September 2007 Boston MySQL User Group

I have finally managed to watch and slightly edit the September 2007 Boston MySQL User Group presentation I did on the MySQL Proxy.

It's geared towards beginners, and has lots of examples, including explaining some of the examples that come bundled with the MySQL Proxy.

Video on YouTube.


Some resources:
Presentation Slides PowerPoint (ppt) or PDF or Flash (swf)