Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

Storing InnoDB tables on RAM disk [message #2077] Wed, 17 October 2007 07:15  Nomad Messages: 4 Registered: October 2007 Location: Ukraine Junior Member Greetings Currently I'm using MySQL 5.0 and InnoDB to store small database (1.1-1.8GB). I need extremely fast read access and moderate insert/update speed. On my dedicated server there is 4 GB RAM and I use 2GB as RAM drive where InnoDB bases are stored. Also InnoDB memory usage is set to minimal settings and 128MB log file (also placed on RAM disk). Such combination gives me required speed but limits database size and requires extended backup features, etc. My question is simple - is it possible to implement similar performance without RAM drive, just giving MySQL RAM that is now wasted on virtual drive. Please, make comparative tests and post the results instead of just telling to "increase log size, may be it would help". Russian version of my question can be found here: http://www.mysqlperformanceblog.com/about/#comment-178034 Report message to a moderator

	Storing InnoDB tables on RAM disk By: Nomad on Wed, 17 October 2007 07:15
	Re: Storing InnoDB tables on RAM disk By: AlexN on Wed, 17 October 2007 07:49
	Re: Storing InnoDB tables on RAM disk By: Nomad on Wed, 17 October 2007 07:56
	Re: Storing InnoDB tables on RAM disk By: sterin on Wed, 17 October 2007 15:52
	Re: Storing InnoDB tables on RAM disk By: Nomad on Wed, 17 October 2007 16:00
	Re: Storing InnoDB tables on RAM disk By: sterin on Wed, 17 October 2007 17:20
	Re: Storing InnoDB tables on RAM disk By: AlexN on Thu, 18 October 2007 03:09
	Re: Storing InnoDB tables on RAM disk By: Nomad on Thu, 18 October 2007 03:58
	Re: Storing InnoDB tables on RAM disk By: AlexN on Thu, 18 October 2007 05:35
	Re: Storing InnoDB tables on RAM disk By: scoundrel on Fri, 19 October 2007 00:51
	Re: Storing InnoDB tables on RAM disk By: scoundrel on Fri, 19 October 2007 00:58
	Re: Storing InnoDB tables on RAM disk By: AlexN on Fri, 19 October 2007 02:45

Previous Topic:	Query tuning - Performance Issue
Next Topic:	more RAM, less performance

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]