Page 1 of 1
RAMDisk
Posted: Thu May 05, 2011 6:30 am
by badboy29
Hi, one gift for community:
http://memory.dataram.com/products-and- ... re/ramdisk
If you have one machine with lot of memory, and your database is not too big , you can try this. I don't know if with innodb storage can get some benefit. ATM i'm using MyISAM and i get a ultra fucking power hyper speed on mysql
Look some screens

Re: RAMDisk
Posted: Thu May 05, 2011 7:40 am
by JIV
yeah and on server crash or power loss whole db destroyed.
Re: RAMDisk
Posted: Thu May 05, 2011 8:15 am
by badboy29
Yep i know, but if use replication in real time

?
Re: RAMDisk
Posted: Thu May 05, 2011 9:33 am
by MELERIX
ofc MyISAM is more fast, but not secure... db corruption and others...
if you want speed don't use MySQL 5.1 or 5.0.
jump directly to MySQL 5.5.x with the new innodb engine

Re: RAMDisk
Posted: Thu May 05, 2011 7:54 pm
by BiggBoss
pay 900 $/month to oracle if you want speed

Re: RAMDisk
Posted: Thu May 05, 2011 10:14 pm
by ThePhoenixBird
What about the new Maria/Aria Engine?
https://launchpad.net/maria
Re: RAMDisk
Posted: Thu May 05, 2011 11:06 pm
by caramon81
what about a hybrid drive. looks like over time they get alot faster as they learn what is used. probably be good for a server.
Re: RAMDisk
Posted: Thu May 19, 2011 3:24 am
by Forsaiken
The ramdrive can be stored all 5 minutes to hdd (auto).
I am using an 2gb ramdrive at home for my workbench

Re: RAMDisk
Posted: Fri May 20, 2011 3:19 am
by badboy29
Forsaiken wrote:The ramdrive can be stored all 5 minutes to hdd (auto).
I am using an 2gb ramdrive at home for my workbench

Yeah this program that i posted have this fuction!
Re: RAMDisk
Posted: Fri May 20, 2011 8:12 am
by Naminator_X_
Wait for the intel's Z68 chipset and buy a pair of 30GB SSD and a high rpm HDD drive. Use the SSD for OS and HDD caching and you will notice slight performance increase. And even in the case of power outage you won't lose the already saved data. Saving data in RAM is bad idea in server application in any case. Those ram sticks tend to break a lot. That's why you get 2gb+ for less than 100$
Re: RAMDisk
Posted: Wed Jun 22, 2011 4:57 am
by tonton
That is the problem and a trade off myisam is giving. With all the computing speed it offers, it has to give something up in order to compensate. Unfortunately, it is stability and security that was targeted. Losing these two, can mean the world to a system, which is why implementation is real life systems has been scarce.