Query Digesting and String Quoting Syntax in SQL
02/16/15 One of the interesting challenges in writing a system like SolarWinds® Database Performance Monitor (DPM) is writing a query digesting algorithm that deals with all of the…
Back to all articles
Author
Baron Schwartz
94 articles · Page 6 of 8
How Database Performance Monitor Measures Queries
02/10/15 We often get questions about how we measure queries inside MySQL (and now PostgreSQL too). Many of these questions reveal assumptions about the metrics we provide and our …
Distributed and Diverse: The New Reality of Modern Data Persistence
01/23/15 We create applications in an age of simple, powerful, flexible databases that do magic for us. There’s a large variety of modern databases that supply just what’s needed f…
Securing JSON APIs With Wrapper Objects
01/21/15 Security is a top priority. Leading companies such as Zappos, Dyn, and Etsy use Database Performance Monitor (DPM), a cloud-based database performance management service t…
Go’s Connection Pool, Retries, and Timeouts
01/19/15 This is a story of intermittent 500 Internal Server errors from APIs, that ended up being caused by a hardcoded constant in Go’s database/sql package. I’ll mostly spare yo…
Find Queries That Lack Indexes
12/17/14 It’s an ancient tradition amongst MySQL DBAs to analyze slow query log files and sort the results by the so-called “index ratio” to find badly indexed queries. The “index …
MySQL Error Codes Out Of Context
12/11/14 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
12/04/14 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 minor…
Running SolarWinds Database Performance Monitor Via An HTTP Proxy
12/01/14 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 wo…
How Exponentially Weighted Moving Averages Work
11/25/14 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 approxim…
SolarWinds Database Performance Monitor Now Supports Amazon RDS For MySQL
11/12/14 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 insta…
Inside Distributed Architectures: RT In-Flight Requests And Blockers
11/06/14 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…