List:General Discussion« Previous MessageNext Message »
From:Ilya Kazakevich Date:May 16 2013 11:31am
Subject:RE: Innodb innodb_buffer_pool_size?
View as plain text  
>hwo would a innodb_buffer_pool larger than the whole database make
>anything better? the best value is as large as the expected dataset, more is
>wasting system ressources

You also may need space for adaptive indexes, locks etc so it is recommended to have pool
size about 110% of your data.


Ilya Kazakevich,
Developer
JetBrains Inc
http://www.jetbrains.com
"Develop with pleasure!"



Thread
Innodb innodb_buffer_pool_size?RafaƂ Radecki16 May
  • Re: Innodb innodb_buffer_pool_size?Reindl Harald16 May
  • Re: Innodb innodb_buffer_pool_size?Claudio Nanni16 May
RE: Innodb innodb_buffer_pool_size?Vikas Shukla16 May
  • Re: Innodb innodb_buffer_pool_size?Reindl Harald16 May
    • RE: Innodb innodb_buffer_pool_size?Ilya Kazakevich16 May
      • Re: Innodb innodb_buffer_pool_size?Reindl Harald16 May
RE: Innodb innodb_buffer_pool_size?Vikas Shukla16 May