On Tue, Mar 19, 2002 at 09:14:36PM -0600, Dan Nelson wrote:
> ( I'm assuming you really want to run mysql with > 512MB of cache here )
> FreeBSD by default sets a hard max datasize limit of 512MB. To
> raise that, say, to 1gb, you'll either need to rebuild your kernel
> with "options MAXDSIZ=(1024*1024*1024)", or add the line
> "kern.maxdsiz=1073741824" to /etc/loader.conf, and reboot.
Son of a $%^*(*$*@!!!
I *knew* that.
We used to run with a 384MB key buffer, but guess who bumped it up to
512MB not too long ago (and forgot about the change).
Thanks for pointing me in the right direction (180 degrees from where
I was looking).
Jeremy D. Zawodny, <jzawodn@stripped>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.47-max: up 40 days, processed 1,201,233,516 queries (342/sec. avg)