2009-02-16

DTrace CPU Performance Counter provider

Jonathan Haslam described DTrace CPU Performance Counter provider which "... gives you the ability
to profile your system by many different types of processor related events; the list of
events is processor specific and usually quite large but typically includes events such
as cycles executed, instructions executed, cache misses, TLB misses and many more ... ".
All the information are here, here and here.

2009-02-05

Optimizing MySQL Database Application Performance with Solaris Dynamic Tracing (DTrace)

There is fantastic white paper how taking advantage of Solaris Dynamic Tracing (DTrace) probes can help simplify MySQL database application tuning. The content of this white paper:

  • Introduction
  • Approaching MySQL Database Application Tuning
  • The Advantages of Solaris Dynamic Tracing
  • Simplifying and Speeding Performance Tuning Efforts
  • Analyzing Query Loads
  • Probing the Cost of File Sort Operations
  • Profiling the Use of Stored Procedures
  • Observing Slave Queries
  • Optimizing Use of the MySQL Database Query Cache
  • Putting it all Together
  • For More Information
  • About the Author
  • Related Resources
  • Ordering Sun Documents
  • Accessing Sun Documentation Online

It is downloadble over here.