>>>>> "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/