We’re Geekbuilt.® Developed by network and systems engineers who know what it takes to manage today’s dynamic IT environments, SolarWinds has a deep connection to the IT community. The result? IT management products that are effective, accessible, and easy to use.

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 …


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

Setting Up Multi-Factor Authentication With the AWS CLI

January 29, 2018

As part of achieving SOC-2 certification, we had to implement stricter requirements around AWS authentication. Database Performance Monitor has had multi-factor authentication (MFA) for access to the AWS web-app console since the beginning, but now we have an additional requirement for CLI access. Ordinary …


author:

Database

The Basics of Sharding in MongoDB

September 6, 2017

Sharding is a mechanism widely used in today’s most popular database systems, an effective way to divide, categorize, and organize data into manageable chunks. In some database types, such as MySQL, the use of sharding is an architectural decision, while in other databases, such …


author:

Database

An Introduction to MongoDB Replication and Replica Sets

August 25, 2017

Replication is a process common to virtually all modern-day database systems. As you very likely know, it can be a complex subject, especially when dealing with nuances that vary from database type to database type. In this post we’d like to offer an introduction …


author:

Database

When to Use explain() in MongoDB

June 19, 2017

In MongoDB, the command db.collection.explain() is an important operation to help you understand exactly how your queries execute and behave. Once you have a grasp of how MongoDB handles explain(), using it lets you examine queries in a number of ways. With explain(), you …


author:

Database

Why WiredTiger Is the Default MongoDB Storage Engine

June 14, 2017

When we published our blog post about working-sets in MongoDB, one of our colleagues told us he’d been aware that MMAPv1 had previously been MongoDB’s default storage engine, but he didn’t know why WiredTiger had since taken its place. We saw this as an …


1

2