MySQL Forums
Forum List  »  Source, Builds, Binaries

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Server profile installation however seems not using all resources available
533
Filip Leze
April 29, 2022 03:47AM
Re: Server profile installation however seems not using all resources available
311
Peter Brawley
April 29, 2022 11:47AM
Re: Server profile installation however seems not using all resources available
306
Filip Leze
April 29, 2022 04:15PM
Re: Server profile installation however seems not using all resources available
353
Peter Brawley
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.