From owner-freebsd-questions@FreeBSD.ORG  Mon Aug 31 16:20:40 2009
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 7678B1065670
	for <freebsd-questions@freebsd.org>;
	Mon, 31 Aug 2009 16:20:40 +0000 (UTC)
	(envelope-from jalmberg@identry.com)
Received: from smtp-gw29.mailanyone.net (smtp-gw29.mailanyone.net
	[208.70.128.55])
	by mx1.freebsd.org (Postfix) with ESMTP id 554FB8FC0A
	for <freebsd-questions@freebsd.org>;
	Mon, 31 Aug 2009 16:20:40 +0000 (UTC)
Received: from mailanyone.net
	by smtp-gw29.mailanyone.net with esmtpa (MailAnyone extSMTP
	jalmberg@identry.com) id 1Mi9cU-0007xg-Ch
	for freebsd-questions@freebsd.org; Mon, 31 Aug 2009 11:20:39 -0500
Mime-Version: 1.0 (Apple Message framework v753.1)
Content-Transfer-Encoding: 7bit
Message-Id: <05DAF099-1824-494E-BF33-9D14A765773A@identry.com>
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
To: freebsd-questions@freebsd.org
From: John Almberg <jalmberg@identry.com>
Date: Mon, 31 Aug 2009 12:20:36 -0400
X-Mailer: Apple Mail (2.753.1)
Subject: measuring mysql usage
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 31 Aug 2009 16:20:40 -0000

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