List:General Discussion« Previous MessageNext Message »
From:<vpendleton Date:March 2 2004 9:28pm
Subject:Re: no one can log on any more
View as plain text  
What version of Irix are you on again? Not meaning to inject this late 
but did you have a look at this section in the MySQL manual?
http://www.mysql.com/doc/en/SGI-Irix.html

>>>>>>>>>>>>>>>>>> Original Message
> <<<<<<<<<<<<<<<<<<

On 3/2/04, 3:05:39 PM, Bernd Jagla <jaglab@stripped> wrote regarding Re: 
no one can log on any more:


> ----- Original Message -----
> From: <vpendleton@stripped>
> To: "Bernd Jagla" <jaglab@stripped>
> Cc: "mysql" <mysql@stripped>
> Sent: Tuesday, March 02, 2004 3:43 PM
> Subject: Re: no one can log on any more


> Are you sure you allotted 512MB for both read_buffer and
> sort_buffer_size? Try reducing these values so that the total is roughly
> 80 percent of your total physical memory.

> >>>>>>>>>>>>>>>>>> Original
> Message <<<<<<<<<<<<<<<<<<

> On 3/2/04, 2:26:31 PM, Bernd Jagla <jaglab@stripped> wrote regarding Re:
> no one can log on any more:


> > ----- Original Message -----
> > From: <vpendleton@stripped>
> > To: "Bernd Jagla" <jaglab@stripped>
> > Cc: "mysql" <mysql@stripped>
> > Sent: Tuesday, March 02, 2004 3:14 PM
> > Subject: Re: no one can log on any more


> > The database server becomes unresponsive to new threads?
> > What is the result of the following equation?
> > key_buffer_size + ( (read_buffer_size + sort_buffer_size) * max
> > _connections )

> > 256 +((512 +512)*100)=100.25Gb

> > Yup, thats bigger that our physicall memory (100 Gb > 8 Gb)!!!
> > So I guess that might be the problem.... ;-)

> > Does the i/o error also relate to this problem?

> > Is this larger than you physicall memory?



> So I changed the variables now:

> 512M + (8M +8M)*100 = 2.1Gb

> Still same problem.
> But now the distinct works.

> I still can't log on when both queries are running....

> B
Thread
no one can log on any moreBernd Jagla2 Mar
  • Re: no one can log on any morevpendleton2 Mar
  • Re: no one can log on any moreBernd Jagla2 Mar
    • Re: no one can log on any morevpendleton2 Mar
  • Re: no one can log on any moreBernd Jagla2 Mar
    • Re: no one can log on any morevpendleton2 Mar
  • Re: no one can log on any moreBernd Jagla2 Mar
    • Re: no one can log on any morevpendleton2 Mar
  • Re: no one can log on any moreBernd Jagla2 Mar
    • Re: no one can log on any morevpendleton2 Mar
  • Re: no one can log on any moreBernd Jagla2 Mar
    • Re: no one can log on any morevpendleton2 Mar
  • Re: no one can log on any moreMartijn Tonies2 Mar
  • Re: no one can log on any moreBernd Jagla2 Mar
    • Re: no one can log on any morevpendleton2 Mar
  • Re: no one can log on any moreSasha Pachev2 Mar