mersenneforum.org  

Go Back   mersenneforum.org > Great Internet Mersenne Prime Search > Data > mersenne.ca

Reply
 
Thread Tools
Old 2020-11-16, 06:01   #23
James Heinrich
 
James Heinrich's Avatar
 
"James Heinrich"
May 2004
ex-Northern Ontario

1100101011002 Posts
Default

Quote:
Originally Posted by axn View Post
The site now renders.
That's more than I'm getting. Other domains on the server appear to be working, but for mersenne.ca I'm currently getting an Apache test page that I shouldn't be seeing. I'll look at it later, preferably after some sleep.

If the site is working for you now then great, if not then I'll try to fix it better in the morning.
James Heinrich is offline   Reply With Quote
Old 2020-11-16, 06:14   #24
Uncwilly
6809 > 6502
 
Uncwilly's Avatar
 
"""""""""""""""""""
Aug 2003
101×103 Posts

2×32×7×73 Posts
Default

I tried out a few things and came up with this error. This factor came in after you started the transition.
Attached Thumbnails
Click image for larger version

Name:	Pari-fail.jpg
Views:	53
Size:	49.7 KB
ID:	23793  
Uncwilly is offline   Reply With Quote
Old 2020-11-16, 15:01   #25
James Heinrich
 
James Heinrich's Avatar
 
"James Heinrich"
May 2004
ex-Northern Ontario

1100101011002 Posts
Default

I forgot that PARI wasn't installed, it is now.
Also ran into another security setting where tasks couldn't see the server outside webroot, so none of the scheduled tasks worked.
I'm still putting out fires as I find them...
James Heinrich is offline   Reply With Quote
Old 2020-11-16, 15:27   #26
James Heinrich
 
James Heinrich's Avatar
 
"James Heinrich"
May 2004
ex-Northern Ontario

62548 Posts
Default

One thing that puzzles me is that mersenne.ca shows up as expected under Firefox, but under Chrome I'm (still) getting a false Apache test page. Computers confuse me.
James Heinrich is offline   Reply With Quote
Old 2020-11-16, 15:56   #27
chalsall
If I May
 
chalsall's Avatar
 
"Chris Halsall"
Sep 2002
Barbados

2×3×1,567 Posts
Default

Quote:
Originally Posted by James Heinrich View Post
One thing that puzzles me is that mersenne.ca shows up as expected under Firefox, but under Chrome I'm (still) getting a false Apache test page. Computers confuse me.
Working fine here; under both Firefox and Chrome. http and non-www URL redirects are working fine.

Could it be your Chrome cache? Have you tried turning it off and on again?
chalsall is offline   Reply With Quote
Old 2020-11-16, 15:57   #28
James Heinrich
 
James Heinrich's Avatar
 
"James Heinrich"
May 2004
ex-Northern Ontario

22×811 Posts
Default

Currently fighting with getting GMP support enabled on the web version of PHP. It's not a module that ships with the bundled version of PHP, and while it is enabled on the system installation of PHP, it's not enabled on the website PHP instance...
James Heinrich is offline   Reply With Quote
Old 2020-11-16, 15:58   #29
James Heinrich
 
James Heinrich's Avatar
 
"James Heinrich"
May 2004
ex-Northern Ontario

22×811 Posts
Default

Quote:
Originally Posted by chalsall View Post
Working fine here; under both Firefox and Chrome. http and non-www URL redirects are working fine.
Could it be your Chrome cache? Have you tried turning it off and on again?
It works fine everywhere I've tried, except Chrome on my main computer. Chrome on my other computer works fine, other browsers on this computer work fine. I've clicked the magic button at chrome://net-internals/#dns to no avail. Closed and restarted Chrome. Can't restart computer, in the middle of a week-long compression task I can't interrupt.

Last fiddled with by James Heinrich on 2020-11-16 at 15:59
James Heinrich is offline   Reply With Quote
Old 2020-11-16, 17:29   #30
S485122
 
S485122's Avatar
 
Sep 2006
Brussels, Belgium

33·61 Posts
Default

Closing Chrome doesn't. There always remain a few instances running. There might be a setting not to leave Chrome add-ons or whatever running when Chrome is closed. Otherwise, use ps and kill in Linux or task manager if in Windows to forcefully kill all instances.

