The MySQL wire protocol includes useful result data and metadata, such as warnings and errors raised by the query. These often indicate bugs that will cause problems you may not…
Discovering Query Bugs by TCP Inspection
Adaptive Fault Detection Versus Anomaly Detection
We get a lot of questions about what our Adaptive Fault Detection algorithm really is and how it works. Although I can’t tell you exact details, I want to explain…
Join Our Team! We’re Hiring!
We’re Hiring! VividCortex has several open positions, both technical and non-technical. All of these positions are fulltime, based in Charlottesville, VA or Montevideo, Uruguay. Our benefits include: Fulltime salaried positions…
How to Fix Hangout Restrictions on Google Apps
We use Google Hangout all the time to conduct calls with employees, service providers, customers and pretty much anyone. It’s a great tool, and in our opinion more friendly to…
VMDK versus RDM: Which One Do I Need for SQL Server?
When it comes to disk configuration options for virtualized servers running on VMware, you have two options: VMFS virtual file-based disk (VMDK) or a raw device mapping (RDM). Which one…
Multi-Threaded Replication in MySQL
For years, people lamented that MySQL’s replication was single-threaded. Peter, Vadim, and I griped about this in High Performance MySQL for two whole editions, as well as a bunch of…
Performance Schema, Slow Query Log, and TCP Decoding
Peter Zaitsev posted Percona’s answer to the question, “why use the slow query log instead of the PERFORMANCE_SCHEMA tables to gather information about query execution and timing?” At SolarWinds, we…
Hardware or Code? SQL Server Performance Examined
CPUs are running faster now than ever before, solid-state drives are replacing spinning disks, and database servers have terabytes of RAM. Because these resources are plentiful and increasingly affordable, it can seem tempting to solve database performance issues with hardware. But consider this example: if CPU utilization shoots up to 90% on one of your servers and stays at that level for a day or two, is the problem lack of CPU power or something else?
A Tale of Two Memory Leaks in Go
In this post I’ll illustrate two ways I’ve accidentally caused slow but steady memory consumption in Go programs. The phrase “memory leak” isn’t really accurate, but I can’t think of…
How to Recover the Master Database in SQL Server 2012
In my seven years as a production DBA, I can count on one hand the number of times I have need to restore the master database as a result of…