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

[Ronald Brown]

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.