From owner-freebsd-questions@FreeBSD.ORG Mon Aug 31 16:28:01 2009 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 8DEF1106566C for ; Mon, 31 Aug 2009 16:28:01 +0000 (UTC) (envelope-from apseudoutopia@gmail.com) Received: from mail-bw0-f206.google.com (mail-bw0-f206.google.com [209.85.218.206]) by mx1.freebsd.org (Postfix) with ESMTP id 1A2308FC12 for ; Mon, 31 Aug 2009 16:28:00 +0000 (UTC) Received: by bwz2 with SMTP id 2so2719573bwz.43 for ; Mon, 31 Aug 2009 09:27:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :from:date:message-id:subject:to:cc:content-type; bh=EP/uzpjZTAzIyJTm55iSTYqMJhd50RDt1kYR477qvBU=; b=O6vNylrAhg4jYRbYSjLFdzBZafAwkX/BiokKkCwItBoJ7VaCdpGbUKaELIUmJzCItd vCssZ1k41XUrVAzn91DPcjVoB1Ox0MmTpUl0fwJjBZrP8f9Sxr8n7RyaeOhsVlNz3jP1 mAG1rZKj1Q86KBSPpcQI2VIKJo3HqibsNDKcw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type; b=bFqe0pnppvqeTwucMItBpxrncNrvNEhaZWau4adGMbvfvgWAJinleYAVPAhBWNuD1k tREJHEqe7J8c1o/HnNTa9rI9WDRUEwfq8u2NFyDGOGGbGDkxEHHylWnyUAy+nFF4gd55 Gy8zv6E8JLSNpjCZwNKcvyeG2+JbEgmjLyuqk= MIME-Version: 1.0 Received: by 10.204.19.132 with SMTP id a4mr4451948bkb.21.1251736079156; Mon, 31 Aug 2009 09:27:59 -0700 (PDT) In-Reply-To: <05DAF099-1824-494E-BF33-9D14A765773A@identry.com> References: <05DAF099-1824-494E-BF33-9D14A765773A@identry.com> From: APseudoUtopia Date: Mon, 31 Aug 2009 12:27:39 -0400 Message-ID: <27ade5280908310927g323214ebx7a023e4282e8f4a2@mail.gmail.com> To: John Almberg Content-Type: text/plain; charset=UTF-8 Cc: freebsd-questions@freebsd.org Subject: Re: measuring mysql usage 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: Mon, 31 Aug 2009 16:28:01 -0000 On Mon, Aug 31, 2009 at 12:20 PM, John Almberg wrote: > Anyone know of a tool that can measure mysql usage per mysql user? > > My database is getting hammered by something, but I'm having a hard time > figuring out what. It seems to come and go. Perhaps I have one or two > websites that are just getting a lot of traffic, and maybe they just need > their own machines. I'm not sure, which is why I'm looking for ways to start > monitoring these sites and their resource usage - particularly db usage - > more closely. > > Any thoughts or tips, much appreciated. > > Thanks: John > Check out mTop. http://mtop.sourceforge.net/