Members   Search   Help    Register    Login   Home

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

InnoDB innodb_log_file_size [message #1326] Sat, 26 May 2007 14:47  Speeple Messages: 91 Registered: August 2006 Member Hi, I have a server with 16Gb RAM, 8Gb of which is used by innodb_buffer_pool_size. Now, innodb_log_file_size is almost 25% (combined limit of innodb is 4Gb), so it's around 1.9xGb is size. Is this OTT (feels like it to me!)? Peter notes generally using 128Mb to 512Mb for this variable, I don't know what size of RAM his comments are in relation to. Also, are portions of innodb_log_file_size stored in RAM? Cheers! Martin Gallagher | Speeple: The latest news Report message to a moderator

	InnoDB innodb_log_file_size By: Speeple on Sat, 26 May 2007 14:47
	Re: InnoDB innodb_log_file_size By: carpii on Sat, 26 May 2007 16:58
	Re: InnoDB innodb_log_file_size By: Speeple on Sun, 27 May 2007 07:19
	Re: InnoDB innodb_log_file_size By: sterin on Sun, 27 May 2007 22:16
	Re: InnoDB innodb_log_file_size By: Speeple on Mon, 28 May 2007 07:40
	Re: InnoDB innodb_log_file_size By: tanj on Tue, 29 May 2007 11:06

Previous Topic:	MYSQL -- CPU Max Out; Very Poor Response
Next Topic:	13GB DB - Performance Question

Goto Forum:

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