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…
SolarWinds
SolarWinds
The Latest Posts Featuring SolarWinds
Common Pitfalls When Using database/sql in Go
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…
Analyzing Prepared Statement Performance
Optimizing MySQL performance requires the ability to inspect production query traffic. If you’re not seeing your application’s production workload, you’re missing a vital part of the picture. In particular, there…
4 Statistical Process Control Rules That Detect Anomalies in Systems
Statistical Process Control (SPC), or using numbers or data to study the characteristics of our process to make it behave the way we want it to behave, has been around…