Database

Parsing the Redis TCP Protocol

06/05/15 When we decided to go beyond just MySQL monitoring, we had a couple of natural next choices. The decision involved engineering effort, the likelihood we’d find MySQL-speci…

Finding Query Samples With Errors And Warnings

06/03/15 You probably have known for a while that SolarWinds® Database Performance Monitor (DPM) inspects TCP traffic and captures query errors and warnings, so you can find proble…

Siesta – RESTful Services Made Simple in Go

06/01/15 All of our services (external REST APIs and internal services) are written in Go. Like others, we wanted to factor out repeated code, but found it hard to do without makin…

The Five Stages of Debugging

05/22/15 Because it’s Friday afternoon and you may have had a long week, our brainiacs present… The Five Stages Of Debugging: Stage One. Denial – “What do you mean it’s broken!? Th…

Consul for Cluster Health Monitoring

05/22/15 If you’re not familiar with Consul, it’s what I call a cluster management tool. It’s composed of a handful of features such as “Service Discovery,” “Key Value Store,” “DNS…

DBA Personalities: DISC and Values Models

05/20/15 What personality characteristics do great DBAs share? What motivates them? If you’re not sure why you should care, you’re probably not a hiring manager! Hiring and retaini…

Announcing New Free Network Analyzer Tools for MySQL and PostgreSQL

05/13/15 We have released two free tools that will help MySQL and PostgreSQL DBAs understand the queries their database servers execute. As you probably know, we have spent nearly …

Five Steps to Great Trade Show Demos

03/10/15 Spring is approaching, and with it, the season of sponsorships. For vendors, trade shows offer a unique opportunity to gain valuable insight regarding market needs, engage…

Temp Tables, Filesorts, UTF8, VARCHAR, and Schema Design in MySQL

03/02/15 The other day we were doing some peer review on a schema change at SolarWinds and the topic of character set, column length, and the potential downsides of using utf8 came…

See Connection Latency with SolarWinds

02/26/15 Recently, one of our customers reached out to us about a problem they were having trouble diagnosing – they noticed that every once in a while, it took their MySQL server …

Schemaless Databases Don’t Exist

02/24/15 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. …

What Is Com Admin Commands In MySQL?

02/23/15 If you’ve ever looked at the COMXYZ status counters in MySQL’s SHOW STATUS output, you’ve probably seen Comadmincommands. It’s not clear what this means, but it can be a m…