Not the answer you need?
Register and ask your own question!

MySQL Server Configuration innodb_buffer_pool_size and innodb_log_file_size

hugchrichugchric EntrantInactive User Role Beginner
Hey Community

I have a MySQL Server 5.5 with 32 GB RAM and I want to adjust the two variables innodb_buffer_pool_size and innodb_log_file_size, but I'm not sure if the values will be good for the performance.

I want to configure the two values as follow:

innodb_buffer_pool_size = 26G
innodb_log_file_size = 512M

Are this values oversized?
Is there a way to calculate the sizes?

Thanks and Regards
Chris
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.