-
Recent Posts
Recent Comments
- Sinisa Milivojevic on Hash of shame
- Martynas on Hash of shame
- Domas Mituzas on Hash of shame
- Hash on Hash of shame
- mdcallag on Hash of shame
Tag Archives: profiling
MySQL metrics for read workloads
There are multiple metrics that are really useful for read workload analysis, that should all be tracked and looked at in performance-critical environments. The most commonly used is of course Questions (or ‘Queries’, ‘COM_Select’) – this is probably primary finger-pointing … Continue reading
Posted in facebook, mysql
Tagged easy, innodb, monitoring, performance, profiling
On database write workload profiling
I always have difficulties with complex analysis schemes, so fall back to something that is somewhat easier. Or much easier. Here I will explain the super-powerful method of database write workload analysis. Doing any analysis on master servers is already … Continue reading
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
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.
again, on benchmarks
Dear interweb, if you have no idea what you’re writing about, keep it to yourself, don’t litter into the tubes. Some people may not notice they’re eating absolute crap and get diarrhea. This particular benchmark has two favorite parts, that … Continue reading
on tools and operating systems
Sometimes people ask why do I use MacOSX as my main work platform (isn’t that something to do with beliefs?). My answer is “good foundation with great user interface”. Though that can be treated as “he must like unix kernel … Continue reading
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
dtrace!
At the MySQL developer conference I accidently showed up some of things we’ve been doing with dtrace (I used it in few cases and realized the power it has), and saw some jaws drop. Then I ended up doing small demos … Continue reading
InnoDB map: bulk inserting
So, what does InnoDB do while you’re loading the data in parallel? It looks something like this: Click on image for larger (8MB) version, if you dare, have efficient browser and lots of spare RAM (7k*10k canvas). Generated by: opreport … Continue reading
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’. :)
