author:


Database

Schemaless Databases Don’t Exist

February 24, 2015

There’s no such thing as a schemaless database. I know, lots of people want a schemaless database, and lots of companies are promoting their products as schemaless DBMSs. And schemaless DBMSs exist. But schemaless databases are mythical beasts because there is always a schema …


author:


Database

What Is Com Admin Commands In MySQL?

February 23, 2015

If you’ve ever looked at the COM_XYZ status counters in MySQL’s SHOW STATUS output, you’ve probably seen Com_admin_commands. It’s not clear what this means, but it can be a major contributor to overall COM_ counters, and it’s actually quite important for server and application …


author:


Database

Query Digesting and String Quoting Syntax in SQL

February 16, 2015

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 technology-specific features, bugs, and quirks. When we added PostgreSQL performance monitoring recently, I knew this would be …


author:


Database

Compressed Messages Using Kafka

February 11, 2015

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 today’s topic. Compression! SolarWinds® Database Performance Monitor started using …


author:


Database

How Database Performance Monitor Measures Queries

February 10, 2015

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 methods for obtaining them. I thought it would be both interesting and helpful to clarify how …



author:


Database

Securing JSON APIs With Wrapper Objects

January 21, 2015

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 to monitor MySQL in production designed for performance, isolation, and security. Even small decisions can make a big difference. One …


author:


Database

Go’s Connection Pool, Retries, and Timeouts

January 19, 2015

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 you the long-winded story, and get right to the problem and what we found to be …


author:


Database

Monitor MySQL Database Users with VividCortex

January 8, 2015

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 can now see a breakdown of user activity in the familiar format, all with 1 second …


author:


Database

New reCaptcha support in angular-recaptcha

December 23, 2014

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 hacks. We created an angular component that adds integration with Google’s reCaptcha. This new …