RAM consideration/ IO usage
I would like to know how MySQL stores data. I assume indexes and some data are stored in memory, and majority of data itself is in the disk. Is my assumption correct?
I would like to estimate the RAM size for the MySQL instance based on the amount of data that is being forecast in a couple of years.
I have a Primary key, and also an unique index.. If I add more indexes, I assume my memory requirement would increase.
Table type: InnoDB
Subject
Views
Written By
Posted
RAM consideration/ IO usage
1592
January 13, 2015 12:39PM
977
January 14, 2015 01:47PM
875
January 15, 2015 03:07PM
1172
January 16, 2015 02:14PM
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.