mysql5 fetch takes a long time from mysql.mirrors.pair.com

[weinmaster@…]

When attempting to install the mysql5-server port, the operation hangs at the following:

---> Attempting to fetch mysql-5.1.48.tar.gz from http://mysql.mirrors.pair.com/Downloads/MySQL-5.1/

[ryandesign (Ryan Carsten Schmidt)]

I am able to download from that server, but it goes at a rate of 10K/sec, so it would take 40 minutes to complete. How long did you wait? Maybe we should remove that mirror if it is routinely that slow.

[adrian@…]

Here's a "Me too"

I'm getting about 5K/minute from the host. Even going to the directory in my browser resulted in the file list taking about 20 seconds to fully load.

[weinmaster@…]

I am still unable to download from the specified server. What I experience is the 5k/minute rate, but interlaced with 2 seconds of no activity. Even after giving the port 2+ hours to download, it didn't complete. I agree with adrian@…, downloading mysql5 directly from the website takes about 20 seconds.

[chrisbloom7 (Chris Bloom)]

Cc Me!

[chrisbloom7 (Chris Bloom)]

I tried updating MacPorts, thinking maybe I had an old version and some mirror had changed, but that didn't change anything. It just sits there at "Attempting to fetch mysql-5.1.48.tar.gz from ​http://mysql.mirrors.pair.com/Downloads/MySQL-5.1/"

[chrisbloom7 (Chris Bloom)]

Now I'm noticing the same behavior from the gettext mirror, too.

Attempting to fetch gettext-0.18.1.1.tar.gz from ​http://distfiles.macports.org/gettext

[chrisbloom7 (Chris Bloom)]

Still an issue with MySQL. I just called Pair Netlworks to let them know about the issue since it seems to be their server that is responding so slow, and less to do with MacPorts. Still, it woud be helpful if there was a way to specify a different mirror to use or to specify a download speed threshold before trying another server.

[chrisbloom7 (Chris Bloom)]

Received a response from Pair Networks:

---

Thank you for brining this to our attention. We are taking a look at it now. This machine also hosts the Firefox mirror and we are seeing a lot of traffic to that. Which may be the cause of the slowness you experienced.

---

Trying to download directly via my browser saw speeds of 2mb/sec initially, but it's slowly sinking back to the single-digit kb/sec range.

I also let MacPorts chug away for an hour or so in the background and MySQL did eventually install, but not sure how long it took exactly.

[chrstphrchvz (Christopher Chavez)]

Did this issue ever go away? When I curl a file from that mirror, it seems to download very quickly, but spends several seconds stuck at 99% before finishing:

$ curl http://mysql.mirrors.pair.com/Downloads/MySQL-5.1/mysql-5.1.73.tar.gz --output mysql-5.1.73.tar.gz
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
  2 22.9M    2  611k    0     0  1204k      0  0:00:19 --:--:--  0:00:19 1204k
 28 22.9M   28 6627k    0     0  4289k      0  0:00:05  0:00:01  0:00:04 4287k
 63 22.9M   63 14.4M    0     0  5901k      0  0:00:03  0:00:02  0:00:01 5899k
 99 22.9M   99 22.7M    0     0  6612k      0  0:00:03  0:00:03 --:--:-- 6610k
 99 22.9M   99 22.8M    0     0  5142k      0  0:00:04  0:00:04 --:--:-- 5142k
 99 22.9M   99 22.8M    0     0  4212k      0  0:00:05  0:00:05 --:--:-- 4515k
 99 22.9M   99 22.8M    0     0  3569k      0  0:00:06  0:00:06 --:--:-- 3347k
 99 22.9M   99 22.8M    0     0  3095k      0  0:00:07  0:00:07 --:--:-- 1702k
 99 22.9M   99 22.8M    0     0  2733k      0  0:00:08  0:00:08 --:--:-- 31632
 99 22.9M   99 22.8M    0     0  2447k      0  0:00:09  0:00:09 --:--:--     0
 99 22.9M   99 22.8M    0     0  2215k      0  0:00:10  0:00:10 --:--:--     0
 99 22.9M   99 22.8M    0     0  2023k      0  0:00:11  0:00:11 --:--:--     0
 99 22.9M   99 22.8M    0     0  1861k      0  0:00:12  0:00:12 --:--:--     0
 99 22.9M   99 22.8M    0     0  1723k      0  0:00:13  0:00:13 --:--:--     0
 99 22.9M   99 22.8M    0     0  1605k      0  0:00:14  0:00:14 --:--:--     0
 99 22.9M   99 22.8M    0     0  1501k      0  0:00:15  0:00:15 --:--:--     0
 99 22.9M   99 22.8M    0     0  1410k      0  0:00:16  0:00:16 --:--:--     0
 99 22.9M   99 22.8M    0     0  1330k      0  0:00:17  0:00:17 --:--:--     0
 99 22.9M   99 22.8M    0     0  1258k      0  0:00:18  0:00:18 --:--:--     0
100 22.9M  100 22.9M    0     0  1184k      0  0:00:19  0:00:19 --:--:--  8900

[chrstphrchvz (Christopher Chavez)]

​http://mysql.mirrors.pair.com has now been refusing connections for some time.

There is a PR open which will remove it: ​https://github.com/macports/macports-ports/pull/7257

[Eric F <3958664+iefdev@…>]

In f99cd49cdc409be79cbfe48a44cd489c9215f995/macports-ports (master):

Update mirror_sites.tcl (​https://github.com/macports/macports-ports/pull/7257)

Remove dead URLs; add new ones.

Closes: #60558
See: #60509
Closes: #25674