On Wed, Jul 31, 2002 at 10:54:54AM +0200, mr wrote:
>
> Hello everybody
> I'd like to know what does that means: "Writing to net" in the state row of
> processlist.
> I have to launch a perl script which do traitement on a mysql table with
> 1.750.000 records.
It means just what it says--MySQL
on 8/3/01 10:30 AM, Ravi Raman at [EMAIL PROTECTED] wrote:
> what's up with that 30 second pause?
> does this look like a network problem to you guys? if it was, why would it
> not affect the 'limit 1' query as well?
> is there some sort of resource that mysql needs to process the 53000 rows
s?
maybe different tcpdump options are in order for more pertinent information?
again, thanks in advance for any ideas you may have.
-ravi.
-Original Message-
From: mike cullerton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 02, 2001 8:41 PM
To: Ravi Raman; [EMAIL PROTECTED]
Subject:
Date |Thu, 2 Aug 2001 12:19:52 -0400
>From |"Ravi Raman" <[EMAIL PROTECTED]>
Hello!
RR> hi.
RR> quick question...
RR> i have a simple query that returns ~53000 rows.
RR> when connected to the mysql server from localhost, this query takes about 2
RR> seconds.
RR> when connected to the mysql ser
being a network guy at heart, i'd like to see what tcpdump says is going
over the ethernet card (if anything). does there appear to be traffic moving
between the two machines, or is it caught in a buffer somewhere and hasn't
even made it to the cable.
since ftp works well, i'm guessing it isn't t
