MySQL Forums
Forum List  »  Newbie

How do I load a copy of a table into RAM for frequent reading?
Posted by: Ogo Gone
Date: October 24, 2021 07:04PM

Colleagues, tell me how to keep a copy of the table in RAM?

I have a database server with some bases. One of its databases contains a small table - about five fields and several dozen records. The records are not changed often - once every few hours. But, unfortunately, several dozen machines read records from this table every thirty seconds. (Alas, there is nothing I can do about it, I didn’t come up with it.)

Can I load a copy of this table into memory, so that information (INSERT, UPDATE, DELETE) is written to disk and memory, and when read requests (SELECT), reads come not from disk, but from a copy in memory?

Thanks in advance for the answers,
Ogogon.

Options: ReplyQuote


Subject
Written By
Posted
How do I load a copy of a table into RAM for frequent reading?
October 24, 2021 07:04PM


Sorry, only registered users may post in this forum.

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.