setting innodb_buffer_pool_size

[Michael Corr]

hi,
i;ve been able to install and run mysql 4.1.7 with the defaul settings, but now I'm trying to optimize its performance by tuning system variables in the my.ini file

I'm running Ver 14.7 Distrib 4.1.7, for Win95/Win98 (i32) on a dedicated Win2000 dual Xeon PC with 3GB physical RAM. I'm trying to follow the guidelines for setting the innodb_buffer_pool_size variable in the my.ini file. For a dedicated machine it says you can set this up to 80% of the physical RAM, which in my case is 2.4GB.

However, I can't get mysqld to start properly if I set innodb_buffer_pool_size to anything over 1500MB (50% of my physical RAM). I get the following error when I try setting it to 2400MB and run C:\>net start mysql


050728 15:01:04 InnoDB: Fatal error: cannot allocate 2516598784 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 134416068 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.
050728 15:01:04 [ERROR] C:\mysql\bin\mysqld-nt: Got signal 11. Aborting!
050728 15:01:04 [ERROR] Aborting
050728 15:01:04 [Note] C:\mysql\bin\mysqld-nt: Shutdown complete

I tried to find more info about "errno: 8", but couldn't find much.

any suggestions?

thanks,
Michael