List:General Discussion« Previous MessageNext Message »
From:Vivek Khera Date:March 22 2000 3:08pm
Subject:Re: MySQL crashing when memory runs out
View as plain text  
>>>>> "SM" == Sam Mefford <sam@stripped> writes:

SM> Apparently we need to figure out how to tell mysql not to use more
SM> than a limit of memory . . . is it even possible to write mysql so
SM> it won't try to use more memory than there is available?

MySQL is already very memory conservative by default.  It seems to me
you're running into the generic linux problems with dealing with
short-on-memory situations.  My understanding is that it starts to
kill off processes.

But there are many parameters you can tune in MySQL to reduce the
memory requirements at the cost of speed (more disk access.)  You
don't really want to do that, do you?

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@stripped       Rockville, MD       +1-301-545-6996
PGP & MIME spoken here            http://www.kciLink.com/home/khera/
Thread
MySQL crashing when memory runs outSam Mefford21 Mar
  • Re: MySQL crashing when memory runs outsasha21 Mar
    • Re: MySQL crashing when memory runs outsinisa21 Mar
  • Re: MySQL crashing when memory runs outVivek Khera21 Mar
  • Re: MySQL crashing when memory runs outSam Mefford21 Mar
  • Re: MySQL crashing when memory runs outsasha21 Mar
  • Re: MySQL crashing when memory runs outSam Mefford22 Mar
    • Re: MySQL crashing when memory runs outVivek Khera22 Mar
  • Re: MySQL crashing when memory runs outsasha22 Mar