Skip to main content
Database Administrators

Return to Question

Tweeted twitter.com/#!/StackDBAs/status/414887617495592960
added 8 characters in body
Source Link
zsola3075457
zsola3075457
  • 31
  • 2

I read a lot of optimal number of 'innodb_buffer_pool_size'innodb_buffer_pool_size and people say it must be larger with 10% than the innodb tables size, what is 60M60M. Accordyngly this the optimal size of the buffer is about 66M66M im my case. Should I set this value more than 66M, for example 256M256M or 1G1G to achieve better performance? I have enough memory to add more to innodb buffer pool if that improve the performance. Thanks

I read a lot of optimal number of 'innodb_buffer_pool_size' and people say it must be larger with 10% than the innodb tables size, what is 60M. Accordyngly this the optimal size of the buffer is about 66M im my case. Should I set this value more than 66M, for example 256M or 1G to achieve better performance? I have enough memory to add more to innodb buffer pool if that improve the performance. Thanks

I read a lot of optimal number of innodb_buffer_pool_size and people say it must be larger with 10% than the innodb tables size, what is 60M. Accordyngly this the optimal size of the buffer is about 66M im my case. Should I set this value more than 66M, for example 256M or 1G to achieve better performance? I have enough memory to add more to innodb buffer pool if that improve the performance. Thanks

Source Link
zsola3075457
zsola3075457
  • 31
  • 2

optimal size of innodb buffer pool

I read a lot of optimal number of 'innodb_buffer_pool_size' and people say it must be larger with 10% than the innodb tables size, what is 60M. Accordyngly this the optimal size of the buffer is about 66M im my case. Should I set this value more than 66M, for example 256M or 1G to achieve better performance? I have enough memory to add more to innodb buffer pool if that improve the performance. Thanks