Geek Answers Handbook

MySQL: How to save the entire myisam table in memory?

I have a lot of RAM (1 GB) on my server, and I have a table (100 MB) that I would like to increase speed. Is it possible to store the entire table in memory (keeping it MYISAM)? This will speed things up (I already have the corresponding indexes).

thanks

+4
source share
3 answers

The best suggestion would be to increase the size of the query cache, let mysql do internal optimization

more details - http://dev.mysql.com/doc/refman/5.5/en/query-cache.html

+4
source

If you have a lot of memory on the computer, and you use it for MySQL in the first place, the OS should take care of this. With MyISAM, the idea is to allow the file system to cache pages that are mostly needed. With lots of RAM, the likelihood that your table will not be badly affected by the disk, anyway.

This IMHO is even better than trying to make a table like MEMORY, because then you have to worry about writing - in any case, they should be persistent.

So in the end, if the machine does not support a lot of simultaneous pressure from other applications than the MySQL server - in which case 1GB will not seem big for the server at present - you probably won't have to do anything to reach your target:)

+4
source

You can change the table engine in MEMORY and it will save the entire table in memory.

+3
source

More articles:


All Articles