From owner-freebsd-questions@FreeBSD.ORG  Wed Dec 17 00:53:25 2003
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 83A2D16A4CE
	for <questions@freebsd.org>; Wed, 17 Dec 2003 00:53:25 -0800 (PST)
Received: from stratus.mercurycloud.net (stratus.mercurycloud.net
	[64.246.167.156])
	by mx1.FreeBSD.org (Postfix) with ESMTP id B4F7343D50
	for <questions@freebsd.org>; Wed, 17 Dec 2003 00:53:18 -0800 (PST)
	(envelope-from lists-wp@mercurycloud.net)
Received: from localhost (localhost.mercurycloud.net [127.0.0.1])
	by stratus.mercurycloud.net (Postfix) with ESMTP id D574BA8
	for <questions@freebsd.org>; Wed, 17 Dec 2003 00:53:10 -0800 (PST)
Received: from stratus.mercurycloud.net ([127.0.0.1])
 by localhost (stratus.mercurycloud.net [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 01590-05 for <questions@freebsd.org>;
 Wed, 17 Dec 2003 00:53:10 -0800 (PST)
Received: from [192.168.0.103] (dsl254-030-205.sea1.dsl.speakeasy.net
	[216.254.30.205])	(using TLSv1 with cipher RC4-SHA (128/128 bits))
	(No client certificate requested)
	by stratus.mercurycloud.net (Postfix) with ESMTP id 90FDCA4
	for <questions@freebsd.org>; Wed, 17 Dec 2003 00:01:41 -0800 (PST)
Mime-Version: 1.0 (Apple Message framework v606)
Content-Transfer-Encoding: 7bit
Message-Id: <3C9232CA-3067-11D8-885A-000A95DBBE34@mercurycloud.net>
Content-Type: text/plain; charset=US-ASCII; format=flowed
To: questions@freebsd.org
From: Will Prater <lists-wp@mercurycloud.net>
Date: Wed, 17 Dec 2003 00:01:36 -0800
X-Mailer: Apple Mail (2.606)
Subject: mysql and slow_query_log
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
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: Wed, 17 Dec 2003 08:53:25 -0000

List,

I have log-slow-queries on and set my slow query time to 5.

Weird thing is, all the queries are being logged hostname-slow.log. 
Even the ones at 0 seconds.
Here is an example. What am I missing here?

----
select alias from virtual where username = 
'horde-bounces@lists.horde.org' and status = '1' limit 1;
# User@Host: mail[mail] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 24
select alias from virtual where username = '@lists.horde.org' and 
status = '1' limit 1;
----


--will