Mysql Hogging all system resources
wmoran at potentialtech.com
Thu Apr 12 20:31:57 UTC 2007
In response to "Don O'Neil" <lists at lizardhill.com>:
> 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 not.
man login.conf should tell you all you need to know.
More information about the freebsd-questions