DTrace is a framework present in Solaris and Apple’s Leopard, and allows for real-time and integrated analysis of userland programs and kernels. DTrace manages to accomplish this on production systems without impacting the performance of the software. Despite the lack of embedded probes for MySQL, we can still get useful information from MySQL, information that often is not readily obtainable by other means, and in fact allows us to have an even more complete set of data then what is present in MySQL logs.
DTrace has a pid provider that allows us to look into any function of a program. The only drawback is that you have to look through the source code to identify the functions; however, this also demonstrates how one builds probe sets into userland programs, and actually has the advantage of consolidating all your analysis using only the single pid provider.
Rockwood will demonstrate how:
DTrace can be a very powerful tool in analyzing MySQL performance and behavior, and in gaining a complete understanding of the flow of data from application to database back to application.
Ben is the Director of Systems at Joyent, Inc where we cator to the unique needs of redshift Web 2.0 customers who require maximum flexibility and scalability. He is a member of the OpenSolaris Governing Board, long time Solaris zealot, and runs a popular blog at cuddletech.com/blog.
View a complete list of MySQL contacts.