MySQL kann nicht mehr als 2048MB RAM allozieren
Posted: 2006-04-12 19:31
Hi,
wenn ich zb.
setze, bekomme ich im syslog
Die Kiste ist ein 1und1 3XL, Debian Sarge mit "2.6.8-3-k7-smp #1 SMP" Kernel und folgendem dmesg: http://pastebin.com/655983
mysql ist ein "mysqld Ver 5.0.19-Debian_1.dotdeb.1-log for pc-linux-gnu on i386 (Dotdeb Sarge backport)"
Any clues, anyone?
cheers,
Ren
wenn ich zb.
Code: Select all
innodb_buffer_pool_size=2800MCode: Select all
Apr 12 19:07:51 s3 mysqld_safe[750]: started
Apr 12 19:07:51 s3 mysqld[753]: 060412 19:07:51 InnoDB: Error: cannot allocate 2936029184 bytes of
Apr 12 19:07:51 s3 mysqld[753]: InnoDB: memory with malloc! Total allocated memory
Apr 12 19:07:51 s3 mysqld[753]: InnoDB: by InnoDB 29721440 bytes. Operating system errno: 12
Apr 12 19:07:51 s3 mysqld[753]: InnoDB: Check if you should increase the swap file or
Apr 12 19:07:51 s3 mysqld[753]: InnoDB: ulimits of your operating system.
Apr 12 19:07:51 s3 mysqld[753]: InnoDB: On FreeBSD check you have compiled the OS with
Apr 12 19:07:51 s3 mysqld[753]: InnoDB: a big enough maximum process size.
Apr 12 19:07:51 s3 mysqld[753]: InnoDB: Note that in most 32-bit computers the process
Apr 12 19:07:51 s3 mysqld[753]: InnoDB: memory space is limited to 2 GB or 4 GB.
Apr 12 19:07:51 s3 mysqld[753]: InnoDB: We keep retrying the allocation for 60 seconds...mysql ist ein "mysqld Ver 5.0.19-Debian_1.dotdeb.1-log for pc-linux-gnu on i386 (Dotdeb Sarge backport)"
Any clues, anyone?
cheers,
Ren