Skip navigation links

MySQL Forums :: InnoDB :: Server won't start with innodb_buffer_pool_size over 1GB


Advanced Search

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: Reply•Quote


Subject Views Written By Posted
Server won't start with innodb_buffer_pool_size over 1GB 4251 Ryan Paulson 02/17/2005 03:27PM
Re: Server won't start with innodb_buffer_pool_size over 1GB 3000 Heikki Tuuri 02/18/2005 08:59AM
Re: Server won't start with innodb_buffer_pool_size over 1GB 2079 Ryan Paulson 02/18/2005 02:21PM
Re: Server won't start with innodb_buffer_pool_size over 1GB 1913 Cliff Cox 03/07/2005 12:34PM
Re: Server won't start with innodb_buffer_pool_size over 1GB 2921 Ryan Paulson 03/07/2005 03:45PM


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

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.