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…
SolarWinds
SolarWinds
The Latest Posts Featuring SolarWinds
Why WiredTiger Is the Default MongoDB Storage Engine
Understanding Whether Your MongoDB Indexes Are Effective
One of the variables that can have a major impact on your MongoDB performance is the way you implement indexes. While it’s a good idea to use indexes in some…
How to Tell if Your MongoDB Server Is Correctly Sized For Your Working Set
For MongoDB users, knowledge of working sets is critical. Understanding the interactions between your working set and physical memory can make a major difference in how your system performs. To optimize…
Common Pitfalls When Using database/sql in Go
We’re huge fans of the Go language and its database access library, database/sql. As you’ve probably seen firsthand, the surface area of database/sql is pretty small, but there’s a lot…
Three Things That Differentiate Amazon Aurora From MySQL
It’s not always obvious what makes one database type distinct from another. What are the most significant ways Amazon Aurora is different from MySQL? Clear separators aren’t always featured or…
Solving MySQL Replication Lag With LOGICAL_CLOCK and Calibrated Delay
Preetam Jinka published a post on his personal blog examining how his engineering team had overcome a problem with MySQL replication by using a new parallelization policy introduced in MySQL…
Common UI Performance Problems in Angular Apps
In this post, we analyze some performance issues we recently fixed in our web app common in AngularJS apps. We also discuss the tools we used to find and diagnose…
Queueing Theory: London Underground Escalator Policy Challenges Social Norms
In 2016, we published our eBook Everything You Need to Know About Queueing Theory, and as part of its launch, we blogged about one way (of the many) queueing theory…
Queueing Theory: Faster Trains Might Make London Underground Slower
Let’s take a look at a great real-world example that effectively illustrates how queuing theory can be unintuitive even in situations that seem simple. A recent BBC report reveals researchers’…
Mastering the Sort Buffer and sort_buffer_size
The sort buffer, which is controlled by the sort_buffer_size setting, is probably one of the most-discussed MySQL settings. Interestingly, in many cases it has a lot less potential to help…