Presentations: Performance Tuning and Benchmarks

Tyler Carlton (LimeWire), Cory Sessions (Nexation, Inc.)
Presentation: 0 to 60 in 3_1 Presentation [PPT]
We did it! Hear how we went from a third party database system to a 60G MySQL Cluster hosting large external web services and intensive internal data applications flawlessly, in three months.
Michael Widenius (Monty Program Ab)
A deep tour into the design of Maria, a new MVCC storage engine for MySQL from the original authors of MySQL that is designed to support transactions and automatic recovery.
Igor Babaev (MySQL)
Batched Key Access is an advanced technique that is able to speed up the execution of queries with multitable joins to the factor of 5 and more.
Tom Hanlon (Cloudera)
Benchmarking and Profiling are extrememly important and a large array of tools exist for the job. Join Tom Hanlon for a tour of the current landscape. Demos of each tool wil be shown.
Tom Hanlon (Cloudera)
Join us for a presentation of the wonderful world of benchmarks and monitoring tools. Here you will learn what is available, how each tool works, and a demonstration using each tool against a running database from a veteran MySQL expert.
Arjen Lentz (Open Query)
A popular and lighthearted session in quiz format. Fun and educational, a broad range of "what not to do" is explored, taking examples from the scary real world.
Ben Rockwood (Joyent Inc)
Presentation: DTrace and MySQL Presentation [PDF]
Noted Solaris and DTrace expert Ben Rockwood will show how to evaluate and introspect MySQL's behavior, and gain information that isn't normally attainable by developers and system administrators.
Baron Schwartz (VividCortex)
Presentation: EXPLAIN Demystified Presentation [PDF]
EXPLAIN is one of MySQL's most-used and least-understood features, and it's not documented fully. This session helps EXPLAIN make sense by showing how it really maps to a query execution plan.
Alexander Rubin (MySQL)
This presentation covers new Full Text Search features in MySQL 5.1. We also show some common tasks and solutions with Full Text Search in MySQL as well as benchmark results.
Mark Callaghan (Facebook)
Mike Callaghan will describe enhancements to InnoDB that improve its scalability on servers with many disks and many CPU cores, results from benchmarks, and results from production systems.
Peter Zaitsev (Percona Inc), Vadim Tkachenko (MySQLPerformanceBlog.com)
You may have heard Innodb has limited scalability with multiple CPUs and some of these were fixed in recent MySQL 5.0 versions. In this presentations we will look into which problems are fixed.
Mariella Di Giacomo (The Hive), Daniel Chote (The Hive), Geoff Harrison (The Hive)
Learn about a horizontal scalable architecture for accessing exponentially growing datasets, and performance results obtained on several filesystems, MySQL storage engines, and partitioning.
Brian Aker (MySQL), Alan Kasindorf (Six Apart)
Presentation: external link
Large MySQL deployments and Memcached go hand and hand. This tutorial details how to get started, the ins and outs of deploying Memcached as a key caching layer in your applications, and how to keep scaling.
Brian Moon (dealnews.com)
Phorum is the message board software used by MySQL. One reason they chose Phorum was because of its speed. We have to use some tricks and fancy SQL to make this happen. Learn how.
Chris Kasten (eBay)
This presentation discusses how MySQL was leveraged to provide a large scale personalization technology platform solution for a site like ebay.com, which processes over 2 billion URL requests per day.
Tobias Asplund (Marin Software), Jay Pipes (Rackspace Cloud)
In this session we'll put features that do the same thing up against each other and see which performs better. We find the optimal way to do smaller things. Everything is backed up by benchmarks and discussion.
Frank Mashraqi (Opportunities)
In this presentation learn how MySQL, InnoDB, and Solaris helped Fotolog gain the top performance it desired as the world's largest photo blogging community through tuning and schema optimizations.
Mikael Ronstrom (MySQL)
Learn about all the tricks required to make MySQL Cluster high performance. This includes using real-time scheduling, batching in all its form, cluster interconnects, and locking threads to CPUs.
Robert Hodges (Continuent.com)
This talk presents new open source tools that allow users to set up and run database scale-out benchmarks easily. Hodges illustrates with benchmark results from your favorite MySQL configurations.
Ask Bjørn Hansen (Develooper)
Presentation: external link
Ask Bjoern Hansen will be covering the overall platform and architecture considerations involved in tuning applications from a holistic perspective. You'll be shown design scaleable architectures for dynamic, high-volume web sites. Topics covered include caching, scalable database design, replication, load-balancing, and architectural decisions derived from many years of experience.
Dathan Pattishall (Rockyou)
Flickr implemented a real-time collection of referrers to Photos, streams, sets and collections. MySQL myISAM/INNODB, curl, Java are the only component used in the setup and it scales linearly. This talk is about building a model for capacity planning, scaling for triple the request rate, and scaling linearly for an intensive application.
Jeremy Cole (Twitter), Eric Bergen (Proven Scaling LLC)
In this session, Cole and Bergen will take a look at the hardware of recent past, today's hardware, and what hardware trends will become interesting during 2008 and beyond.
Bill Karwin (Karwin Software Solutions)
Presentation: SQL Antipatterns Presentation [ZIP]
Bill Karwin has answered questions from SQL users for over ten years. Some techniques have emerged as widely used, but flawed, making them brittle, buggy solutions and create security or scalability risks in your projects. In this tutorial, Karwin describes SQL techniques that should be called antipatterns, illustrates their weaknesses, and offers better solutions.
One of the most powerful, yet underutilized MySQL features are User Defined Functions and Aggregates. Learn how to use them to dramatically improve the speed of your data warehouse processing.
Tom Daly (Sun Microsystems, Inc.)
This technical session highlights three benchmark tools that MySQL users and web developers can use to compare, test, and tune MySQL performance: SPECjAppServer2004, EAStress, and FABAN.
Sponsors
  • Kickfire
  • Zmanda, Inc.
  • Continuent
  • EDS
  • JasperSoft
  • Sun Microsystems
  • Symantec Anti-Virus Software
  • XAware
  • Data Direct Technologies
  • Dolphin Interconnect Solutions
  • Hewlett Packard
  • Infobright, Inc
  • Linagora
  • Microsoft
  • OpSource
  • Oracle
  • Pentaho
  • R1Soft
  • Red Hat
  • Ticketmaster
  • TechRepublic

Contact Us

View a complete list of MySQL contacts.