MySQL Forums
Forum List  »  InnoDB

Re: MySQL 5.7: Sharp checkpointing due to binlogs?
Posted by: Thomas Bätzler
Date: December 02, 2021 10:42AM

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!

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL 5.7: Sharp checkpointing due to binlogs?
65
December 02, 2021 10:42AM


Sorry, only registered users may post in this forum.

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.