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…
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…
02/11/15 First things first: A big shout out to the engineers at Shopify who work on Sarama, the Go Client we use for Kafka – they do a great job on the library! Alright, now to to…
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…