MySQL Forums
Forum List  »  InnoDB

Re: Server won't start with innodb_buffer_pool_size over 1GB
Posted by: Ryan Paulson
Date: March 07, 2005 03:45PM

Cliff Cox wrote:
> HI All:
> I have run into exactly the same thing. I cannot
> set the buffer pool over 1gb or the MySql server
> will not start.

I found the problem. It had to do with the max_connections parameter and my buffer settings. I started with 4GB RAM. On Windows Server 2003 Standard Edition too.

150 max_connections * (8M sort_buffer_size + 8M read_buffer_size) = 2400M of RAM "saved" for connections.

100 max_connections * 2M = 200M

Since my key_buffer_size is nothing since I don't use MyISAM, that leaves me with 1400M. That doesn't leave me much to work with for my innodb buffer pool.

I ended up lowering my sort and read buffer sizes and that allowed me to increase my innodb buffer pool size.

Give it a shot.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Server won't start with innodb_buffer_pool_size over 1GB
4030
March 07, 2005 03:45PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.