DTrace Support in MySQL: Guide to Solving Real-life Performance Problems

Performance Tuning and Benchmarks
Location: Ballroom D Level: Intermediate
Average rating: **...
(2.00, 2 ratings)

DTrace has revolutionized the traditional approaches to monitoring and performance tuning. While it can be used to get a wide spectrum of information from a MySQL server even without embedded probes, this process is often complicated by the need to have a deep knowledge of the server internals, and a lack of low-level details in the information provided by the system probes.

The introduction of static DTrace probes in MySQL 6.0.8 makes collecting and aggregating performance statistics easier by exposing internal data from a MySQL server in a more transparent and user-friendly way.

This session will give an overview of the new set of static probes available in MySQL 6.0 and the possibilities they are opening. We will look at examples of D scripts to collect various per-thread, per-user, per-table or per-query statistics. There will also be a hands-on guide on using both system and MySQL static probes to answer the most frequently encountered performance questions:

- Where does a query spend most of its execution time?
- Is my server suffering from disk, CPU, network or lock contention?
- Are indexes, buffers and caches used efficiently?
- What queries suffer the most from hardware limits, cache misses, or inefficient execution plans?

The last part of the talk will be devoted to presenting our plans for adding more static probes into the server code, and collecting feedback from users on what probes they would like to see in the server.

Photo of Alexey Kopytov

Alexey Kopytov

Sun Microsystems

Alexey Kopytov joined MySQL AB in 2004 as a member of the High Performance team. Currently he is a senior software developer at Sun Microsystems and is working on DTrace support in MySQL Server.

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 scordesse@oreilly.com

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@ oreilly.com

Press and Media

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

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.