# Another Boring Tech Blog

> A blog about databases, mostly.

A deadpan technical journal on databases, mostly MySQL, and the slow-moving infrastructure beneath them. Entries are long-form, footnoted, irregularly published. Voice is declarative and self-aware; no superlatives, no emoji. Code examples use JetBrains Mono; prose is set in Source Serif 4.

## Navigation

- [Contents (current issue)](https://anotherboringtechblog.com/): Hero of recent entries and the serial archive list.
- [Archive](https://anotherboringtechblog.com/#archive): Chronological listing of published entries.
- [Topics](https://anotherboringtechblog.com/topics/): Active topic taxonomy.
- [Colophon](https://anotherboringtechblog.com/colophon/): About the editor and the publication.
- [RSS feed](https://anotherboringtechblog.com/feed/): Atom / RSS for machine consumption.

## Topics

- [MySQL](https://anotherboringtechblog.com/category/mysql/) — 21 entries.
- [Linux](https://anotherboringtechblog.com/category/linux/) — 9 entries.
- [Postgres](https://anotherboringtechblog.com/category/postgres/) — 1 entry.

## Entries (most recent 30)

- [Big O for MySQL: Why the Same Query Gets Slow at Scale](https://anotherboringtechblog.com/2026/04/big-o-for-mysql/) (2026-04-22 · Linux, MySQL): 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.
- [Instant Strapi Performance Without Changing Your Code](https://anotherboringtechblog.com/2026/04/strapi-performance-readyset/) (2026-04-18 · Linux, Postgres): 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…
- [Using PHP and Readyset for the First Time with MySQL](https://anotherboringtechblog.com/2026/03/php-readyset-mysql-getting-started/) (2026-03-31 · MySQL): 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…
- [Technical Analysis: Why 0.2ms Queries Can Still Result in Low QPS](https://anotherboringtechblog.com/2026/03/technical-analysis-0-2ms-queries-low-qps/) (2026-03-29 · Linux): 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.…
- [Determining the Correct innodb_buffer_pool_chunk_size](https://anotherboringtechblog.com/2026/02/innodb-buffer-pool-chunk-size-calculator/) (2026-02-28 · MySQL): 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…
- [MySQL 8.4 Memory Limits: tmp_table_size vs. temptable_max_ram](https://anotherboringtechblog.com/2025/11/mysql-8-4-temptable-memory-limits/) (2025-11-20 · MySQL): 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…
- [Checking Your MySQL Server Before an Upgrade with MySQL Shell](https://anotherboringtechblog.com/2025/11/mysql-upgrade-checker-mysql-shell/) (2025-11-02 · MySQL): 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…
- [My Impressions from Oracle AI World 2025 – MySQL, AI, and Its Open Source Future](https://anotherboringtechblog.com/2025/10/mysql-ai-world-2025-impressions/) (2025-10-17 · MySQL): 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…
- [Benchmarking MySQL Server With mysqlslap: Estimating Capacity, Not Absolute Limits](https://anotherboringtechblog.com/2025/04/mysql-server-benchmarking-guide/) (2025-04-25 · MySQL): 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…
- [MySQL Brazil Meetup 2025 - Aniversário de 30 Anos!](https://anotherboringtechblog.com/2025/04/mysql-brazil-meetup-2025/) (2025-04-14 · MySQL): 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…
- [Black Friday or Dark Friday? Depends If MySQL Stands the Rush](https://anotherboringtechblog.com/2024/11/mysql-black-friday-survival-checklist/) (2024-11-26 · Linux, MySQL): Black Friday or Dark Friday? Tips to Ensure Your MySQL Instance Survives Black Friday is one of the most demanding days of the year for e-commerce and online…
- [How to Identify Processes Using Swap Memory on Linux](https://anotherboringtechblog.com/2024/11/identify-processes-using-swap/) (2024-11-23 · Linux): Identifying which processes have pages swapped out of memory when troubleshooting performance issues on a Linux system is often helpful. Swapping can impact system performance, so knowing which…
- [Testing Dolphie For the First Time:  Features and Feedback](https://anotherboringtechblog.com/2024/11/testing-dolphie/) (2024-11-21 · MySQL): In this blog post, I will test Dolphie, an open-source project by Charles Thompson. Dolphie is an open-source tool that provides real-time analytics for MySQL, MariaDB, and ProxySQL.…
- [Understanding MySQL DDL Space Requirements](https://anotherboringtechblog.com/2024/11/understanding-mysql-ddl-storage-req/) (2024-11-20 · MySQL): This blog post will explore MySQL’s file storage behavior during DDL operations, particularly with InnoDB tables. Using a practical example, we’ll discuss where and how MySQL stores data…
- [Understanding Latency Through a 100m Race: From CPU to NVMe](https://anotherboringtechblog.com/2024/11/understanding-latency-from-cpu-to-nvme/) (2024-11-14 · Linux): In the world of computing, latency is everything. Whether you’re optimizing a database query or fine-tuning a high-performance application, understanding how quickly different components of your system respond…
- [How to Add an Invisible Primary Key to an Existing Table in MySQL](https://anotherboringtechblog.com/2024/11/add-invisible-primary-key/) (2024-11-04 · MySQL): With MySQL 8.0.23, the concept of invisible columns was introduced. Columns marked as invisible do not appear in standard SELECT *  queries and don’t require changes to existing application…
- [How to Monitor and Optimize Fragmented Tables in MySQL](https://anotherboringtechblog.com/2024/09/optimizing-fragmented-tables-in-mysql/) (2024-09-10 · MySQL): Random insertions or deletions in a secondary index can lead to fragmentation, where the physical order of index pages on disk no longer aligns with the logical order…
- [MySQL Brazil Meetup 2024 - Informações do Evento e Agenda](https://anotherboringtechblog.com/2024/07/mysql-brazil-meetup-2024/) (2024-07-14 · MySQL): Salve a todos os nerds! O nosso meetup de MySQL de 2024 já tem uma data! Data: 05 de Outubro, Sábado, 2024 Horário: 9:00 AM - 5:30 PM…
- [How to Sort MySQL Tables by Size and Why It Matters](https://anotherboringtechblog.com/2024/06/sorting-mysql-tables-by-size/) (2024-06-06 · Linux, MySQL): Introduction Efficient database management ensures optimal performance, especially as your data grows. One important aspect of managing a MySQL database is monitoring and managing the size of your…
- [How to Run ANALYZE in MySQL](https://anotherboringtechblog.com/2024/05/analyze-in-mysql/) (2024-05-14 · MySQL): Introduction In database management, keeping your database running smoothly is essential. ANALYZE is a command in MySQL that helps update statistics for table indexes. These statistics help the query…
- [[PT-BR] Desativar o Transparent Huge Pages(THP) no Ubuntu 22.04](https://anotherboringtechblog.com/2024/05/desativar-transparent-huge-pages-ubuntu2204/) (2024-05-09): Desativar as Transparent Huge Pages (THP) de forma permanente no Ubuntu 22.04 exige a modificação dos arquivos de configuração do sistema para que a alteração seja aplicada durante…
- [Releem: MySQL Performance Tool](https://anotherboringtechblog.com/2024/04/releem-mysql-performance-tool/) (2024-04-28 · MySQL): Who wouldn't love a reliable database free from issues and allowing us to sleep peacefully? That's what Roman Agabekov, the CEO of Releem, aims to provide. As a…
- [Improving Database Performance with ReadySet: A MySQL Caching Solution](https://anotherboringtechblog.com/2024/04/readyset-a-mysql-caching-solution/) (2024-04-10 · MySQL): Many developers face the challenge of achieving performance without compromising on real-time application functionality in database management. This brings us to today's spotlight technology: ReadySet. What is ReadySet?…
- [MySQL: Identifying Tables Not Using InnoDB](https://anotherboringtechblog.com/2024/03/mysql-identifying-tables-not-using-innodb/) (2024-03-24 · MySQL): This blog post aims to spotlight tables within a MySQL database that do not employ the InnoDB storage engine. The essence of the query is to filter out…
- [Introduction to the New Percona Everest Beta](https://anotherboringtechblog.com/2024/02/percona-everest-beta-impressions/) (2024-02-28): In the rapidly evolving world of technology, database management remains a crucial, albeit challenging, aspect for many organizations. Percona, a leading provider of open-source database solutions, comes with…
- [How to Permanently Disable Transparent Huge Pages (THP) on Ubuntu 22.04](https://anotherboringtechblog.com/2024/02/disabling-thp-ubuntu-22-04/) (2024-02-23 · Linux): Disabling Transparent Huge Pages (THP) permanently on Ubuntu 22.04 requires editing system configuration files to apply the change at boot time. There are a few methods to achieve…
- [How to Create SSH Keys](https://anotherboringtechblog.com/2024/02/creating-ssh-keys/) (2024-02-21 · Linux): An SSH key consists of a pair of files: the private key and the public key. The private key is confidential and should never be shared, while the…
- [That's a Wrap: MySQL Belgian Days and FOSDEM 2024](https://anotherboringtechblog.com/2024/02/mysql-belgian-days-and-fosdem-2024/) (2024-02-06): Hey everyone! FOSDEM and MySQL Belgian days are over, and I wanted to share my impressions from an incredible 4-day journey filled with talks about databases and, of…
- [How to Use MySQL Shell to Create an InnoDB Cluster](https://anotherboringtechblog.com/2024/01/mysql-shell-create-innodb-cluster/) (2024-01-28 · MySQL): Introduction The efficiency and reliability of database management systems are paramount. This blog post is your step-by-step guide to mastering the creation of an InnoDB Cluster from scratch…
- [How to Add a New MySQL Server Node to an InnoDB Cluster](https://anotherboringtechblog.com/2024/01/adding-innodb-cluster-nodes/) (2024-01-24 · MySQL): Introduction It is possible to expand the capacity and the availability of an InnoDB Cluster by adding more MySQL servers. For example, a 5-node InnoDB cluster can tolerate…

## About

- Edited by Vinicius Grippa.
- Voice: deadpan, technical, self-aware. Headlines declarative. Deks one sentence. No emoji, no superlatives ("unlock", "unprecedented", "revolutionary" are banned).
- Published irregularly.
- Typeset in Source Serif 4 (body) and JetBrains Mono (labels, code).
- Site lives at https://anotherboringtechblog.com/