From owner-freebsd-questions@FreeBSD.ORG Thu Apr 12 23:27:28 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 21F4B16A404 for ; Thu, 12 Apr 2007 23:27:28 +0000 (UTC) (envelope-from cswiger@mac.com) Received: from mail-out3.apple.com (mail-out3.apple.com [17.254.13.22]) by mx1.freebsd.org (Postfix) with ESMTP id 09DC513C469 for ; Thu, 12 Apr 2007 23:27:27 +0000 (UTC) (envelope-from cswiger@mac.com) Received: from relay5.apple.com (a17-128-113-35.apple.com [17.128.113.35]) by mail-out3.apple.com (8.13.8/8.13.8) with ESMTP id l3CNRR6u010827; Thu, 12 Apr 2007 16:27:27 -0700 (PDT) Received: from relay5.apple.com (unknown [127.0.0.1]) by relay5.apple.com (Symantec Mail Security) with ESMTP id B204529C003; Thu, 12 Apr 2007 16:27:27 -0700 (PDT) X-AuditID: 11807123-9f3e8bb000000b42-e2-461ec05e827b Received: from [17.214.13.96] (cswiger1.apple.com [17.214.13.96]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) by relay5.apple.com (Apple SCV relay) with ESMTP id E4B1E30400B; Thu, 12 Apr 2007 16:27:26 -0700 (PDT) In-Reply-To: <005801c77d58$ee387560$0300020a@mickey> References: <001301c77d3f$aa57f050$0300020a@mickey> <20070412163155.61ec8b40.wmoran@potentialtech.com> <005801c77d58$ee387560$0300020a@mickey> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Content-Transfer-Encoding: 7bit From: Chuck Swiger Date: Thu, 12 Apr 2007 16:27:26 -0700 To: "Don O'Neil" X-Mailer: Apple Mail (2.752.2) X-Brightmail-Tracker: AAAAAA== Cc: 'Bill Moran' , freebsd-questions@freebsd.org Subject: Re: Mysql Hogging all system resources X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 12 Apr 2007 23:27:28 -0000 On Apr 12, 2007, at 4:18 PM, Don O'Neil wrote: > 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. Use the nice or renice commands to lower the priority of the MySQL server so that it will not preempt other processes which want to run at normal priority? -- -Chuck