MySQL Forums :: Newbie :: is 16 gb ram enough for handing mysql database of size 100 gb having myisam as storage engine ?


Advanced Search

is 16 gb ram enough for handing mysql database of size 100 gb having myisam as storage engine ?
Posted by: Ronald Brown ()
Date: October 14, 2014 05:00AM

Hello all,

i am working on project where database size will be getting more than 80 GB near about 100 GB .

database has many tables, but the biggest table, will be having 20 mil+ records.

Its size is is 78+ GB .

I am using myisam as storage engine as there are 98% read and 2% insert opration on that table. and cant afford the innodb as it needs server with bigger ram.

i have already set the row-type = fixed for increased performance.

currently testing on 5k records , but i would like to know,
when we go live in production environment, can 16GB ram handle 100 gigs of mysql db ?

server is using cent os 6.5 , 2 tb drive, Xeon E3-1220.


thanks for your time.

Options: ReplyQuote


Subject Written By Posted
is 16 gb ram enough for handing mysql database of size 100 gb having myisam as storage engine ? Ronald Brown 10/14/2014 05:00AM
Re: is 16 gb ram enough for handing mysql database of size 100 gb having myisam as storage engine ? Rick James 10/15/2014 01:15PM
Re: is 16 gb ram enough for handing mysql database of size 100 gb having myisam as storage engine ? Ronald Brown 10/15/2014 08:43PM
Re: is 16 gb ram enough for handing mysql database of size 100 gb having myisam as storage engine ? Ronald Brown 10/15/2014 09:05PM
Re: is 16 gb ram enough for handing mysql database of size 100 gb having myisam as storage engine ? Rick James 10/17/2014 10:54AM


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.