|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
RE: Innodb innodb_buffer_pool_size?
From: Ilya Kazakevich (Ilya.Kazakevich
JetBrains.com)
Date: Thu May 16 2013 - 06:31:52 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
>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!"
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]