DTrace author Bryan Cantrill just did an excellent presentation of this tool. It allows non-intrusive tracing and profiling in production environments, anywhere from apps to the kernel. Really useful stuff.
I understand Wez Furlong has already written a DTrace provider for PHP, and Bryan noted specific interest in MySQL.