Date: Fri, 13 Apr 2007 14:45:00 -0700 From: "Don O'Neil" <lists@lizardhill.com> To: <freebsd-questions@freebsd.org>, <mysql@lists.mysql.com> Subject: RE: Mysql Hogging all system resources Message-ID: <026f01c77e14$fcf77530$0300020a@mickey> In-Reply-To: <025201c77e14$5cd35d30$0300020a@mickey> References: <001301c77d3f$aa57f050$0300020a@mickey> <1BB47BFC-181B-4CED-B0C0-870D8816A004@mac.com> <025201c77e14$5cd35d30$0300020a@mickey>
next in thread | previous in thread | raw e-mail | index | archive | help
Nevermind on the "badly formatted number"... I specified the full path /usr/bin/nice and it worked ok this time :-) However, I still want to know if there is a way to specify a nice level for an entire users processes. Thanks! -----Original Message----- From: Don O'Neil [mailto:lists@lizardhill.com] Sent: Friday, April 13, 2007 2:41 PM To: 'Chuck Swiger' Cc: freebsd-questions@freebsd.org; mysql@lists.mysql.com Subject: RE: Mysql Hogging all system resources Is there a way to set a 'nice' priority for a particular user? Also, when I run this: nice -n 5 /usr/bin/spamd -d -c -m 5 I get: nice: Badly formed number. I ran a man page on it, and this is the right format, but its not working. -----Original Message----- From: Chuck Swiger [mailto:cswiger@mac.com] Sent: Friday, April 13, 2007 11:38 AM To: Don O'Neil Cc: freebsd-questions@freebsd.org; mysql@lists.mysql.com Subject: Re: Mysql Hogging all system resources On Apr 12, 2007, at 1:17 PM, Don O'Neil wrote: [ ... ] > 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. Um, didn't you ask this question yesterday? Use nice/renice to change the process priority of the MySQL server so that you don't starve other processes of CPU.... -- -Chuck -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=lists@lizardhill.com
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?026f01c77e14$fcf77530$0300020a>