Introduction to Using DTrace with MySQL

Performance Tuning and Benchmarks
Location: Ballroom B Level: Intermediate
Average rating: ***..
(3.00, 1 rating)

DTrace is a comprehensive dynamic tracing framework for OpenSolaris. DTrace provides a powerful infrastructure to permit one to answer arbitrary questions about the behavior of the operating system and user processes.

On the fly one can ask questions like: “Is query x hitting the query cache?”, “What are the query executions for query x?”, “What is the locking behavior of query x?”

In this session basic DTrace concepts and methodology will be presented. We will then move on to an exploration of the mysql Dtrace provider available in MySQL 5.1 and MySQL 6.0. We also look at the DTrace pid provider which allows instrumentation of any function within a user process. Examples will be provided. You will find that most DTrace inquiries are simple scripts. As one DTrace inquiry reveals new information the DTrace script can be easily refined to focus in on the issue being examined.

After this session the attendee will have a basic understanding of how DTrace can be used to understand the behavior of MySQL in their environment and facilitate the resolution of MySQL performance issues.

Vince Carbone

Sun Microsystems, Inc

Vince Carbone works in the Performance Technology Group at Sun Microsystems, Inc. He has spent the last 8 years at Sun as a benchmark engineer on commercial database workloads and benchmarks, using Oracle and DB2. As part of Sun’s MySQL Scalability and Performance project he has shifted his focus in the last year to characterizing MySQL performance with the goal of increasing the scale-up performance of MySQL.

Photo of Mikael Ronstrom

Mikael Ronstrom


Ph.D in Technical Information Systems.
Founder of MySQL Cluster technology.
Developer of MySQL Partitioning.
Currently working on MySQL Architecture.

Comments on this page are now closed.


Picture of Mark J. Levitt
Mark J. Levitt
04/22/2009 4:38am PDT

Looks like the presentation is here now—thanks!

04/22/2009 1:04am PDT

The presentation has not been posted to the conference site yet, so I’ve posted it at my blog:

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.