Monitoring Drizzle or MySQL With DTrace and SystemTap

General, Performance Tuning and Benchmarking
Location: Ballroom A Level: Intermediate
Average rating: ****.
(4.00, 5 ratings)

DTrace and SystemTap are dynamic tracing frameworks available for
Solaris and Linux respectively. This session will give an overview of
the static DTrace probes available in both Drizzle and MySQL and show
numerous examples of scripts that utilize these probes. Mixing dynamic
and static probes will also be discussed.

Since DTrace is only available on Solaris and many MySQL/Drizzle
installations are on Linux, it is often assumed that static DTrace
probes are useless on Linux. However, this presentation will also
discuss how SystemTap can now be used on Linux in a manner similar to
DTrace. Examples presented using DTrace will be presented using

Topics covered include:

  • overview of the static DTrace probes in Drizzle and MySQL
  • how to use these probes with DTrace
  • example scripts utilizing these static probes
  • overview of SystemTap on Linux
  • how to use SystemTap with the static DTrace probes
  • examples of using SystemTap with the static probes
  • how to add static DTrace probes to a plugin

This session is applicable to both Drizzle and MySQL. The presenter
was responsible for porting the static DTrace probes from MySQL to
Drizzle and is quite familiar with the probes in both MySQL and

Padraig O'Sullivan

Akiban Technologies Inc.

Padraig O’Sullivan is a software engineer at Akiba Technologies Inc. He is working on the core Akiba Orthogonal Architecture as well as contributing to the open source community. He has been hacking on Drizzle since February 2009 and participated in Google’s Summer of Code working on Drizzle. Contributions to various other open source projects happen when he has the time. He has an M.S. in Computer Engineering from the University of Maryland. Originally from Killarney in Ireland, he now lives and works in Boston.

Comments on this page are now closed.


Picture of Sheeri K. Cabral
Sheeri K. Cabral
04/20/2010 11:06pm PDT

The video for this presentation is online at

Philip Turner
04/15/2010 3:38am PDT

Great session on the use and limitations of systemtap

  • 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

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@

Press and Media

For media-related inquiries, contact Maureen Jennings at

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.