Releem / mysqlconfigurer

Releem is a simple MySQL tuning tool to improve database performance and reduce servers costs.
https://releem.com
GNU General Public License v3.0
257 stars 28 forks source link

How to fix warning Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity. #334

Open drupaladmin opened 2 months ago

drupaladmin commented 2 months ago

my log is complaining quite a lot about redo log capacity:

2024-07-28T00:15:06.459175Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.

drupaladmin commented 2 months ago

We've checked your server.

Everyday at the same time the database has a spike of write operations for a short period of time, but Releem analysis window is larger and it didn't see this spike.

It is a warning for a short period, you could continue to use Releem. We're looking for a solution.