Tuesday, January 11. 2011Quick way to see request time distribution
Ever wondered what's hiding behind those average numbers in Pinba reports?
Well, so have we. I spent some time and came up with this result:
So what do we see here? Even though the average request time is 0.308 sec, the majority of the users actually get served faster than that - in about 0.10-0.25 sec. There's also an interesting peak at 0.45 sec, I'll have to use conditional reports to explain it. And here is the script I used. Trackbacks
Trackback specific URI for this entry
No Trackbacks
Comments
Display comments as
(Linear | Threaded)
Perhaps the median would be more likely to show you something like that "majority get served faster" than average would... it looks like the average/mean here is being skewed by some overly high values that aren't necessarily "common".
>it looks like the average/mean here is being skewed by some overly high values that aren't necessarily "common".
That's right. But median also has a problem - to calculate it one has to sort through all the records, which sometimes means sorting millions of them, i.e. not that fast. |
QuicksearchArchivesCategoriesSyndicate This Blog |