Writing

All my notes on programming, distributed systems, system design and cloud.

Message Broker

Have you ever wondered what keeps payment services, social networks, and delivery apps running smoothly every single day? The secret lies in the Message Broker - the "invisible connector" that moves information safely and efficiently between systems. Let's explore what a Message Broker really is!

Oct 31, 20247 min

medium backend Kafka

COUNT(*) vs COUNT(1): Which One Performs Best?

When counting rows in a table, we reach for the count function out of habit. But the count function accepts several kinds of arguments, such as count(1), count(*), count(field), and so on. So which form of count delivers the best performance?

Apr 2, 20249 minDatabase Internals

database mysql InnoDB