Database

Latest Posts in Database

What Privileges Does EXPLAIN Require in MySQL?

Here’s a simple question that I wasn’t able to solve with Google or the MySQL documentation (which is normally excellent). Perhaps it’s mentioned somewhere, but I can’t find it. Here’s…

Prepared Statement Samples

One of our most useful features is Top Queries, which allows users to examine various metrics for families of similar queries. Once a query family is selected, we can drill…

MySQL Type Conversion Rules

When you send a query to MySQL, you usually don’t need to think explicitly about the types of the expressions in your query. If you compare this to a lot…

4 Things To Know About MySQL Prepared Statements

While writing our TCP stream reassembly and MySQL protocol reverse-engineering algorithms, a few finer points of the MySQL protocol and internals came up. None of this is new information, but…

Composition Instead of Inheritance in Go

Looking back, I find object-oriented programming in languages like Java and C++ to be incredibly confusing. There are so many special rules and things to know. By contrast, Go gives…

Discovering Query Bugs by TCP Inspection

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…

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…