On Thu, Jan 31, 2002 at 05:31:02PM -0500, Gary Huntress wrote: > As you can see from my signature, I run FreeSQL.org. Over the past > year I have had great success and grew in a manageable fasion. > Believe it or not, I've been hosting this site on a cable modem. Up > until recently, bandwidth really hasn't been a problem. However, in > the past month or so, probably due to Cox/@home/comcast > reconfigurations, my upload speeds have been terrible. Ping times > to any public site are on the order of seconds (2000 to 4500 > milliseconds ) and as you know this generally causes a network to be > unusable.
Ouch! > For the short term, the solution that I have arrived at is to > throttle the bandwidth on the mysql port. I typically max out at > 50KBps upload, and I need about 15KBps for my own personal use > (maybe a bit less). I run my servers NATed behind a redhat firewall > running ipchains, I believe I can do the throttling without > upgrading to netfilter (remember, this is short term!) Hmm. Seems reasonable. > My question is this. Database server network usage is very > asymmetric, incoming queries are small, outbound datasets are > probably considerably larger. Very true. > Given that I will now be further limiting outbound flow without > really impacting the arrival rate of queries, can/does mysql manage > this? MySQL can only use the available bandwidth, so the net result is that queries will stay "active" longer because it'll take MySQL longer to send the results over the network. MySQL won't care one way or the other, but eventually it's going to become unbearable for your users, I'd suspect. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 29 days, processed 653,063,095 queries (258/sec. avg) --------------------------------------------------------------------- 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
