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…
Author: Vinicius Grippa
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….