MySQL Forums :: InnoDB :: Server won't start with innodb_buffer_pool_size over 1GB
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.
> 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.
| Subject | Views | Written By | Posted |
|---|---|---|---|
| Server won't start with innodb_buffer_pool_size over 1GB | 6317 | Ryan Paulson | 02/17/2005 03:27PM |
| Re: Server won't start with innodb_buffer_pool_size over 1GB | 3993 | Heikki Tuuri | 02/18/2005 08:59AM |
| Re: Server won't start with innodb_buffer_pool_size over 1GB | 2624 | Ryan Paulson | 02/18/2005 02:21PM |
| Re: Server won't start with innodb_buffer_pool_size over 1GB | 2476 | Cliff Cox | 03/07/2005 12:34PM |
| Re: Server won't start with innodb_buffer_pool_size over 1GB | 3879 | Ryan Paulson | 03/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.