Presentations: General
Below is a list of confirmed Sessions. Sessions are being confirmed daily, so please check back for new additions to the program. Session content is subject to change.
Johan Andersson (SUN MySQL)
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?
Ronald Bradford (42SQL)
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.
Kentoku SHIBA (Free)
Spider and Vertical Partitioning Storage Engine will be introduced by Giuseppe in this Conference.
In this session, I'll introduce some additional tips for joinable database sharding using Spider and Vertical Partitioning.
Robert Hamel (Pythian)
Learn how to find your database problems more quickly without special software. Automatically tracking all database changes and keeping a historical record enables you to figure out problems faster, reducing downtime for critical production systems. Existing monitoring systems are very good at detecting actual errors but not very good at telling you what triggered your performance issue
Robert Hamel (Pythian)
We will present a comparative study about the functionality and performance in a data warehouse context. We will compare standard MySQL storage engines, traditional MySQL data warehousing techniques, and Calpont's InfiniDB. The areas of comparison include: data loading, reporting/DDL/DML performance, available data types and archiving.
Baron Schwartz (Percona Inc.)
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.
Padraig O'Sullivan (Akiba Technologies Inc.)
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.
Johan Andersson (SUN MySQL)
Getting the most out of your MySQL Cluster (NDB) deployment
Geert Vanderkelen (Sun Microsystems)
Lets unleash MySQL Cluster information on people by starting with the
very basics!
This talk will give you an idea on what great tool MySQL Cluster and how it can help you reach high availability.
We'll show you how it works without going to much in the technical
details. Showing off where it make sense to deploy, and stress points
where you should not use Cluster (yet).
Baron Schwartz (Percona Inc.)
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.
Mats Kindahl (Sun Microsystems),
Lars Thalmann (MySQL)
In this talk, the developers behind MySQL Replication walk through some of the new Replication features of MySQL 5.5
Roland Bouman (XCDSQL Solutions / Strukton Rail)
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.
Fernando Ipar (Percona)
If you're using or planning to use an Object-Relational Mapping (ORM) library
for PHP, this talk is for you. We'll survey common ORMs available and see how to use them,
including relevant design patterns.
Additionally, we'll examine potential pitfalls that can lead to poor performance and other side
effects if you use ORMs in their default manner or without understanding what they do.
Baron Schwartz (Percona Inc.)
Are you interested in splitting your application's reads and writes, so writes go to the master and SELECT queries go to slaves? This session is for you. Learn common patterns, pitfalls, and solutions.
Mats Kindahl (Sun Microsystems),
Lars Thalmann (MySQL)
Replication is a versatile tool to use in your toolbox. It can be used to solve many problems modern web architectures, as well as various ways to simplify maintenance.
Mark Matthews (Sun Microsystems),
Todd Farmer (Sun Microsystems)
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.
Giuseppe Maxia (Sun Microsystems)
The Spider storage engine, a plugin for MySQL 5.1 and later, is an extension of partitioning. Using this engine, the user can deal transparently with multiple backends in the server layer.
Sheeri K. Cabral (The Pythian Group)
MySQL data types do not support the SQL standard WITH TIME ZONE attribute. How do you store times in MySQL to efficiently show your customers times in their own time zone?
Sarah Sproehnle (Sun Microsystems)
This talk is for developers or administrators who need to make their queries faster.
Brian Moon (dealnews.com)
Memcached has become the de facto standard for caching web applications. But, many users jump in feet first without understanding what it does or perhaps more importantly what it does not do. Once you understand memcached, you may come to realize that it is what it does not do that makes it so good.
Founding Sponsor
Platinum Sponsor
Gold Sponsors
Premier Media Partners
Sponsorship Opportunities
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at [email protected]
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 [email protected]
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.
O'Reilly Home | Privacy Policy | Contact Us | Sitemap | [email protected]
Event Software Powered by Expectnation
© 2010, O'Reilly Media, Inc. | (707) 827-7000 / (800) 998-9938
O’Reilly and the O'Reilly logo are trademarks of O'Reilly Media, Inc. All other trademarks are property of their respective owners.