More on MySQL -- Fatal trap 12

[Daniel Eischen]

On Thu, 19 Feb 2004, Julian Elischer wrote:
> 
> On Thu, 19 Feb 2004, Daniel Eischen wrote:
> 
> > On Wed, 18 Feb 2004, Kris Gale wrote:
> > 
> > > > I'm not sure what all the mumbo-jumbo is in your /etc/my.cnf,
> > > > but commenting out this line:
> > > >
> > > >   #set-variable    = key_buffer=1024M
> > > 
> > > This key buffer is shared amongst the threads.  This is the value
> > > I have set on an identical machine running -STABLE.
> > 
> > I can't even get mysqld to start with a value this large.
> 
> you probably don't have the 4GB of RAM he does :-)..

Not quite.

  CPU: Intel Pentium III (999.52-MHz 686-class CPU)
  Origin = "GenuineIntel"  Id = 0x68a  Stepping = 10
  Features=0x383fbff<FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,MMX,FXSR,SSE>
  real memory  = 1073676288 (1023 MB)
  avail memory = 1041158144 (992 MB)

I didn't now what 'key_buffer' really meant; I assumed it would be
backed by swap and that it wouldn't result in being wired.

-- 
Dan Eischen