I am using Oprofile to look into the performance of a Mysql Storage engine. Upon reading further into the oprofile docs I find:
"OProfile is oriented to finding problems with CPU-limited processes. OProfile does not identify processes that are asleep because they are waiting on locks or for some other event to occur (for example an I/O device to finish an operation)."
That is kind of a drag since the results I am expecting to see include the largest bottlenecks for IO and waiting for locks.
From my experience with gprof I seem to remember the same thing: CPU profiling primarily.
Does any one know of a good off the shelf tool that can integrate CPU profiling with IO? I don't even expect to see anything out there that can include time waiting for locks because it is not generic.
MySQL 5.6, InnoDB and fast storage
4 weeks ago