Using Dtrace on MySQL

“Even though there aren’t DTrace probes for MySQL released yet,
we can still get useful information from MySQL. DTrace has a pid
provider which allows us to get into any function the program is
executing and see its arguments. The only drawback is you have to
go digging around in the source code to find out what you want to
see. But thanks to guys like Brendan Gregg, they have already done
some of the digging for us.

“Even if we want to go digging around ourselves, it’s really not
that hard; you just have to get your feet wet. And because
Accelerators have DTrace probes enabled, you can take advantage of
using DTrace on MySQL. I will show some examples of this and how
easy it is to hunt down your own functions…”

Complete
Story