Schedule: Performance Tuning and Benchmarking sessions

Add to your personal schedule
Location: Ballroom B
Sheeri K. Cabral (Mozilla Foundation)
Average rating: ***..
(3.25, 4 ratings)
Unlock all the information the MySQL server can give you! MySQL has many status variables that show how well your environment utilizes its resources. There are many system variables that can be set and changed to tune the server. Read more.
Add to your personal schedule
Location: Ballroom G
Baron Schwartz (VividCortex Inc), Morgan Tocker (Percona, Inc.)
Average rating: ****.
(4.33, 18 ratings)
This tutorial focuses on the diagnostic tools you can turn to when confronted with an unexplained performance problem. Tools explained include iostat, vmstat, and mk-query-digest. The emphasis is on practical usage under pressure, and less on performance theory. Read more.
Add to your personal schedule
Location: Ballroom G
Peter Zaitsev (Percona Inc)
Average rating: ***..
(3.07, 14 ratings)
Scaling Applications with Caching, Sharding and Replication Read more.
Add to your personal schedule
Location: Ballroom B
Sheeri K. Cabral (Mozilla Foundation)
Average rating: ***..
(3.38, 8 ratings)
Unlock all the information the MySQL server can give you! MySQL has many status variables that show how well your environment utilizes its resources. There are many system variables that can be set and changed to tune the server. Read more.
Add to your personal schedule
Location: Ballroom C
Rob Young (Oracle/MySQL ), Mikael Ronstrom (MySQL)
Average rating: **...
(2.78, 9 ratings)
Join the MySQL and InnoDB Engineering teams as they describe the low-level technical details behind the MySQL 5.5 performance and scalability gains. Read more.
Add to your personal schedule
Location: Ballroom A
Padraig O'Sullivan (Akiban Technologies Inc.)
Average rating: ****.
(4.00, 5 ratings)
Drizzle and MySQL both have a number of static DTrace probes embedded within them which allows observability tools to gain deep insight into what the server is doing. In this session, an overview of these static probes will be given and examples of utilizing these probes will be shown using both DTrace on Solaris and SystemTap on Linux. Read more.
Add to your personal schedule
Location: Ballroom F
Peter Gulutzan (MySQL AB)
Average rating: ***..
(3.70, 10 ratings)
Performance Schema is a major new MySQL Server feature which shows where we're going with monitoring and performance measurement. Read more.
Add to your personal schedule
Location: Ballroom C
Baron Schwartz (VividCortex Inc)
Average rating: ****.
(4.27, 11 ratings)
MySQL's EXPLAIN output is rich with information, but can be difficult to understand. This session helps EXPLAIN make sense by showing how it reveals the server's estimated query execution plan. Read more.
Add to your personal schedule
Location: Ballroom B
Jimmy Yang (Oracle Corporation)
Average rating: **...
(2.60, 15 ratings)
At this session, we will talk about current interfaces of the InnoDB monitoring system, including server status variables, information schema table, as well as table and space monitor. We will also discuss how to utilize these information to better understand the system running state. Read more.
Add to your personal schedule
Location: Ballroom B
Mark Matthews (Oracle), Todd Farmer (Oracle Corporation)
Average rating: **...
(2.40, 5 ratings)
Learn about the features built into MySQL Connector/J targeted at scalability and reliability. The session will cover fault tolerant load balancing, replication-aware load balancing with slave fail-over, custom exception handling and some creative use of statement interceptors mixed with the built-in load balancer to implement sharding. Read more.
Add to your personal schedule
Location: Ballroom C
Roland Bouman (XCDSQL Solutions / Strukton Rail)
Average rating: ***..
(3.75, 8 ratings)
Many casually written stored routines are unnecessarily slow. By observing a few principles, you can gain substantive benefits for performance and maintainability of your stored routines. By applying step-wise improvements to real-world examples you will become aware of potential problems in your own stored routines and learn how to refactor them to increase performance and maintainability. Read more.
Add to your personal schedule
Location: Ballroom E
Vadim Tkachenko (Percona Inc), Morgan Tocker (Percona, Inc.)
Average rating: ***..
(3.50, 6 ratings)
Flash storage has gone from an experimental buzzword to a major new storage technology so fast that it is hard to understand what is on the market. This is a comprehensive comparison of what's available today. Read more.
Add to your personal schedule
Location: Ballroom F
Matt Yonkovit (Percona)
Average rating: ****.
(4.57, 7 ratings)
A lot of companies do not have a dedicated DBA, rather they rely on sysadmins, web developers, or others to put the DBA hat on five minutes at a time. This session is designed to provide these people the basic DBA tips and tricks they need to be successful. What are the most important parameters? What sort of hardware should the database run on? When I have a problem where do I look? Read more.
Add to your personal schedule
Location: Ballroom B
Average rating: ****.
(4.56, 18 ratings)
Many people know Linux terminologies such as ext3, tmpfs, cfq io scheduler, OOM killer, etc. But many times it is not appropriately configured. In this session, the speaker will show Linux performance tuning and stabilization practices for MySQL, such as how to avoid OOM Killer, performance difference between I/O schedulers, tuning Linux kernel parameters, profiling with SystemTap, etc. Read more.
Add to your personal schedule
Location: Ballroom F
Morgan Tocker (Percona, Inc.)
Average rating: ****.
(4.38, 8 ratings)
Disks are often credited with being the biggest performance bottleneck to any database system. This session introduces you to Linux diagnostic tools, hardware purchasing options, and how you should be thinking about IO. Read more.
Add to your personal schedule
Location: Ballroom A
Average rating: ***..
(3.43, 7 ratings)
Description: In this session, the speaker will explain some important but not well known indexing topics. Advanced topics such as indexes and lock contentions, how indexes impact MySQL optimizer will be covered. This session is the sequel to "Mastering the Art of Indexing" (http://www.mysqlconf.com/mysql2009/public/schedule/detail/6661), presented at the last MySQL Conference. Read more.
Add to your personal schedule
Location: Ballroom D
Johan Andersson (SUN MySQL), Jimmy Guerrero (Oracle-MySQL)
Average rating: ****.
(4.75, 4 ratings)
Are you experiencing current performance bottlenecks in your high availability applications ? Are you designing a new mission-critical application and want to know how best to structure your schema and index strategy for optimal performance? Interested in how to transform your SQL into faster, more efficient queries? Read more.
Add to your personal schedule
Location: Ballroom E
Chris Schneider (Ning.com)
Average rating: ***..
(3.50, 4 ratings)
Ever wanted to de-fragment your data set to regain disk space and increase performance? Ever needed to add or change an index on a large table? Ever needed to change a primary key? If you answered yes to any of these and you already know a lot about MySQL then this talk is for you! Read more.
Add to your personal schedule
Location: Ballroom F
Harrison Fisk (Facebook)
Average rating: ****.
(4.08, 13 ratings)
InnoDB provides many sources of diagnostic information. Filtering through that information to find what is wrong with a system can be a big task. This talk with detail all of the different sources and what useful information you can get from them. In addition, it will offer common solutions for these problems to get you started in the right direction. Read more.
Add to your personal schedule
Location: Ballroom E
Peter Zaitsev (Percona Inc)
Average rating: ****.
(4.00, 9 ratings)
This presentation will teach you the InnoDB internals you need to know for performance optimization and operational tasks. You'll learn topics such as how InnoDB allocates space on the filesystem and in memory, how InnoDB recovery works, and how MVCC and locking work. Read more.
Add to your personal schedule
Location: Ballroom F
Dimitri KRAVTCHUK (Sun Microsystems / Oracle)
Average rating: ****.
(4.50, 2 ratings)
dim_STAT is a very powerful tool to monitor and analyze everything you need from your server. This presentation will cover MySQL oriented solutions integrated within dim_STAT. Read more.
Add to your personal schedule
Location: Ballroom D
Sumeet Bansal (Fusion-io), Ryan White (Cloudmark), Dan Marriott (Answers.com), Vadim Tkachenko (Percona Inc), Jeremy Zawodny (craigslist.org)
Average rating: ***..
(3.17, 6 ratings)
This panel discussion, moderated by Sumeet Bansal, principal solutions architect for Fusion-io, the solid-state storage provider, will make clear to audience members the benefits of solid-state technologies, both from a performance standpoint and in relation to TCO. Q&A with the panel to follow. Participants include panelists from Answers.com, Cloudmark, Percona and Craigslist.org. Read more.
Add to your personal schedule
Location: Ballroom E
Peter Zaitsev (Percona Inc)
Average rating: ****.
(4.33, 6 ratings)
This presentation will teach you the InnoDB internals you need to know for performance optimization and operational tasks. You'll learn topics such as how InnoDB allocates space on the filesystem and in memory, how InnoDB recovery works, and how MVCC and locking work. Read more.
Add to your personal schedule
Location: Ballroom H
Andrew Aksyonoff (Sphinx Technologies)
Average rating: **...
(2.67, 3 ratings)
Sphinx is a FOSS full-text search engine that makes searching MySQL databases a breeze. This talk covers a number of recently developed advanced Sphinx features (RT indexes, parallel searching improvements, subquery caches, hitless indexes, "blended" indexing, SphinxQL interface, etc) in detail, explaining how and why to use them in your application. Read more.
Add to your personal schedule
Location: Ballroom C
Calvin Sun (Twitter), Jimmy Yang (Oracle Corporation), John Russell (Oracle Corporation)
Average rating: ***..
(3.00, 3 ratings)
There are many exciting performance features in the InnoDB Plugin. But how to best use them? What are the caveats? At this session, we will describe those performance features in depth. We will also present benchmark results that explore the performance of those features. Read more.
Add to your personal schedule
Location: Ballroom D
Peter Zaitsev (Percona Inc)
Average rating: ****.
(4.80, 5 ratings)
The best way to understand your application's performance is to have good performance instrumentation in your application. This session will teach you how and where to instrument your application, and how to analyze the results. Read more.
Add to your personal schedule
Location: Ballroom B
Baron Schwartz (VividCortex Inc)
Average rating: ****.
(4.25, 4 ratings)
This session shows you how to get rich historical data about your MySQL server's performance and usage with the open-source Cacti graphing tool. Best of all, it's easy, open-source, and free -- so you can stop flying blind. Read more.
Add to your personal schedule
Location: Ballroom A
Sheeri K. Cabral (Mozilla Foundation)
Average rating: ***..
(3.50, 4 ratings)
Query reviews are a great way to find potentially slow queries before they become a problem. A query review is like a code review, except instead of reviewing code, queries are reviewed. This presentation will show you how to use the Maatkit tool mk-query-digest to create a digest of queries. This digest can be a one-off report, or it can be saved to a database table. Read more.
Add to your personal schedule
Location: Ballroom D
Ronald Bradford (EffectiveMySQL)
Average rating: ***..
(3.00, 3 ratings)
Taking a client from a minimum 700ms, and at times 1-2 seconds front page load time to a consistent 60ms is a great success story for the improvements possible in optimizing database performance. In this presentation we will outline the steps taken and what can be applied to any website as one possible model to use in evaluation of your website, as well as provide specific examples. Read more.
Add to your personal schedule
Location: Ballroom E
Average rating: ****.
(4.75, 4 ratings)
This session is about SSD deployment strategies for MySQL. For example, is it fine to store all files on SSD or is it faster to store some files (i.e. binary log files) on HDD? Is RAID 5 SSD fast enough? Do traditional H/W raid cards perform well for many(4-8) SSDs? Do MyISAM/InnoDB/other engines work well for SSD? I'll talk about these topics based on many kinds of recent benchmarking results. Read more.
Add to your personal schedule
Location: Ballroom F
Yasufumi Kinoshita (Percona Inc.)
Average rating: ***..
(3.00, 8 ratings)
This session describes how to tune InnoDB based mainly on 'SHOW ENGINE INNODB STATUS' outputs. The current version of InnoDB Plugin and XtraDB have various tunable options. It will be cleared how the tuning options improves the performance for what condition. The improvement is also demonstrated by the results of some benchmark workloads. Read more.
Add to your personal schedule
Location: Ballroom A
Peter Zaitsev (Percona Inc)
Average rating: ***..
(3.20, 5 ratings)
Wondering how to build a good foundation for running MySQL? This session will teach you what you need to know. Read more.
Add to your personal schedule
Location: Ballroom C
Gerardo Narvaja (SkySQL Inc.)
Discuss what to look at when regular monitoring information is not descriptive enough. Review how to obtain useful status snapshots and how to interpret the results using real world examples covering items like: replication health, memory allocation, network issues and performance. Read more.
Add to your personal schedule
Location: Ballroom F
Alan Kasindorf (Six Apart)
Average rating: ***..
(3.00, 1 rating)
Monitoring usage, efficiency, and performance of memcached can seem like a dark art. For most people, configuring a RAM limit and shoving in data is as far as they need to go. If you need to know more about how efficiently you are using memcached, as well as how all the statistics line up to make a big picture, this is the place. Read more.
  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Download the O'Reilly MySQL Conference & Expo 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@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.