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 …
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 …
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…
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…
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…
01/08/15 VividCortex now supports per-user metrics in Top Queries, so you can monitor MySQL database user activity in detail. By changing the Rank menu from Queries to Users you ca…
12/23/14 Google released a new reCaptcha that is “tough on bots, easy on humans.” It is really simple to use, and it has greatly improved the security against robots and other hack…
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 …
12/16/14 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. If you did not have …
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 …
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…
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…
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…