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 server from another box, this query takes about
RR> 3-4 minutes. 'show processlist' shows the query state as "Writing to net"
RR> for the majority of the query time.
RR> these boxes are right next to each other (1 hop) and ftp and scp transfers
RR> between them are quite fast.
RR> is this a network problem?
RR> the load average on both machines is quite low....they're running linux and
RR> relatively recent versions of mysql.
RR> what's going on here?
RR> what does the "writing to net" state mean (besides the obvious)? couldn't
RR> find any relevant docs.
RR> any input is appreciated.
Very simple.
If you connect to mysql on local machine it's happen through Unix-socket on
unix and through local connection on windows.
It's much faster than remote connection - no network used.
___________________________________________________________________
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Grigory Bakunov <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft
/_/ /_/\_, /___/\___\_\___/
<___/ www.mysql.com
---------------------------------------------------------------------
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
