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 the physical network or anything
at the ip layer. possibly getting data into the transport (tcp/udp) layer or
above that.
on 8/2/01 10:19 AM, Ravi Raman at [EMAIL PROTECTED] wrote:
> hi.
>
> quick question...
> i have a simple query that returns ~53000 rows.
>
> when connected to the mysql server from localhost, this query takes about 2
> seconds.
> when connected to the mysql server from another box, this query takes about
> 3-4 minutes. 'show processlist' shows the query state as "Writing to net"
> for the majority of the query time.
> these boxes are right next to each other (1 hop) and ftp and scp transfers
> between them are quite fast.
>
> is this a network problem?
> the load average on both machines is quite low....they're running linux and
> relatively recent versions of mysql.
> what's going on here?
> what does the "writing to net" state mean (besides the obvious)? couldn't
> find any relevant docs.
>
> any input is appreciated.
>
> -ravi
-- mike cullerton
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
