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.
Everything you need to know about MySQL as an application developer, with a focus on improving query performance. After covering the high-level overview, we’ll put the learnings to the test with some hands-on examples.
An overview of the different ways to paginate in MySQL including limit/offset pagination and cursor pagination plus the pros and cons of each.
Learn how to read the output in MySQL EXPLAIN plans so you can utilize them to improve query performance.
What does the MySQL 5.7 EOL means for your database? Learn considerations to upgrade 8.0 and how PlanetScale can help you upgrade with no downtime or data loss.
Learn about sharding, connection pooling, and more from PlanetScale Technical Solutions Architect Jonah Berquist.
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.