Brendan's blog » mysql

Off-CPU Performance Analysis

I’ve been exercising a new approach for examining application performance, which involves measuring high resolution off-CPU time that is synchronous to the workload. This reveals which code-paths are blocked and waiting while off-CPU, and for how long exactly. This differs from traditional profiling which often samples the activity of threads at a given interval, and [...]

Posted on July 8, 2011 at 9:36 am by Brendan Gregg · Permalink · 2 Comments
In: Performance · Tagged with: , , , ,

Breaking Down MySQL/Percona Query Latency With DTrace

In May I spoke at PerconaLive 2011 in New York, giving a talk titled “Breaking Down MySQL/Percona Query Latency With DTrace”. It was a great conference, and I’d recommend attending the next one if you get a chance. I also attended a number of the talks, and have also caught up on some via video [...]

Posted on July 6, 2011 at 1:48 pm by Brendan Gregg · Permalink · Comments Closed
In: DTrace, MySQL · Tagged with: , , , ,

MySQL performance schema and DTrace

For a series of blog posts on file system latency, I used MySQL as an example application to examine. I was doing so using DTrace, but as it turns out, MySQL 5.5 GA and later has the performance schema which can measure file system latency as well. Mark Leith recently posted how to do this. [...]

Posted on June 23, 2011 at 1:24 am by Brendan Gregg · Permalink · Comments Closed
In: MySQL, Performance · Tagged with: , ,