MySQL Bugs: #14805: Out of memory warning in error log

Bug #14805	Out of memory warning in error log
Submitted:	9 Nov 2005 19:49	Modified:	10 Nov 2005 9:00
Reporter:	Antonio Nati	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.15	OS:	FreeBSD (FreeBSD 5.4)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
When starting MySQL, there is the following error within the error log:

051109 20:45:45  mysqld started
051109 20:45:46  InnoDB: Started; log sequence number 0 43655
/disco_db/mysql5_prg/mysql-standard-5.0.15-freebsd5.3-i386/bin/mysqld: Out of memory (Needed 237527040 bytes)
/disco_db/mysql5_prg/mysql-standard-5.0.15-freebsd5.3-i386/bin/mysqld: Out of memory (Needed 178145280 bytes)
051109 20:45:46 [Note] /disco_db/mysql5_prg/mysql-standard-5.0.15-freebsd5.3-i386/bin/mysqld: ready for connections.
Version: '5.0.15-standard-log'  socket: '/mysql5_data/posta/run_dir/mysql5.sock'  port: 13001  MySQL Community Edition - Standard (GPL)

How to repeat:
Simply running the server
It's the binaru downloaded from MySQL site.

I was unable to repeat the behavior reported:

[miguel@hegel:~/disco_db/mysql-standard-5.0.15-freebsd5.3-i386] $ uname -a
FreeBSD hegel.txg 5.4-RELEASE FreeBSD 5.4-RELEASE #0: Sun May  8 10:21:06 UTC 2005     root@harlow.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  i386
[miguel@hegel:~/disco_db/mysql-standard-5.0.15-freebsd5.3-i386] $ bin/mysqld --defaults-file=/home/miguel/disco_db/mysql-standard-5.0.15-freebsd5.3-i386/data/my.cnf 
051109 21:45:05  InnoDB: Started; log sequence number 0 43655
051109 21:45:05 [Note] bin/mysqld: ready for connections.
Version: '5.0.15-standard-log'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Edition - Standard (GPL)

However please see the below note at:

http://dev.mysql.com/doc/refman/5.0/en/freebsd.html

 FreeBSD limits the size of a process to 512MB, even if you have much more RAM available on the system. So you may get an error such as this:

Out of memory (Needed 16391 bytes)

In current versions of FreeBSD (at least 4.x and greater), you may increase this limit by adding the following entries to the /boot/loader.conf file and rebooting the machine (these are not settings that can be changed at run time with the sysctl command):

kern.maxdsiz="1073741824" # 1GB
kern.dfldsiz="1073741824" # 1GB
kern.maxssiz="134217728" # 128MB

Thanks, problem solved. I've followed your suggestion about kernel values (and decreased buffer values).