From owner-freebsd-questions@FreeBSD.ORG Fri Apr 13 18:24:24 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 BC06616A408 for ; Fri, 13 Apr 2007 18:24:24 +0000 (UTC) (envelope-from root@seznam.cz) Received: from mxl.seznam.cz (mxln.seznam.cz [212.80.76.44]) by mx1.freebsd.org (Postfix) with SMTP id 086DD13C44B for ; Fri, 13 Apr 2007 18:24:23 +0000 (UTC) (envelope-from root@seznam.cz) Received: (qmail 11435 invoked by uid 0); 13 Apr 2007 18:10:35 -0000 Received: (qmail 31668 invoked by uid 0); 12 Apr 2007 20:19:47 -0000 X-Spam-Checker-Version: szn-spamassassin 2006-02-02 X-Spam-Status: score=-11.2 Received: from 213.136.52.31 (HELO lists.mysql.com) by email-mx1.go.seznam.cz id FixusSMTPd29228; 12 Apr 2007 20:19:41 -0000 Received: (qmail 12034 invoked by uid 510); 12 Apr 2007 20:12:26 -0000 Mailing-List: contact mysql-help@lists.mysql.com; run by ezmlm Precedence: bulk Delivered-To: mailing list mysql@lists.mysql.com Received: (qmail 11987 invoked by uid 509); 12 Apr 2007 20:12:25 -0000 Received-SPF: pass (lists.mysql.com: domain of lists@lizardhill.com designates 64.69.41.217 as permitted sender) From: "Don O'Neil" To: , Date: Thu, 12 Apr 2007 13:17:59 -0700 Message-ID: <001301c77d3f$aa57f050$0300020a@mickey> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 Thread-Index: Acd9P6n7y34k+6LQRqmPcmQEvswAsQ== X-Cxn-Txn: 10267680,6970897 X-Smtpd: szn-smtpd v1.3-5 X-NOD32Result: clean (vdv=2128) Cc: Subject: Mysql Hogging all system resources X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 13 Apr 2007 18:24:24 -0000 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. I'm running FreeBSD 6.1. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=vajsar@post.cz