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
RAMDisk
Forum rules
READ NOW: L2j Forums Rules of Conduct
READ NOW: L2j Forums Rules of Conduct
-
badboy29
- Posts: 417
- Joined: Fri Apr 24, 2009 5:34 am
- Location: Brazil
RAMDisk
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
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
Aka UnHoly
-
JIV
- L2j Veteran
- Posts: 1882
- Joined: Sun Jan 06, 2008 8:17 pm
- Location: Slovakia
- Contact:
Re: RAMDisk
yeah and on server crash or power loss whole db destroyed.
-
badboy29
- Posts: 417
- Joined: Fri Apr 24, 2009 5:34 am
- Location: Brazil
-
MELERIX
- L2j Veteran
- Posts: 6667
- Joined: Sat Sep 23, 2006 11:31 pm
- Location: Chile
- Contact:
Re: RAMDisk
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
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
-
BiggBoss
- L2j Veteran
- Posts: 1104
- Joined: Wed Apr 15, 2009 3:11 pm
- Location: Spain
-
ThePhoenixBird
- L2j Inner Circle
- Posts: 1857
- Joined: Fri May 27, 2005 5:11 pm
-
caramon81
- Posts: 371
- Joined: Mon Oct 01, 2007 4:00 pm
Re: RAMDisk
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.
-
Forsaiken
- L2j Veteran
- Posts: 99
- Joined: Sun Mar 11, 2007 6:23 pm
Re: RAMDisk
The ramdrive can be stored all 5 minutes to hdd (auto).
I am using an 2gb ramdrive at home for my workbench
I am using an 2gb ramdrive at home for my workbench
http://code.google.com/p/g3d-editor/
Experienced in the following languages/apis/ides: Java using Eclipse/AWT/Swing/NIO/JNI/Jogl, C/C++11/c++14 using QT/MFC/BOOST/STL/VS2012/VS2013/OpenGL/DirectX, Delphi using Borland, .NET/C# using VS2012/VS2013
Experienced in the following languages/apis/ides: Java using Eclipse/AWT/Swing/NIO/JNI/Jogl, C/C++11/c++14 using QT/MFC/BOOST/STL/VS2012/VS2013/OpenGL/DirectX, Delphi using Borland, .NET/C# using VS2012/VS2013
-
badboy29
- Posts: 417
- Joined: Fri Apr 24, 2009 5:34 am
- Location: Brazil
Re: RAMDisk
Yeah this program that i posted have this fuction!Forsaiken wrote:The ramdrive can be stored all 5 minutes to hdd (auto).
I am using an 2gb ramdrive at home for my workbench
Aka UnHoly
-
Naminator_X_
- Posts: 39
- Joined: Thu Jun 10, 2010 9:06 am
Re: RAMDisk
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$
-
tonton
- Posts: 3
- Joined: Tue Jun 21, 2011 4:11 pm
Re: RAMDisk
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.