Schedule: Performance Tuning and Benchmarks sessions

Location: Ballroom G Level: Intermediate
Tom Hanlon (Functional Media)
Average rating: **...
(2.60, 10 ratings)
Setting realistic expectations and choosing appropriate architectures rely on having solid benchmarks. This tutorial will show you how to use the available tools. In addition once you have built your application monitoring is key. Join us while we give you a three hour tour of the tools available. Tools such as mysqlslap, supersmack, jmeter, xenoss, enterprise monitor, nagios and more. Read more.
Location: Ballroom H Level: Intermediate
Alan Kasindorf (Six Apart), Brian Aker (HP)
Average rating: ****.
(4.20, 5 ratings)
The original memcached tutorial has done its rounds around the globe, and it's time for round two. Quickly get up to speed with integration and tuning examples, then dive into new topics and community tricks. See how the new binary protocol and storage engine interfaces can solve hard problems. Read more.
Location: Ballroom B Level: Novice
Michael G. Zinner (Sun Microsystems), Max Mether (MySQL), Mike Hillyer (Message Systems)
Regardless if you are a newbie to the MySQL database or you have been using MySQL for years already - this is your chance to learn professional database schema design from the MySQL experts. Get fluent on the basic modeling concepts, learn all about the performance tricks and become a pro in using MySQL Workbench, making database design and maintenance most efficient. Reserve your seat now! Read more.
Location: Ballroom H Level: Intermediate
Sheeri K. Cabral (Mozilla Foundation), Patrick Galbraith (Hewlett Packard)
Average rating: ***..
(3.29, 7 ratings)
You don't have to read source code -- understanding how MySQL works can be achieved through the system data. Learn a wide range of topics in this 3-hour tutorial, and leave armed with tons of knowledge about how MySQL 5.0, 5.1 and 6.0 work. You will take home a healthy understanding of performance tuning, storage engines, replication and many tips and tricks to help you be a better DBA. Read more.
Location: Ballroom A Level: Novice
Allan Packer (Sun Microsystems), Mikael Ronstrom (MySQL)
Average rating: ***..
(3.40, 5 ratings)
This session describes the joint Sun/MySQL performance & scalability project. We will look at the key performance issues, what has been achieved so far and share initial results. We will indicate some of what's on the roadmap for the immediate future. Wherever possible, best practices and recommendations for achieving optimal performance will be offered. Read more.
Location: Ballroom F Level: Intermediate
Mark Matthews (Oracle)
Average rating: ****.
(4.00, 1 rating)
Connector/J has a wealth of under-promoted performance features. Come to this session to learn about bulk data loading, load balancing, batch rewriting and the "reckless but really fast" options that C/J has. Read more.
Location: Ballroom C Level: Expert
Philip Stoev (Sun Microsystems)
Average rating: ****.
(4.00, 3 ratings)
This session will present the Random Query Generator, a new tool for database workload generation for the purpose of stress testing. Read more.
Location: Ballroom F Level: Novice
MC Brown (Sun Microsystems)
Average rating: **...
(2.75, 4 ratings)
Query analysis can help highlight issues in the SQL in your application, but there are many ways of getting that information. Obvious choices are explain and the slow-query log, but newer solutions, such as live query monitoring, mysql proxy and DTrace provide additional benefits. Read more.
Location: Ballroom F Level: Intermediate
Average rating: ****.
(4.17, 6 ratings)
Indexes are known to speed up retrievals, but do you know that sometimes looking at the indexes is sufficient to get the data you need ? This session will help you understand the principles of covering indexes, their benefits and the situations where you should avoid them. Read more.
Location: Ballroom B Level: Intermediate
Vince Carbone (Sun Microsystems, Inc), Mikael Ronstrom (MySQL)
Average rating: ***..
(3.00, 1 rating)
This session will introduce DTrace, OpenSolaris's Dynamic Trace Facility, which can be used to give unprecedented access to the inner workings of MySQL. We will explore specific MySQL DTrace probes and the DTrace pid provider, which allows the gathering of information about any function within a process. Read more.
Location: Ballroom B Level: Intermediate
Sergey Petrunia (MySQL)
Average rating: **...
(2.75, 4 ratings)
This is a query optimization troubleshooting roadmap, presented by one of the MySQL optimizer developers. First, we'll give an overview of available query execution strategies and how they are (or aren't) shown in the EXPLAIN output. Second, we'll show how one can find out what the optimizer got wrong. Third, we'll discuss what means one can use to make the optimizer pick the right query plan. Read more.
Location: Ballroom D Level: Intermediate
Michael McFadden (
Average rating: ****.
(4.00, 2 ratings)
Any application with frequent polling and extensive archiving needs has run into the situation of ‘too much data’. Tables become huge and unsearchable, performance goes down, and over time the cost to store this data adds up. This session covers data smoothing techniques including SQL query side solutions that reduce resolution for data archival storage for more efficient application performance. Read more.
Location: Ballroom A Level: Intermediate
Average rating: ****.
(4.71, 7 ratings)
Everybody knows that indexes can boost SELECT performance, but how do you verify that you are using index correctly? In this session, I'll explain detailed mechanism of traditional MySQL B+Tree indexes, optimizer plans, and how to boost performance. Not only speeding up SELECT, but also speeding INSERT are covered. Read more.
Location: Ballroom G Level: Novice
Mark Leith (MySQL)
Average rating: ***..
(3.50, 2 ratings)
MySQL Enterprise Monitor provides a plethora of base Advisors, Graphs and Data Collections for DBAs and Developers. However, have you ever wanted to extend these to suit your environment more closely? Read more.
Location: Ballroom E Level: Intermediate
Alexander Rubin (MySQL)
Average rating: **...
(2.67, 3 ratings)
From this presentation you will know how to create a scalable full text search solution with MySQL, how to tune MySQL full text search for maximum performance, how to integrate MySQL with external search solutions and much more. Read more.
Location: Ballroom A Level: Intermediate
Discussion on solid state disk and how it will change the high performance industry. View pretty graphs and benchmarks that will dazzle your eyes, with numbers sure to get the purest database performance geek excited. DBT2, sysbench, Orion, and other benchmarks will help highlight the advantages and disadvantages of this new and exciting technology. Read more.
Location: Ballroom D Level: Intermediate
Mark Callaghan (Facebook)
Average rating: ***..
(3.33, 3 ratings)
Amazon EC2 is a new platform on which to run MySQL. This session evaluates the performance possible on the variety of hardware configurations available with EC2. Read more.
Location: Ballroom D Level: Intermediate
Alexey Kopytov (Sun Microsystems)
Average rating: **...
(2.00, 2 ratings)
This session will give an overview of the new set of static DTrace probes introduced in MySQL 6.0 with examples on how to use them in real-life monitoring and performance tuning tasks. Read more.
Location: Ballroom B Level: Novice
Allan Packer (Sun Microsystems), Neelakanth Nadgir (Sun Microsystems)
Average rating: ****.
(4.33, 3 ratings)
ZFS offers many leading-edge features, including automatic protection against silent data corruption, immense capacity, and vastly simplified administration. But how well does it perform with MySQL? This session explores MySQL performance with ZFS compared to alternative file system implementations. The performance implications of ZFS compression and other features are also examined. Read more.
Location: Ballroom C Level: Intermediate
MC Brown (Sun Microsystems)
Average rating: ***..
(3.00, 1 rating)
You can run MySQL on a standard server, but there can be benefits to running MySQL within a virtualized environment. You can take advantage of the isolation it provides, or the performance gains possible by running multiple MySQL instances on one large server. This session will show you the benefits and potential issues of running MySQL in a virtualized environment. Read more.
Location: Ballroom D Level: Expert
Brooks Johnson (Verdiem)
Average rating: ****.
(4.00, 1 rating)
This session demonstrates how partitioning will often reduce overall performance but also demonstrates the operational benefits, such as much faster table optimization. Read more.
Location: Ballroom H Level: Novice
Adam Donnison (Sun Microsystems)
In a classic case of "eat your own dogfood", is a key player in the beta testing of MySQL software, including Query Analyzer. In this presentation web developer Adam Donnison will take you through how he used Quan to improve database performance on the website by orders of magnitude, and why Quan was needed. Read more.
Location: Ballroom H Level: Intermediate
Vadim Tkachenko (Percona Inc), Ewen Fortune (Percona)
InnoDB is well-known and popular, but naturally there's room for improvement. There are many hard-coded constants – what happens if we turn them into command-line parameters? InnoDB is also incredibly complex, with a lot going on under the covers. What algorithms can we change to make InnoDB faster and more scalable, especially on modern hardware? Read more.
Location: Ballroom F Level: Intermediate
Baron Schwartz (VividCortex)
Average rating: ****.
(4.80, 5 ratings)
Maatkit is a set of tools that helps MySQL users and administrators fill otherwise unmet needs. The toolkit is absolutely packed with functionality. This session will teach you how to get your daily work done faster, safer and smarter. Read more.
Location: Ballroom H Level: Intermediate
Florian Haas (LINBIT Information Technologies GmbH), Joachim Worringen (Dolphin Interconnect Solutions)
An updated overview of MySQL High Availability deployment options with DRBD. Covers DRBD for low-latency workloads (leveraging Dolphin Express interconnect technology), four-way replicated storage redundancy, end-to-end replication integrity checking, and more. Read more.

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@

Press and Media

For media-related inquiries, contact Maureen Jennings at

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.