Tag: vividcortex


reporting vs analysis difference

author:

Database

MySQL Query Performance Statistics In The Performance Schema

January 12, 2020

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 and wrong ways to do it. If you are looking to the P_S tables …


itil alternatives

author:

Database

What Is Cardinality in a Database?

January 5, 2020

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 it—and it takes a while to really get comfortable with cardinality—it’s super confusing when …



author:

Database

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

December 22, 2019

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 been designed to store exceptionally large numbers of documents. Among all the data that …


author:

Database

Thoughts on the VividCortex Acquisition

December 20, 2019

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 this week was better than most. I took part in deep conversations around our …


make reporting part of IT service catalog

author:

Database

Holt-Winters Forecasting Simplified

December 15, 2019

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 time series. It’s decades old, but it’s still ubiquitous in many applications, including monitoring, …


author:

Database

What Is Concurrency in a Database?

January 28, 2019

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 on which community you spend time in, there are multiple meanings for words like …


author:

Database

The Difference Between Lock Wait Timeout and Deadlock

September 12, 2018

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 these phenomena at some point. Most databases use locking strategies to make sure data …


author:

Database

What is Database Index Selectivity?

July 18, 2018

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 database index helps narrow the search for specific values in a table. To illustrate …