Deep-inspecting MySQL with DTrace

Domas Mituzas (Facebook)
Average rating: ***..
(3.00, 2 ratings)

DTrace on Solaris, OpenSolaris and MacOSX allows dynamic tracing into any running application without any source modifications – besides information provided by operating system, it can also attach to any function or even instruction.

Once MySQL source and internals are available to everyone, it opens ability for anyone to deep-inspect any part of MySQL operation – aggregate statistics in various views and scopes: *how much File I/O does each user make?
*which table access causes most mutex contention?
*where does MySQL spend most of CPU time?
*etc

Though there are lots of generic DTrace tools (part of DtraceToolkit), that can help a lot with understanding MySQL performance, it is way more powerful to attach to MySQL itself and extract much more interesting data.

This presentation will show how to do all that, as well as show home-grown tools of various engineers to visualize and analyze the output.

Photo of Domas Mituzas

Domas Mituzas

Facebook

Domas Mituzas is senior support engineer at Sun Microsystems’ Database Group. He is also member of Wikimedia Foundation Board of Trustees, as well as does performance engineering and runs databases at Wikipedia.

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.