Mysql Hogging all system resources

[Bill Moran]

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.

-- 
Bill Moran
http://www.potentialtech.com