MySQL Forums
Forum List  »  InnoDB

InnoDB buffer pool setting of large Innodb database
Posted by: Devrishi Shandilya
Date: December 30, 2014 05:23AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
InnoDB buffer pool setting of large Innodb database
2014
December 30, 2014 05:23AM


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.