Baron Schwartz

Recent Posts

Published by Baron Schwartz on Jan 11, 2017 10:44:00 AM

MySQL Query Performance Statistics In The Performance Schema

Updated 1/11/2017

Quite some time ago, when we added the ability to monitor MySQL query performance statistics from MySQL’s PERFORMANCE_SCHEMA, we learned a number of valuable lessons, still worth sharing. There are definitely right and wrong ways to do it. If you are looking to the P_S tables for monitoring MySQL query performance, this blog post might save you some time and mistakes.

Read More
Published by Baron Schwartz on Nov 18, 2016 2:16:00 PM

Why Percentiles Don’t Work the Way you Think

Updated 11/18/2016

Customers ask us for p99 (99th percentile) of metrics pretty frequently.

It’s a request that certainly makes sense, and we plan to add such a functionality to VividCortex (more on that later). But a lot of the time, when customers make this request, they actually have something very specific in mind -- something problematic. They’re not asking for the 99th percentile of a metric, they’re asking for a metric of 99th percentile. This is very common in systems like Graphite, and it doesn’t achieve what many people seem to think it does. This blog post explains how you might have the wrong idea™ about percentiles, the degree of the mistake (it depends), and what you can do instead.

Read More
Published by Baron Schwartz on Oct 28, 2016 10:43:44 AM

Everyone's Capable of a Performance Mindset

The other day I was speaking with someone who asked me a few times how we find and hire engineers who are capable of building performance/monitoring tools. I didn't have a great answer in the moment, but after the conversation was over, I realized it's because I fundamentally believe we all are capable of understanding and solving systems performance problems. We're all brainiacs, so to speak.

Read More
Published by Baron Schwartz on Sep 16, 2016 1:19:26 PM

Surprising Behaviors of PostgreSQL Statistics Views

PostgreSQL provides a variety of statistics views that you can use to see what’s happening in the database. However, as with any complex system operating under a demanding workload, using these views may cause unwanted performance side effects, if you’re not careful. At the same time, the views have special behaviors that might surprise you if you’re not aware of them. If you’re planning to examine the PostgreSQL statistics views for any purpose, here’s what you should watch for.

Read More
Published by Baron Schwartz on Sep 1, 2016 11:14:28 AM

Auditing Query Activity with VividCortex

Did you know you can use VividCortex to pull needles out of haystacks with super low effort and overhead? It’s true: next time you’re wondering how to catch that oddball query in action, without enabling a month’s worth of full query logging, VividCortex might have a solution for you.

Read More
Published by Baron Schwartz on Apr 12, 2016 9:20:26 AM

Post-Mortem on VividCortex Outage April 8, 2016

On April 8th, we had a serious outage and we lost some performance metrics from your (our customers’) systems. I know how important this is to you, and above all I’m sorry. All of us are, and we’ve worked long and hard to fix the causes as quickly as we prudently could.

Read More

Subscribe to Email Updates

Posts by Topic

see all