InnoDB buffer pool setting of large Innodb database
Hi Friends,
I have a dedicated Mysql server with 16 GB of RAM and my database size (data and Index) is about 42 GB. I have already set InnoDB Buffer Pool size 12 GB as per mysql recommandation. My all data is Innodb. I am using MySQL 5.5.38.
Pl help and suggest on the points :
1 - As Database grows, do we have to set buffer pool accroding to size. If it is so, then do I need 50 GB Memory to cache Innodb data in memory in my case ?
2- In this situation, Mysql seeks the queried data from disk, instead of buffer pool and increase InnoDB I/O ?
3- what is the recommanded solution for the same as database size is growing every day and we can not affore large memory on the server?
Regards,
Devrishi
Subject
Views
Written By
Posted
InnoDB buffer pool setting of large Innodb database
2014
December 30, 2014 05:23AM
983
December 30, 2014 01:43PM
1469
December 30, 2014 03:21PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.