Duplicate messages [[e-mail]: Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blog]

[Dan Nelson]

Is anyone else getting their posts sent back to them via fischhaber.de? 
It looks like "mysql@stripped" is re-sending all the messages it
receives.

----- Forwarded message from LS <alphafoo@stripped> -----

Return-Path: MAILER-DAEMON
Received: from gatekeeper.emsphone.com (root@stripped [199.67.51.100])
	by dan.emsphone.com (8.12.9/8.12.9) with ESMTP id h4O5kdtc040557
	for <dan@stripped>; Sat, 24 May 2003 00:46:39 -0500 (CDT)
Received: from mail.fischhaber.de (maserati.fischhaber.de [62.245.204.140])
	by gatekeeper.emsphone.com (8.12.9/8.12.9) with ESMTP id h4O5kW6h004452
	for <dnelson@stripped>; Sat, 24 May 2003 00:46:37 -0500
Received: by mail.fischhaber.de (Postfix, from userid 106)
	id 49FC821603D; Sat, 24 May 2003 07:46:06 +0200 (CEST)
X-Scanned-By: AMaViS served by fischhaber.de
Received: from lists.mysql.com (unknown [213.136.52.31])
	by mail.fischhaber.de (Postfix) with SMTP id AFBE5215FA8
	for <mysql@stripped>; Sat, 24 May 2003 07:45:48 +0200 (CEST)
Received: (qmail 8692 invoked by uid 109); 24 May 2003 05:45:10 -0000
Mailing-List: contact mysql-help@stripped; run by ezmlm
List-ID: <mysql.mysql.com>
Precedence: bulk
List-Help: <mailto:mysql-help@stripped>
List-Unsubscribe: <mailto:mysql-unsubscribe-mysql=calloon.de@stripped>
List-Post: <mailto:mysql@stripped>
Delivered-To: mailing list mysql@stripped
Received: (qmail 8674 invoked from network); 24 May 2003 05:45:10 -0000
Message-ID: <20030524054505.41868.qmail@stripped>
Date: Fri, 23 May 2003 22:45:05 -0700 (PDT)
From: LS <alphafoo@stripped>
Subject: Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blog
To: Dan Nelson <dnelson@stripped>
Cc: mysql@stripped
In-Reply-To: <20030524035218.GC46907@stripped>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Spam-Check-By: lists.mysql.com
X-Spam: False ; -17.7 / 5.0
X-Spam-Status: No, hits=-7.0 required=8.0
	tests=EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT,
	      REPLY_WITH_QUOTES,SENT_BY_MYSQL
	version=2.55
X-Spam-Checker-Version: SpamAssassin 2.55 (1.174.2.19-2003-05-19-exp)
Status: RO

Good idea! I set up this little loop in my bash shell to poll every second:

while (true) ; do ps axl | sed -n -e 1p -e /mysqld/p; sleep 1; done

Then I tried to replicate those slow queries and after a few minutes of trying, I
got the slow query, but didn't see anything from the loop above. I thought maybe I
just missed it, so I got the slow query to happen again, but still nothing from the
ps loop. So perhaps it's not an I/O wait problem....

I also tried replicating the problem while running a similar loop showing SHOW
PROCESSLIST, but I wasn't able to catch it in the act even after a dozen attempts.

Thanks for the suggestion though.

--- Dan Nelson <dnelson@stripped> wrote:
> In the last episode (May 23), LS said:
> > Thanks for the response! Sorry, I should have put more info in there
> > in the first place. The select and update queries you see below are
> > operating on two different databases, and the lock times are 0:
> > 
> > # Time: 030523 17:34:28
> > # User@Host: scott[tiger] @  [a.b.c.d]
> > # Query_time: 23  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
> > update my_big_table set some_flag='Y';
> > # User@Host: scott[tiger] @  [a.b.c.d]
> > # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
> > use other_db;
> > insert into status (hostname, snapshotTimestamp, m1, m2, total) values
> > ('host1','2003-05-23 17:34:26',252049128,1555431424,1782);
> > 
> > The update takes a while to churn through, which is normal. The
> > insert takes 2 seconds to be processed, which is the unusual part.
> 
> Hm. that is odd.  If you can catch it in the act, what's the output of
> "ps axl | sed -n -e 1p -e /mysqld/p" when this happens?  I'm interested
> in the WCHAN column.  A thread truly waiting on I/O will probably be in
> the "biord" state.  There might be something else causing that thread
> to slow down (I've never used a FreeBSD system with more than 1GB of
> RAM).
> 
> -- 
> 	Dan Nelson
> 	dnelson@stripped


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

----- End forwarded message -----

-- 
	Dan Nelson
	dnelson@stripped