Server won't start with innodb_buffer_pool_size over 1GB
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
Subject
Views
Written By
Posted
Server won't start with innodb_buffer_pool_size over 1GB
7870
February 17, 2005 03:27PM
4865
February 18, 2005 08:59AM
3010
February 18, 2005 02:21PM
2864
March 07, 2005 12:34PM
4596
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.