A blog about databases, mostly.
Big O for MySQL, explained visually: how O(1), O(log n), O(n), O(n log n), O(n²), and O(2ⁿ) decide whether your query stays fast as your data grows. O post Big O for MySQL: Why the Same Query Gets Slow at Scale apareceu primeiro em Another Boring Tech Blog .
How to scale your Strapi data layer using a wire compatible caching proxy and what the results look like on 43,000 real restaurants. Strapi is an excellent tool for building content driven applications quickly. As a project grows and data becomes more interconnected, keeping the API layer snappy is a common goal for development teams. [ ] O post Instant Strapi Performance Without Changing Your…
Speed up your PHP application without changing a single query. A few days ago I set out to answer a simple question: how much faster can a PHP app go if you drop a SQL cache in front of MySQL — without touching application code? The answer is below. On a four-table join aggregating revenue [ ] O post Using PHP and Readyset for the First Time with MySQL apareceu primeiro em Another Boring Tech Blog…
It is a classic trap: you spend a week fine-tuning your cache and your database hits only to realize your application is essentially running with the handbrake on. I saw this with my tests: MySQL and Readyset were returning rows in 0.2 ms, but the application throughput remained capped at 40 queries per second (QPS). The database isn t [ ] O post Technical Analysis: Why 0.2ms Queries Can Still…
A common source of instability in MySQL environments is the unexpected growth of memory usage at startup. You might set your innodb_buffer_pool_size to 16GB, only to find the process consuming 18GB or 20GB. This happens because MySQL enforces a strict geometric relationship between the total size, the number of instances, and the chunk size. If [ ] O post Determining the Correct…
I recently got into a bit of a debate about standardizing MySQL 8.4’s internal temporary table configuration. We wanted to cap memory usage efficiently, but relying on rules of thumb isn t enough when production stability is at stake. The main confusion was about how per-query limits fight with global limits. So, rather than guessing, I [ ] O post MySQL 8.4 Memory Limits: tmp_table_size vs.…
Upgrading MySQL is often seen as straightforward — install the new binaries, restart, done. In reality, it’s more like upgrading a production jet engine mid-flight. Small changes in defaults, deprecated settings, or old privileges can lead to surprises you don’t want at 2:00 AM on maintenance night. Or even worse, see your performance deteriorating during [ ] O post Checking Your MySQL Server…
Note: The opinions below represent my personal perspective only. They don’t include any confidential information or represent the views of Oracle or my current employer, Percona. The question I brought home after this conference is: Was this an AI conference because everyone is already using AI, or because they want you to use AI? [ ] O post My Impressions from Oracle AI World 2025 – MySQL, AI,…
When I’m working with MySQL, I care not just about whether a single query is slow, but how much total load the server can handle before performance starts to drop. Tools like mysqlslap help by generating synthetic workloads to simulate multiple clients and measure the server’s Queries Per Second (QPS). In this post, I’ll walk through [ ] O post Benchmarking MySQL Server With mysqlslap: Estimating…
Parece mentira, mas o MySQL está completando 30 anos em 2025. Três décadas de código aberto, performance, confiabilidade (sim, a gente sabe dos bugs também 😅) e uma comunidade incrível que cresce a cada ano. E, claro, isso merece ser comemorado! 📍 Onde e quando? Vamos nos reunir em São Paulo, no dia 4 de [ ] O post MySQL Brazil Meetup 2025 Aniversário de 30 Anos! apareceu primeiro em Another…