Magento and innodb_buffer_pool_size =2G when Data is only 500M

Magento white-paper recommends innodb_buffer_pool_size be set at 50% to 80% of my servers 4G ram. Is this really necessary when my Magento database has only 500M table data and开发者_运维百科 500M Indexes ?

I know other variables need to be considered, but setting innodb_buffer_pool_size = 2G seams a bit excessive...! I'm i correct?

http://www.mysqlperformanceblog.com/2007/11/03/choosing-innodb_buffer_pool_size/

"This of course assumes your database is large so you need large buffer pool, if not – setting buffer pool a bit larger than your database size will be enough."

so basically yeah, if your innodb data(tables,indexes,etc.) are far less than 2G, you aren't gaining performance with the higher setting.

nope, this suggestion is not dependent of the size of your dataset but rather tied to performance and resources available for innodb to perform faster/best