All Posts

In Case You Missed It – Building a Time-Series Database in MySQL
December 16, 2014
SolarWinds
In this webinar, Baron Schwartz explains how VividCortex has used MySQL to support a large-scale, high-velocity time-series database in the AWS cloud.
MySQL Error Codes Out Of Context
December 11, 2014
Baron Schwartz
In the wrong context, almost anything can be funny, and MySQL’s error codes are no exception. A few weeks ago, things got a little loopy as we discovered some definitions…
Why Data Performance Monitor is Cheaper Than DIY Open-Source
December 4, 2014
Baron Schwartz
Talk to someone who runs monitoring systems at a company with more than a few servers and you’ll quickly find out that scaling their monitoring systems is far from a…
Running SolarWinds Database Performance Monitor Via An HTTP Proxy
December 1, 2014
Baron Schwartz
Many of SolarWinds® Database Performance Monitor’s customers have strict policies about Internet access from and to their database servers. As a longtime consultant who worked on many servers that lacked…
How Exponentially Weighted Moving Averages Work
November 25, 2014
Baron Schwartz
We use exponentially weighted moving averages (EWMAs) quite a bit in a few algorithms. They’re one of the tricks everyone should have in their toolbox for cheaply approximating recent history…
Analyzing Prepared Statement Performance
November 19, 2014
SolarWinds
Optimizing MySQL performance requires the ability to inspect production query traffic. If you’re not seeing your application’s production workload, you’re missing a vital part of the picture. In particular, there…
SolarWinds Database Performance Monitor Now Supports Amazon RDS For MySQL
November 12, 2014
Baron Schwartz
We are excited to announce that we now support monitoring Amazon RDS for MySQL. Previously we relied exclusively on deep packet inspection, but since customers can’t install agents on RDS…
Inside Distributed Architectures: RT In-Flight Requests And Blockers
November 6, 2014
Baron Schwartz
SolarWinds® Database Performance Monitor’s (DPM) SaaS backend is a service-oriented architecture, which means that in addition to our external APIs that our agents and web UI use, we also have…
Using Netlink to Optimize Socket Statistics
September 22, 2014
SolarWinds
This is a story of using low-level kernel interfaces to optimize an edge case one of our agents encountered in some servers. The TL;DR version is that accessing /proc/ can…
What Privileges Does EXPLAIN Require in MySQL?
July 28, 2014
Baron Schwartz
Here’s a simple question that I wasn’t able to solve with Google or the MySQL documentation (which is normally excellent). Perhaps it’s mentioned somewhere, but I can’t find it. Here’s…
1177182