Answer the question
In order to leave comments, you need to log in
Are MySQL indexes larger than RAM?
Now the server has 1024 MB of RAM, the size of the indexes in the table is 900 MB, and it will exceed a little more.
Question: where to read what will happen if it is exceeded. For example: will performance drop evenly on all requests, or will it drop on some, but some will be fine? Are the indexes stored in RAM in their entirety or only some of their parts, for example, the index cache?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question