Server Tuning

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.

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.

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: Beginner Guide to Website Performance with MySQL and memcached

Video for the presentation at the 2009 MySQL Conference:

Beginner's Guide to Website Performance with MySQL and memcached
Adam Donnison (Sun Microsystems)

Slides

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

Video: Testing with the MySQL Random Query Generator

Video from the 2009 MySQL Conference presentation:

If You Love It, Break It: Testing MySQL with the Random Query Generator Philip Stoev (Sun Microsystems)

The description is at:
http://www.mysqlconf.com/mysql2009/public/schedule/detail/6363

Download the presentation slides (ppt).

Video: Understanding How MySQL Works by Understanding Metadata, part 2

Part 2 of "Understanding How MySQL Works by Understanding Metadata", presented by Sheeri K. Cabral (The Pythian Group) and Patrick Galbraith (Lycos Inc.). This was a 3-hour tutorial.

The PDF of the slides can be found at http://technocation.org/files/doc/2009_04_Understanding.pdf.

From the official abstract at http://www.mysqlconf.com/mysql2009/public/schedule/detail/5682:

We have spent countless hours researching over 1,000 pieces of metadata. In the process, we have learned a lot about how MySQL works, and realized that it was a pretty good learning method.

Video: Understanding How MySQL Works by Understanding Metadata, part 1

Part 1 of "Understanding How MySQL Works by Understanding Metadata", presented by Sheeri K. Cabral (The Pythian Group) and Patrick Galbraith (Lycos Inc.). This was a 3-hour tutorial.

The PDF of the slides can be found at http://technocation.org/files/doc/2009_04_Understanding.pdf.

From the official abstract at http://www.mysqlconf.com/mysql2009/public/schedule/detail/5682:

We have spent countless hours researching over 1,000 pieces of metadata. In the process, we have learned a lot about how MySQL works, and realized that it was a pretty good learning method.

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.

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.

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: http://technocation.org/files/doc/stophatingmysql.pdf View the video online at http://technocation.org/node/646/play or download the 202.5 MB Flash video file (.flv) directly at http://technocation.org/node/646/download. 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. Why you want to switch to MySQL 5.1 How MySQL Uses Memory Query Cache Configuration EXPLAIN manual page EXPLAIN cheatsheet

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.

The Top 20 Design Tips for Enterprise Data Architects

At the 2008 MySQL Conference and Expo, Ronald Bradford delivered "The Top 20 Design Tips for Enterprise Data Architects". See the slides on the Forge at http://forge.mysql.com/wiki/MySQLConf2008ThursdayNotes#Top_20_DB_Design_Tips_Every_Architect_Needs_to_Know

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: Optimizing MySQL and InnoDB on Solaris 10 for World's Largest Photo Blogging Community

At the 2008 MySQL User Conference and Expo, Farhan Mashraqi spoke about "Optimizing MySQL and InnoDB on Solaris 10 for World's Largest Photo Blogging Community". Download the slides, see people's notes, and more on the MySQL Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008ThursdayNotes#Optimizing_MySQL_and_InnoDB_on_Solaris_10_for_World.27s_Largest_Photo_Blogging_Community