MySQL Forge

Resources for the MySQL Community

MySQLConf2009TuesdayNotes

Contents 1 Tuesday, April 21 1.1 8:30 am - 10:20 am 1.2 10:50 am - 11:35 pm 1.2.1 Camp: Learning from others' MySQL Performance Mistakes 1.2.2 Optimizing MySQL Performance with ZFS 1.2.3 New Replication Features 1.2.4 MySQL and Search at Craigslist 1.2.5 Using the Event Scheduler - The Friendly Behind-the-scenes Helper 1.2.6 Getting the most out of MySQL Enterprise Monitor 2.0 1.2.7 Connector/J Performance Gems 1.3 11:55 am - 12:35 pm 1.3.1 Camp: Intro to XtraDB, a Scalable InnoDB-based Storage Engine 1.3.2 Agile Environments and DBAs 1.3.3 Spatial SQL: who needs a traditional GIS 1.3.4 MySQL Embedded - Getting started with libmysqld 1.3.5 Automated data versioning with a storage engine middleware 1.3.6 MySQL Cluster on Windows 1.3.7 Starring Sakila: data warehousing explained, illustrated and subtitled 1.4 2:00 pm - 2:45 pm 1.4.1 Camp: Grand Tour of the Information Schema and its Applications 1.4.2 Rethinking MySQL, Enter Drizzle 1.4.3 Leveraging MySQL for Efficient Collaboration 1.4.4 If you love it, break it -- testing MySQL with the Random Query Generator 1.4.5 Distributed Innodb Caching with memcached 1.4.6 Falcon Storage Engine - Designed for Speed 1.4.7 How I used Query Analysis to Speed Up my Applications 1.5 3:05 pm - 3:50 pm 1.5.1 Camp: Setting up MySQL on Amazon Web Services (EC2,S3, EBS) 1.5.2 Creating quick and powerful web applications with MySQL, GlassFish, and NetBeans 1.5.3 The PBXT Storage Engine - Meeting Future Challenges 1.5.4 External Stored Procedures Framework for MySQL 1.5.5 Advanced query manipulation with MySQL Proxy 1.5.6 MySQL and the ORM: how far can you get without SQL? 1.5.7 Covering indexes : retrieving data without accessing it 1.6 4:25 pm - 5:10 pm 1.6.1 Camp: Setting up MySQL NBD (MySQL Cluster) Performance Tuning 1.6.2 Mining for insight within two billion visits 1.6.3 Introduction to using DTrace with MySQL 1.6.4 Solving common SQL problems with the SeqEngine 1.6.5 Tricks and Tradeoffs of Deploying MySQL Clusters in the Cloud 1.6.6 MySQL Proxy meets: Binlogs 1.6.7 Not so quiet on the C++ front 1.7 5:15 pm - 6:00 pm 1.7.1 Camp: InnoDB Database Recovery Techniques 1.7.2 MySQL Cluster 6.4 - New Features 1.7.3 Understanding and control of MySQL query optimizer: traditional and novel tools and techniques 1.7.4 Hadoop and MySQL: Friends with Benefits 1.7.5 Faster Data Reduction and Smoothing for Analysis & Archival in MySQL 1.7.6 Scaling a Widget Company 1.7.7 High Performance Ruby on Rails And MySQL

[edit] Tuesday, April 21

[edit] 8:30 am - 10:20 am

(1h 50 min)

• Camp: Closed.
• Conference: TBD (Keynotes in Ballroom E)

[edit] 10:50 am - 11:35 pm

(45 min)

[edit] Camp: Learning from others' MySQL Performance Mistakes

Matt Yonkovit (Sun/MySQL, Waffle Grid, Big DBA Head)

PDF of slides Pythian blog post by Gerry Narvaja about what swappiness is.

[edit] Optimizing MySQL Performance with ZFS

Allan Packer (Sun Microsystems), Neelakanth Nadgir (Sun Microsystems)

[edit] New Replication Features

Lars Thalmann (MySQL), Mats Kindahl (MySQL)

[edit] MySQL and Search at Craigslist

Jeremy Zawodny (craigslist.org)

[edit] Using the Event Scheduler - The Friendly Behind-the-scenes Helper

Giuseppe Maxia (Sun Microsystems Inc), Andrey Hristov (SUN Microsystems)

[edit] Getting the most out of MySQL Enterprise Monitor 2.0

Phil Hildebrand (thePlatform), Ryan Thiessen (Big Fish Games)

