Benchmarking MySQL gives a rough idea of server capacity, helping estimate concurrency, QPS limits, and the impact of tuning — but results aren’t absolute.| Another Boring Tech Blog
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...| Another Boring Tech Blog
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 services, and your database is at the heart of it all. A slow or offline MySQL instance can turn your Black Friday into a Dark Friday, costing... O post Black Friday or Dark Friday? Depends If MySQL Stands the Rush apareceu primeiro em Another Boring Tech Blog.| Another Boring Tech Blog
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 processes are affected is important in diagnosing and resolving these issues. Checking Swap Usage by Process Linux provides detailed process information in the /proc directory. By leveraging... O post How to Identify Processes Using Swap Memory on Linux apareceu primeiro em Another Boring Tech Blog.| Another Boring Tech Blog
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. As a first-time user, my goal is to go from zero to hero, exploring how easy it is to start using the tool while getting familiar with... O post Testing Dolphie For the First Time: Features and Feedback apareceu primeiro em Another Boring Tech Blog.| Another Boring Tech Blog
Learn how MySQL manages temporary file storage during online DDL operations, including examples, file locations, and strategies to handle disk space issues effectively.| Another Boring Tech Blog
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 can make or break performance. But let’s put these abstract nanoseconds and microseconds into a more relatable scenario—a 100m sprint race. 🏃♂️🏃♀️ The Runners in the Race... O post Understanding Latency Through a 100m Race: From CPU to NVMe apareceu primeiro em...| Another Boring Tech Blog
With MySQL 8.0.23, the concept of invisible columns was introduced. Columns marked as invisible do not appear in standard [crayon-673af490038d2383475115-i/] queries and don’t require changes to existing application code. Later, in MySQL 8.0.30, support for automatically generated invisible primary keys (GIPKs) was added for InnoDB tables created without an explicit primary key. This enhancement, controlled by... O post Adding an Invisible Primary Key to an Existing Table in MySQL aparece...| Another Boring Tech Blog
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 of records. A common sign of fragmentation is that a table occupies more space than expected, though determining the exact amount is challenging. InnoDB stores data and... O post Monitoring and Optimizing Fragmented Tables in MySQL apareceu primeiro em Another Boring Tech Blog.| Another Boring Tech Blog
MySQL Brasil Meetup 2024 - Participe do MySQL Meetup 2024 em São Paulo! Um dia inteiro de palestras e discussões sobre MySQL, com temas desde ferramentas open-source até soluções em nuvem Oracle. Inclui visita ao data center da Oracle. Não perca!| Another Boring Tech Blog