Those programs caching, cached data from another cache are annoying (and probably present a security or privacy issue.

Jacob
S485122 is offline   Reply With Quote
Old 2020-11-16, 21:42   #31
James Heinrich
 
James Heinrich's Avatar
 
"James Heinrich"
May 2004
ex-Northern Ontario

22×811 Posts
Default

Quote:
Originally Posted by James Heinrich View Post
Pretty graphs, if anyone cares. Database import is highly CPU-limited (single-core), and you can see how the different data table structure affects IOPS: earlier it was doing very small rows (12 bytes/record I think) with a single key, right now when it's importing larger rows with multiple indexes. ETA says 3.9h
For completeness I'm posting the same graph showing the full almost-12h database import. Two bits of interesting: the middle 3h or so where the IOPS drops to almost nothing is during the import of the 1000 "known_factors" tables, I'm not entirely sure why the IOPS is so different compared to the other tables. They are smaller SQL files, in the order of 20-30MB each, so maybe (totally speculating here) the whole SQL file can be read into memory where as the larger (1-3GB) SQL files get read line-by-line (or at least statement-by-statement). Just a guess.

The interesting/scary part is starting at 1900h on the graph (0:00 UTC) where the scheduled backup I didn't know was scheduled started doing its thing, running out of disk space very quickly. It got to 98% full before I found and killed it. And then deleted the 80GB or so of backups it had already made, hence the steep plunge in disk usage afterwards.

I think mersenne.ca should be up and running for the most part now. I'll need to check for missing data points in the assorted tables from jobs that probably didn't run at their appointed times last night. I did notice that when I manually ran the sync-to-primenet job that it runs at least 10x (maybe even 20x) faster on the new SSD+Xeon server than it did on the old server. As

Let me know if you find anything egregiously broken. And if it's only mildly broken, check tomorrow and if it's still broken then, tell me about it then.
Attached Thumbnails
Click image for larger version

Name:	graph2.png
Views:	26
Size:	121.4 KB
ID:	23796  
James Heinrich is offline   Reply With Quote
Old 2020-11-16, 21:54   #32
chalsall
If I May
 
chalsall's Avatar
 
"Chris Halsall"
Sep 2002
Barbados

2×3×1,567 Posts
Default

Quote:
Originally Posted by James Heinrich View Post
For completeness I'm posting the same graph showing the full almost-12h database import.
Very interesting. Thanks for sharing.

If I may ask, what did you move to? An Ionos VPS, or something different.

I'm always interested in what VPS offerings there are out there...
chalsall is offline   Reply With Quote
Old 2020-11-16, 22:13   #33
Mark Rose
 
Mark Rose's Avatar
 
"/X\(‘-‘)/X\"
Jan 2013

29×101 Posts
Default

Quote:
Originally Posted by James Heinrich View Post
For completeness I'm posting the same graph showing the full almost-12h database import. Two bits of interesting: the middle 3h or so where the IOPS drops to almost nothing is during the import of the 1000 "known_factors" tables, I'm not entirely sure why the IOPS is so different compared to the other tables. They are smaller SQL files, in the order of 20-30MB each, so maybe (totally speculating here) the whole SQL file can be read into memory where as the larger (1-3GB) SQL files get read line-by-line (or at least statement-by-statement). Just a guess.
What version of MySQL are you running?

You shouldn't see IO stalls like that.

Do those tables have foreign keys that aren't indexed on the foreign table? Or any triggers that have unindexed queries?
Mark Rose is offline   Reply With Quote
Reply

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Password recovery for v4 migration edr077 Information & Answers 1 2014-12-26 15:45
FactorDB is moving to another server this night -> some downtime Syd FactorDB 34 2012-02-03 19:18
Migration from Core 2 Quad to i7 965 Freightyard Hardware 30 2010-02-01 17:09
Planned downtime on GB servers mdettweiler No Prime Left Behind 35 2009-11-22 01:50

All times are UTC. The time now is 04:45.

Fri Jan 22 04:45:58 UTC 2021 up 50 days, 57 mins, 0 users, load averages: 2.72, 2.07, 2.08

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.

This forum has received and complied with 0 (zero) government requests for information.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.
A copy of the license is included in the FAQ.