pkg/40436: mysql server from pkgsrc-208Q4, max-join-size

[reinhold_nbsd%obstsorten.de@localhost]

>Number:         40436
>Category:       pkg
>Synopsis:       mysql server from pkgsrc-208Q4, max-join-size
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    pkg-manager
>State:          open
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Mon Jan 19 17:20:00 +0000 2009
>Originator:     Reinhold
>Release:        NetBSD 3.1 (GENERIC)
>Organization:
>Environment:
NetBSD bernoulli.obstsorten.de 3.1 NetBSD 3.1 (GENERIC) #0: Tue Oct 31 04:27:07 
UTC 2006  
builds%b0.netbsd.org@localhost:/home/builds/ab/netbsd-3-1-RELEASE/i386/200610302053Z-obj/home/builds/ab/netbsd-3-1-RELEASE/src/sys/arch/i386/compile/GENERIC
 i386

>Description:
Installing mysql-server from pkgsrc-2008Q4

Starting mysql give the output in the mysql-error.log below.

I mean the warnings relating to "max-join-size" .


095619 17:56:43  Starting mysqld daemon with databases from /var/mysql
095619 17:56:43  mysqld started

090119 17:56:43 [Warning] option 'max_join_size': unsigned value 
18446744073709551615 adjusted to 4294967295
090119 17:56:43 [Warning] option 'max_join_size': unsigned value 
18446744073709551615 adjusted to 4294967295

/usr/pkg/libexec/mysqld: Out of memory (Needed 237527040 bytes)
/usr/pkg/libexec/mysqld: Out of memory (Needed 178145280 bytes)
/usr/pkg/libexec/mysqld: Out of memory (Needed 133607424 bytes)
/usr/pkg/libexec/mysqld: Out of memory (Needed 100205568 bytes)
090119 17:56:43 [Note] /usr/pkg/libexec/mysqld: ready for connections.
Version: '5.0.67-log'  socket: '/tmp/mysql.sock'  port: 3306  Source 
distribution


>How-To-Repeat:
Install an fresh mysql server and start it.
>Fix: