Subject: Re: MySQL: very large key_buffer on amd64?
To: Chris Kantarjiev <cak@dimebank.com>
From: Frank van der Linden <fvdl@netbsd.org>
List: port-amd64
Date: 09/19/2005 21:56:33
Chris Kantarjiev wrote:

>053419 11:34:15  Starting mysqld daemon with databases from /var/mysql
>053419 11:34:15  mysqld started
>mysqld: Couldn't allocate stack for idle thread!: Cannot allocate memory
>053419 11:34:15  STOPPING server from pid file /var/mysql/vern.landsonar.com.pid
>053419 11:34:15  mysqld ended
>  
>

Hm.. can you ktrace this and see which call fails? Also don't forget to 
unlimit the data size before you start mysql (commands vary depending on 
the shell you're using); the default data size is too low. The maximum 
currently is 8G.

The 2G number you mention does indicate that mysql may have a 32bit 
overflow issue, though.

- Frank