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
---------------------------------------------------------------------
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
