Tag Archives: pmp

more on PMP

Lately we have been especially enjoying the opportunities that Poor Man’s Profiler provides us – but also the technology has improved a lot too – there have been few really useful mutations. One mutation (hyper-pmp) was Ryan Mack’s approach of … Continue reading

Posted in facebook, mysql | Tagged , , | 2 Comments

on performance stalls

We quite often say, that benchmark performance is usually different from real world performance – so performance engineering usually has to cover both – benchmarks allow to understand sustained performance bottlenecks, and real world analysis usually concentrates on something what … Continue reading

Posted in facebook, mysql | Tagged , , , , | 3 Comments

When bad things happen!

When bad things happen, like… ‘strace -f’ or ‘gdb’ or any other process inspection tool decides to hang your precious processes (they show up in state T in process lists), there’s always help: #include <sys/ptrace.h> #include <signal.h> main(int ac, char … Continue reading

Posted in misc | Tagged , | 3 Comments

PMP!

It is a glorious day today – Poor Man’s Profiler (previously introduced here) just got its own website. Do visit it at http://poormansprofiler.org/ – and contribute to better tomorrow.

Posted in mysql | Tagged , | 4 Comments

Poor man’s contention profiling

I wrote already about poor man’s query profiling techniques last summer. Today I’m going to share poor man’s contention profiling tool, for all these poor souls which do not have Solaris with dtrace or pstack, don’t want to run tcmalloc … Continue reading

Posted in mysql | Tagged , , , | 4 Comments

Poor man's query profiling

There is one very easy way to find database queries that might be performance bottlenecks on properly running servers, without using any sophisticated tools or using precision slowlogs, Just overload your server, and spam ‘SHOW FULL PROCESSLIST’. :)

Posted in mysql | Tagged , | 3 Comments