A covering index is a fantastic query performance optimization. An index covers a query when the index has all the data needed to execute the query, so the server can…
Baron Schwartz
Baron Schwartz
The Latest Posts Featuring Baron Schwartz
Inside the Black Box: Bridging the Database Observability Gap
Over the past 15 years, Agile and DevOps have accelerated application delivery, enabling faster, more reliable releases. Yet the database layer often remains a blind spot for observability and performance monitoring.
In this article, Kevin Kline shows why closing the database observability gap is critical to improving performance, efficiency, and resilience for DBAs, developers, and the businesses that depend on their data.
Covering Indexes in MySQL, PostgreSQL, and MongoDB
What Is Concurrency in a Database?
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…
Your ORM and SELECT FOR UPDATE
If you use a programming language framework such as Django or Ruby on Rails, chances are you use an ORM to help you construct queries.
The Difference Between Lock Wait Timeout and Deadlock
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…
What Is Cardinality in Monitoring?
I wrote a couple of “definitions and nuances” posts about terminology in databases recently (cardinality, selectivity), and today I want to write one about cardinality in monitoring, as opposed to…
What is Database Index Selectivity?
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…
Monitoring, Analytics, Diagnostics, Observability, and Root Cause Analysis
Monitoring is a hopelessly overloaded term in tech culture. The term now carries decades of inaccurate and imprecise use. The result is that several people can be engaged in an…
Monitoring and Observability With USE and RED
Modern systems can emit thousands or millions of metrics, and modern monitoring tools can collect them all. Faced with such an abundance of data, it can be difficult to know…
Monitoring Isn’t Observability
Observability is all the rage, an emerging term that’s trending up very quickly in certain circles even while it remains unknown in others. As such, there isn’t a single widely…
How We Encrypt Data in MySQL With Go
A SaaS product needs to use security measures you might not ordinarily use in an on-premises solution. In particular, it’s important for all sensitive data to be secured. Encryption plays…