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 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.
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.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at email@example.com
Download the MySQL Sponsor/Exhibitor Prospectus
For media-related inquiries, contact Maureen Jennings at firstname.lastname@example.org
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.