Today, we’re going to take a journey through one of MySQL’s performance guardians – the innodb_flush_log_at_trx_commit. The innodb_flush_log_at_trx_commit has 3 valid values: 0, 1, and 2. Let’s see each of them. Option 1: The Safe Harbor (innodb_flush_log_at_trx_commit = 1) By default, MySQL is set up with a focus on safety. Imagine this as saving your…
Author: Vinicius Grippa
Optimizing MySQL Performance: A Guide to Redo Log Capacity Estimation
With MySQL 8.0.30 comes a feature that is a game changer in ensuring optimal MySQL performance – the dynamic redo log sizing. Overcoming Previous Limitations Before version 8.0.30 came into play, redo log configuration was static, set once during database setup and rarely touched thereafter due to the MySQL restart required to effect any changes…
Rethinking the 80% InnoDB Buffer Pool Rule: Digging into Server RAM Allocation
In server optimization, various rules of thumb have guided professionals in making informed decisions about resource allocation. One such directive is the 80% rule, which suggests allocating 80% of a server’s RAM to InnoDB’s buffer pool, leaving the remaining 20% for other operations. Initially conceived as a general guideline to get servers up and running…
About Me
Hello there! I’m Vinicius Grippa, and I’ve been playing around with databases for almost 20 years. Currently, I’m the Lead Database Engineer at Percona. If you’ve come across the book “Learning MySQL”, yep, I helped write that! With a Bachelor’s degree in Computer Science, my journey has led me to specialize in MySQL and MongoDB….