MySQL Forums
Forum List  »  Source, Builds, Binaries

Re: Server profile installation however seems not using all resources available
Posted by: Peter Brawley
Date: April 30, 2022 10:19AM

If most of the 64G is available to MySQL, innodb_buffer_pool_size can be 48-50G.

You want innodb_buffer_pool_reads / innodb_buffer_pool_read_requests <= 0.02.

Configure to get the value of innodb_log_file_size * innodb_log_files_in_group / innodb_buffer_pool_size near 0.5

... and the value of Uptime_since_flush_status * innodb_log_file_size / Innodb_os_log_written to 30-45 min range.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Server profile installation however seems not using all resources available
232
April 30, 2022 10:19AM


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.