Monitoring Drizzle or MySQL With DTrace and SystemTap

Padraig O'Sullivan (Akiban Technologies Inc.)
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 SystemTap.

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 Drizzle.

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.

Comments

Picture of Sheeri K. Cabral
Sheeri K. Cabral
04/21/2010 6:06am PDT

The video for this presentation is online at www.youtube.com/watch?v=NwA...

Philip Turner
04/15/2010 10: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 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.