search

major / MySQLTuner-perl

MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.
GNU General Public License v3.0
8.76k stars 1.27k forks source link

Bug with Ratio InnoDB redo log capacity / InnoDB Buffer pool size #777

Open AdzerKI opened 2 months ago

AdzerKI commented 2 months ago

In MySQL 8 innodb_redo_log_capacity replaced the outdated ones innodb_log_file_size and innodb_log_files_in_group

But soft calculate old innodb_log_file_size

Bug: [!!] Ratio InnoDB redo log capacity / InnoDB Buffer pool size (0.15625%): 15.0G / 60.0G should be equal to 25%

huangyh10 commented 1 month ago

same in my server: [!!] Ratio InnoDB redo log capacity / InnoDB Buffer pool size (75%): 32.0M / 128.0M should be equal to 25%

Crease29 commented 2 weeks ago

Duplicate of #714