Date: Thu, 12 Apr 2007 16:31:55 -0400 From: Bill Moran <wmoran@potentialtech.com> To: "Don O'Neil" <lists@lizardhill.com> Cc: freebsd-questions@freebsd.org Subject: Re: Mysql Hogging all system resources Message-ID: <20070412163155.61ec8b40.wmoran@potentialtech.com> In-Reply-To: <001301c77d3f$aa57f050$0300020a@mickey> References: <001301c77d3f$aa57f050$0300020a@mickey>
next in thread | previous in thread | raw e-mail | index | archive | help
In response to "Don O'Neil" <lists@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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20070412163155.61ec8b40.wmoran>