Re: Server won't start with innodb_buffer_pool_size over 1GB

[Ryan Paulson]

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.