Baron Schwartz

Recent Posts

Published by Baron Schwartz on Jun 19, 2019 3:29:31 PM

Manage Database Incidents with VividCortex and Opsgenie

When you're operating always-on services—such as the databases that power production-facing interactive customer experiences—it can be stressful and hard to diagnose common problems like queries slowing down, locks piling up, or infrastructure getting overloaded. At times like these, it's important to use an incident management product and workflow to involve the right people at the right time, helping the team coordinate and communicate their workflow. And with VividCortex's new Opsgenie integration, this just got even easier.

Read More
Published by Baron Schwartz on Jun 6, 2019 11:11:48 AM

See App Releases Visually with Change Markers

With VividCortex's deploy markers, you can quickly and visually identify correlations between releases in your app or infrastructure, and changes in system behavior. It's a one-liner to configure your deploy tooling to send an event to VividCortex when you launch changes. After that, you can select them from the navigation bar. Deploy events appear as vertical markers on charts and graphs everywhere in the app.

Read More
Published by Baron Schwartz on Feb 15, 2019 11:22:15 AM

Databases, Shift-Left, and Empathy: What You Missed at DevOpsDays Charlotte

Last week several people from VividCortex traveled to attend DevOpsDays Charlotte, where I gave the opening keynote, we had a table to demonstrate our product, we caught up with friends and customers we haven't seen in a while, and last but certainly not least we shared in lots of DevOps conversations! Here's a recap of some highlights I enjoyed at the conference.

Read More
Published by Baron Schwartz on Feb 8, 2019 2:45:23 PM

Inspecting Index Usage In MySQL, PostgreSQL, and MongoDB

In my recent post about the Left-Prefix Index Rule, I explained how queries can use all or part of a compound (multi-column) index. Knowing what makes an index fully usable by a query is important, but it's also important to know how to figure out how much of an index a query is able to use. In this article I'll show you how to do this by reading the query's explain plan. This article covers MySQL, Postgres, and MongoDB.

Read More
Published by Baron Schwartz on Feb 5, 2019 11:29:13 AM

The Left-Prefix Index Rule

There's an important heuristic in database indexing that I call the left-prefix rule. It helps you understand whether the database will be able to make the best use of a multi-column index to speed up a query. It's one of a small handful of really important things to understand about indexes!


The left-prefix rule can be confusing, but once you grok it, it's simple and easy to use. It applies to MySQL, PostgreSQL, MongoDB, and many other databases. In this post I'll explain what the left-prefix rule means and how it works.

Read More
Published by Baron Schwartz on Feb 1, 2019 11:04:00 AM

Covering Indexes in MySQL, PostgreSQL, and MongoDB

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 retrieve the query’s data without reading any rows or documents. Covered queries are usually SELECT queries, but in addition to reads, indexes can cover portions of what a write query needs to do its work.

In this article I’ll explain what a covering index is in a bit more detail; the technical implementation and caveats in MySQL, PostgreSQL, and MongoDB; and how to check that a query is using a covering index.

Read More
Published by Baron Schwartz on Jan 28, 2019 2:36:00 PM

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 that have multiple meanings: depending on which community you spend time in, there are multiple meanings for words like schema, cluster, and even database.

Read More

Recent Posts

Posts by Topic

see all