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?
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.
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.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at firstname.lastname@example.org
Download the MySQL Sponsor/Exhibitor Prospectus
For media-related inquiries, contact Maureen Jennings at email@example.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
View a complete list of MySQL contacts.