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: , , , ,

File System Latency: part 5

This is part 5 of File System Latency, a series on storage I/O performance from the application perspective (see parts 1, 2, 3 and 4). Previously I explained why disk I/O metrics may not reflect application performance, and how some file system issues may be invisible at the disk I/O level. I then showed how [...]

Posted on June 3, 2011 at 12:02 pm by Brendan Gregg · Permalink · 2 Comments
In: Performance · Tagged with: , , , , , ,

File System Latency: part 4

This is part 4 on file system latency, a series on storage I/O performance from the application perspective (see part 1, part 2 and part 3). In the previous post I showed how to trace file system latency from within MySQL using the pid provider. In this post I’ll show how similar data can be [...]

Posted on May 24, 2011 at 5:57 pm by Brendan Gregg · Permalink · 2 Comments
In: Performance · Tagged with: , , , ,