Personal schedule for Ben Black
Download or subscribe to Ben Black's schedule.
Architecture and Technology,
Performance Tuning and Benchmarking,
Security and Database Administration,
Tutorial
Location: Ballroom G
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.
Architecture and Technology,
Performance Tuning and Benchmarking,
Security and Database Administration,
Tutorial
Location: Ballroom B
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.
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.
Architecture and Technology,
Replication and Scale-Out,
Security and Database Administration
Location: Ballroom D
Location: Ballroom D
Ben Black (Garmin),
Mark Filipi (Garmin International)
Average rating:
(3.00, 3 ratings)
Running multiple MySQL instances on the same hardware can be useful in a number of cases.
Some uses are rapid creation of test instances, consolidating several instances, mixing masters and slaves for redundancy and to balance load, and better hardware utilization. We will cover aspects including load balancing, LVM, repeatable builds, ports, proxy, and problems we encountered along the way.
Read more.
Architecture and Technology,
General,
Replication and Scale-Out,
Security and Database Administration
Location: Ballroom D
Location: Ballroom D
Baron Schwartz (VividCortex Inc)
Average rating:
(4.12, 8 ratings)
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.
Read more.
Robert Hodges (Continuent.com),
Jay Pipes (Rackspace Cloud)
Average rating:
(3.20, 5 ratings)
Replication is big news and not just because of built-in replication from MySQL itself. Projects like Drizzle, Tungsten, and Galera are changing the replication game with higher speed and greater flexibility than ever before. Join Jay Pipes (Drizzle Replication API) and Robert Hodges (Tungsten Clustering) for a tour of the new replication solutions and how they can help your applications.
Read more.
Sarah Sproehnle (Cloudera, Inc.)
Average rating:
(4.00, 11 ratings)
This talk is for developers or administrators who need to make their queries faster.
Read more.
Yoshinori Matsunobu (DeNA)
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.
Database operations gets interesting when it involves several thousand databases, a high-profile site and you have a small core team of DBAs. Among other things, we will give a high-level overview of Facebook database architecture, Backup (and recovery) strategy and the mysql upgrade process.
Read more.
Architecture and Technology,
Performance Tuning and Benchmarking,
Security and Database Administration
Location: Ballroom F
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.
Architecture and Technology,
Performance Tuning and Benchmarking,
Storage Engine Development and Optimization
Location: Ballroom E
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.
Architecture and Technology,
MySQL Cluster and High Availability,
Replication and Scale-Out,
Security and Database Administration
Location: Ballroom C
Location: Ballroom C
Nicklas Westerlund (Electronic Arts)
Average rating:
(2.50, 6 ratings)
Want to learn what the difference between a 10 server deployment and a 200 server deployment is in terms of administration? Best practices in large deployments? Got questions on centralized management and change management? Capacity planning? All these subjects and more will be covered in this session
Read more.
Architecture and Technology,
Performance Tuning and Benchmarking,
Storage Engine Development and Optimization
Location: Ballroom E
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.
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.
Average rating:
(4.06, 18 ratings)
Facebook runs MySQL on commodity servers. Commodity servers have become extremely fast. Learn about the methods we use to identify performance bottlenecks in MySQL and the projects we have completed or started to keep pace with hardware advances.
Read more.
Danil Zburivsky (The Pythian Group)
Average rating:
(4.00, 3 ratings)
Are you ensuring that a slave has the same data is the same as its master? Using mk-table-checksum from Ma'atkit as the basic tool, we will show you how to check that your data is in sync -- in a non-invasive way. We will share the tricks, tips and gotchas we have learned deploying this method in several different environments and schemas.
Read more.
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.
Brian Miezejewski (MySQL)
Average rating:
(4.00, 2 ratings)
There are many examples and posts on how to use partitioning in MySQL, but little information on when to use it and how to apply it to typical business problems. This talk focusses on when to use partitioning, what type to use, and what are the best practices in using the different types of MySQL partitioning.
Read more.
Mats Kindahl (Oracle),
Lars Thalmann (Oracle)
Average rating:
(3.00, 5 ratings)
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.
Read more.
LAMP,
Performance Tuning and Benchmarking,
Storage Engine Development and Optimization
Location: Ballroom A
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.
Founding Sponsor
Platinum Sponsor
Gold Sponsors
Joint Gold Sponsors
Premier Media Partner
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.
O'Reilly Home | Privacy Policy | Contact Us | Sitemap | conf-webmaster@oreilly.com
© 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.