Re: MySQL 5.7: Sharp checkpointing due to binlogs?
> innodb_log_file_size * innodb_log_files_in_group /
> innodb_buffer_pool_size
> 12884901888 * 3 / 51539607552 = 0.7500
Better near 0.5.
> Uptime_since_flush_status * innodb_log_file_size /
> Innodb_os_log_written
> 12631711 * 12884901888 / 1982492756992 = 82097.8318
That's a rotation interval of 22.8 hrs, if that's representative consider trying a logfile size that gives a result ~ 30 mins.
Subject
Views
Written By
Posted
695
December 02, 2021 04:39AM
441
December 02, 2021 09:55AM
437
December 02, 2021 10:42AM
Re: MySQL 5.7: Sharp checkpointing due to binlogs?
390
December 02, 2021 11:40AM
346
January 24, 2022 04:40AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.