是否可以在RAM中加载数据库? [英] Is it possible to load a database in the RAM?

问题描述

我想将MYSQL数据库加载到计算机的RAM中，有没有办法做到这一点?我正在Linux下运行此数据库.另外，如果可能的话，是否有进行备份的好方法，因为如果计算机意外关机，我将丢失所有数据.

I want to load a MYSQL-database into the RAM of my computer, is there a way to do this? I am running this database under Linux. Also, if this is possible, is there a good way to make backups, because if the computer is unexpectedly shut down, I would lose all my data.

推荐答案

如果缓冲池足够大，则数据实际上是带有磁盘备份副本的内存数据库.不要无所事事，只需要使缓冲池的大小尽可能的大即可.

If you buffer pool is big enough, you data is -- effectively -- an in-memory database with a disk backup copy. Don't fool around with RAM databases, simply make the buffer pool size as large as you can make it.

阅读:

http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_buffer_pool_size

这篇关于是否可以在RAM中加载数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！