Re: MySQL 5.7: Sharp checkpointing due to binlogs?
Hi,
Peter Brawley Wrote:
-------------------------------------------------------
> Could you post values for ...
>
> innodb_pages_read /
> innodb_buffer_pool_read_requests
Certainly!
13019622 / 77267359463 = 0.0002
> innodb_log_file_size * innodb_log_files_in_group /
> innodb_buffer_pool_size
12884901888 * 3 / 51539607552 = 0.7500
> Uptime_since_flush_status * innodb_log_file_size /
> Innodb_os_log_written
12631711 * 12884901888 / 1982492756992 = 82097.8318
> (Innodb_buffer_pool_reads +
> Innodb_buffer_pool_pages_flushed) /
> Uptime_since_flush_status
( 6308880 + 211823822 ) / 12631711 = 17.2687
Thank you very much in advance for your help!
Subject
Views
Written By
Posted
693
December 02, 2021 04:39AM
439
December 02, 2021 09:55AM
Re: MySQL 5.7: Sharp checkpointing due to binlogs?
432
December 02, 2021 10:42AM
385
December 02, 2021 11:40AM
345
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.