As a database administrator (aka DBA, or Default Blame Acceptor) throughout my career, I’ve worked with a myriad of developers, system administrators, and business users who have all had the same question—why is my query (or application) slow? Many organizations lack a full-time DBA, …
While there are many silly depictions of machine learning and artificial intelligence throughout Hollywood, its reality delivers significant benefits. Administrators today oversee so many tasks, like system monitoring, performance optimizing, networking configuration, and more. Many of these tasks can be monotonous and tedious. Also, …
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 …
There have been so many changes in data center technology in the past 10 years, it’s hard to keep up at times. We’ve gone from a traditional server/storage/networking stack with individual components, to a hyperconverged infrastructure (HCI) where it’s all in one box. The …
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 …
Sometimes it’s hard to believe SolarWinds turned 20 this year. That’s eons to survive as an independent software company, much less to have grown into an industry leader. But there’s a simple reason for it. SolarWinds is that rare example of what happens when …
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 to be effective and handy at various times. Rsync is a tool for copying …
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 …
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 …
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, …
