vividcortex

Tag: vividcortex

SaaS-Based Database Performance Monitoring for Open Source Systems – SolarWinds Lab Episode #84

In this episode, Head Geek and overall database guru Thomas LaRock will lead a discussion of the newest addition to the SolarWinds database performance monitoring family–VividCortex. Thomas will be joined…

MySQL Query Performance Statistics In The Performance Schema

Quite some time ago, when we added the ability to monitor MySQL query performance statistics from MySQL’s PERFORMANCE_SCHEMA, we learned a number of valuable lessons, still worth sharing. There are definitely right…

What Is Cardinality in a Database?

Databases have a lot of jargon, and cardinality is one of those words that experienced people tend to forget that they didn’t know once upon a time. But if you don’t know…

A Quick Look at Parallel Rsync and How it Can Save a System Hours

In this post, we’ll take a quick look at rsync (“remote sync”) and parallel rysnc—a way to increase the efficiency and speed of traditional rsync. At VividCortex, we’ve found each…

What Is MongoDB’s _id Field and How to Use It

MongoDB’s users are well known for valuing the database’s capacity for growth. After all, the system’s tagline is “for giant ideas,” and for good reason.  The system supports extreme scalability and has…

Thoughts on the VividCortex Acquisition

I visited the Austin office this past week, my last trip to SolarWinds HQ for 2019. It’s always fun to visit Austin and eat my weight in pork products, but…

Holt-Winters Forecasting Simplified

Holt-Winters forecasting is a way to model and predict the behavior of a sequence of values over time—a time series. Holt-Winters is one of the most popular forecasting techniques for…

What Is Concurrency in a Database?

Databases are confusing! Not only are they complicated bits of software, but database jargon is really complicated. Part of this comes from the number of words with multiple meanings: depending…

The Difference Between Lock Wait Timeout and Deadlock

If you use ACID transactional databases, you’ve probably heard of lock wait timeouts and deadlocks. What are these? And how are they different? Inevitably, many of us will come across…

What is Database Index Selectivity?

I wrote recently about database cardinality, and there’s a closely related topic that is equally confusing and I want to explain too: index selectivity. Index selectivity is how tightly a…