Historically, there has been the belief that you cannot horizontally scale and shard MySQL, learn how Vitess has made MySQL sharding at the database layer a reality.
Storing datetime and timestamp data in MySQL correctly.
Creating generated hash columns in MySQL for faster strict equality lookups.
Using redundant conditions as a method to unlock obfuscated indexes and improve performance in MySQL.
Understanding the differences between character sets and collations in MySQL.
There are several reasons why MySQL might not consider your index, and in this article we’ll explore some of the most common ones.
An overview of the different ways to paginate in MySQL including limit/offset pagination and cursor pagination plus the pros and cons of each.
In this article we explore how our HTTP/3 API compares to the latency of a traditional MySQL client.
Gain a deeper understanding of the MySQL integer types by exploring the different options (INT BIGINT MEDIUMINT etc) and how they are stored.
Learn how to index JSON in MySQL with generated columns and functional indexes.