On Wed, 24 Sep 2003, Misaochankun wrote: > Error(using 2.5G RAM out of 4G total): > > 030924 15:39:55 mysqld started > Warning: Ignoring user change to 'mysql' because the user was set to > 'mysql' earlier on the command line > InnoDB: Fatal error: cannot allocate 2684370944 bytes of > InnoDB: memory with malloc! Total allocated memory > InnoDB: by InnoDB 24482732 bytes. Operating system errno: 12 > InnoDB: Cannot continue operation!
If you set a smaller size and start mysql, so it is running successfully, how much memory does top and ps show mysqld as using? If your processes are getting close to 2 gigs of RAM total, that may be There are other parts of mysql that can be configured to use (sometimes a lot of) memory. the limit you are running into. By default on Linux, a process can only allocate about 1.9 gigs of memory using mmap(), which is what malloc() is probably using for large allocations. redhat may tweak these values in their kernels, but I don't know... that is the default limit on 2.4.x kernels anyway. You can tweak this to go higher, but only with modifying the kernel source. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
