Mysql Hogging all system resources

Don O'Neil lists at
Thu Apr 12 23:19:02 UTC 2007

This isn't exactly what I want to do. According to the FreeBSD Handbook, by
defining a CPU limit it will just kill any process that uses more than the
limit. What I want to do is effectively throttle the process so it doesn't
use up more than a certain % CPU, but still lives, esentially taking longer
to process than if it had unlimited resources. That way the process still
runs and the system isn't taken to it's knees.

-----Original Message-----
From: owner-freebsd-questions at
[mailto:owner-freebsd-questions at] On Behalf Of Bill Moran
Sent: Thursday, April 12, 2007 1:32 PM
To: Don O'Neil
Cc: freebsd-questions at
Subject: Re: Mysql Hogging all system resources

In response to "Don O'Neil" <lists at>:

> I have a customer that loaded up a HUGE table and was doing all sorts 
> of fancy stuff in it, and not waiting for the process to finish before 
> sending the same query, and eventually loading up the server to the 
> point where the only thing I could do was unplug it.
> Is there a way to prioritize or set the amount of resources that MySQL 
> is allowed to have? Do I need to set it up as a jailed process maybe? 
> I've never done that before, so I'm not sure if it's the right approach or

man login.conf should tell you all you need to know.

Bill Moran
freebsd-questions at mailing list
To unsubscribe, send any mail to "freebsd-questions-unsubscribe at"

More information about the freebsd-questions mailing list