MySQL Forums
Forum List  »  InnoDB

Server won't start with innodb_buffer_pool_size over 1GB
Posted by: Ryan Paulson
Date: February 17, 2005 03:27PM

I'm running on Windows Server 2003 Standard addition. Dual 3.8GHZ with 4GB RAM.

The following ini file works fine, but if I bump the innodb_buffer_pool_size up to say 1152MB, it won't start and the error I get is:

InnoDB: Fatal error: cannot allocate 4293935104 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 134315888 bytes. Operating system errno: 8
InnoDB: Cannot continue operation!
InnoDB: Check if you should increase the swap file or
InnoDB: ulimits of your operating system.
InnoDB: On FreeBSD check you have compiled the OS with
InnoDB: a big enough maximum process size.
InnoDB: We now intentionally generate a seg fault so that
InnoDB: on Linux we get a stack trace.
050217 15:14:00 mysqld: Got signal 11. Aborting!

050217 15:14:00 Aborting

050217 15:14:00 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
050217 15:14:00 mysqld: Shutdown Complete


--------------------------
my.ini file


#Created: 02/17/2005
#Modified: 02/17/2005

[mysqld]
basedir=C:/mysql
datadir=C:/mysql/data

server-id=10

log_slow_queries
long_query_time=5
#log-bin
#log-slave-updates

set-variable = max_connections=10
set-variable = thread_cache_size=10

set-variable = read_buffer_size=8M
set-variable = sort_buffer_size=8M
set-variable = join_buffer_size=8M

set-variable = query_cache_limit=2M
set-variable = query_cache_size=64M

set-variable = tmp_table_size=128M

set-variable = key_buffer_size=256M

set-variable = innodb_additional_mem_pool_size=16M
set-variable = innodb_buffer_pool_size=1024M
set-variable = innodb_file_io_threads=12
set-variable = innodb_log_buffer_size=16M

Options: ReplyQuote


Subject
Views
Written By
Posted
Server won't start with innodb_buffer_pool_size over 1GB
7870
February 17, 2005 03:27PM


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.