[edit] Connector/J Performance Gems

Mark Matthews (MySQL)

[edit] 11:55 am - 12:35 pm

(45 min)

[edit] Camp: Intro to XtraDB, a Scalable InnoDB-based Storage Engine

Vadim Tkachenko, Percona

[edit] Agile Environments and DBAs

Sheeri K. Cabral (The Pythian Group), Laine Campbell (PalominoDB)

[edit] Spatial SQL: who needs a traditional GIS

John Powell (eMapSite)

[edit] MySQL Embedded - Getting started with libmysqld

Anders Karlsson (MySQL )

[edit] Automated data versioning with a storage engine middleware

Peter Volk (DDEngine)

[edit] MySQL Cluster on Windows

Stewart Smith (Sun Microsystems)

[edit] Starring Sakila: data warehousing explained, illustrated and subtitled

Roland Bouman (XCDSQL Solutions / Strukton Rail), Matt Casters (Pentaho Corp.)

[edit] 2:00 pm - 2:45 pm

(45 min)

[edit] Camp: Grand Tour of the Information Schema and its Applications

Roland Bouman

[edit] Rethinking MySQL, Enter Drizzle

Brian Aker (Sun Microsystems)

[edit] Leveraging MySQL for Efficient Collaboration

Boris Burtin (Zimbra Inc.)

[edit] If you love it, break it -- testing MySQL with the Random Query Generator

Philip Stoev (Sun Microsystems)

[edit] Distributed Innodb Caching with memcached

Matthew Yonkovit (MySQL), Yves Trudeau (MySQL)

[edit] Falcon Storage Engine - Designed for Speed

Kevin Lewis (Sun Microsystems), Christopher Powers (MySQL, Inc.)

[edit] How I used Query Analysis to Speed Up my Applications

MC Brown (Sun Microsystems)

[edit] 3:05 pm - 3:50 pm

(45 min)

[edit] Camp: Setting up MySQL on Amazon Web Services (EC2,S3, EBS)

Ronald Bradford - Principal at 42SQL

[edit] Creating quick and powerful web applications with MySQL, GlassFish, and NetBeans

Arun Gupta (Sun Microsystems)

[edit] The PBXT Storage Engine - Meeting Future Challenges

Paul McCullagh (PrimeBase Technologies GmbH)

[edit] External Stored Procedures Framework for MySQL

Antony Curtis (Google Inc)

[edit] Advanced query manipulation with MySQL Proxy

Kay Roepke (Sun Microsystems)

[edit] MySQL and the ORM: how far can you get without SQL?

Jonathan Dahl (Tumblon)

[edit] Covering indexes : retrieving data without accessing it

Stephane Combaudon (SQLI)

[edit] 4:25 pm - 5:10 pm

(45 min)

[edit] Camp: Setting up MySQL NBD (MySQL Cluster) Performance Tuning

Yves Trudeau (Sun/MySQL, Waffle Grid, Big DBA Head)

[edit] Mining for insight within two billion visits

Osma Ahvenlampi (Sulake)

[edit] Introduction to using DTrace with MySQL

Vince Carbone (Sun Microsystems, Inc), Mikael Ronstrom (MySQL)

[edit] Solving common SQL problems with the SeqEngine

Beat Vontobel (MeteoNews AG) SeqEngine Website

[edit] Tricks and Tradeoffs of Deploying MySQL Clusters in the Cloud

Thorsten von Eicken (RightScale, Inc)

[edit] MySQL Proxy meets: Binlogs

Jan Kneschke (MySQL)

[edit] Not so quiet on the C++ front

Andrey Hristov (SUN Microsystems)

[edit] 5:15 pm - 6:00 pm

(45 min)

[edit] Camp: InnoDB Database Recovery Techniques

Peter Zaitsev (Percona)

[edit] MySQL Cluster 6.4 - New Features

Johan Andersson (SUN MySQL)

[edit] Understanding and control of MySQL query optimizer: traditional and novel tools and techniques

Sergey Petrunia (MySQL)

[edit] Hadoop and MySQL: Friends with Benefits

Frank Mashraqi (NetEdge)

[edit] Faster Data Reduction and Smoothing for Analysis & Archival in MySQL

Michael McFadden (Sciencelogic.com)

[edit] Scaling a Widget Company

Dathan Pattishall (Rockyou)

[edit] High Performance Ruby on Rails And MySQL

David Berube (Berube Consulting)