MySQL Forums
Forum List  »  Newbie

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

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.