Author |
Message |
frederick
Posted on: Tue Oct 15, 2013 2:03 pm
Posts: 181 Location: Canada Joined: Thu Aug 04, 2011 7:40 pm
|
Re: server change
All hail and kudos to our worthy and esteemed leader!
Thank you Monsieur pnm for your valiant efforts.
The site runs like a charm!
|
|
|
|
pnm
Posted on: Thu Oct 17, 2013 9:50 am
Posts: 3301 Joined: Thu May 12, 2011 11:58 pm
|
Re: server change
Unfortunately I still got a report of the page at least once taking minutes (!) to load.
I've added "page processing time" and "page load time" information at the bottom of the page, do let me know if anything unusual shows up there.
(from here they're typically < 0.5 sec for processing, and 1-2 sec for loading).
Also, the full database backup (now running at 7.42 CET) is still causing a few timeout errors (temporarily affecting 2-3 users) :-( , I want those to go away..
Patrick
|
|
|
|
jaek
Posted on: Fri Oct 18, 2013 6:35 pm
Posts: 300 Joined: Fri Jun 17, 2011 8:15 pm
|
Re: server change
pnm wrote: I've added "page processing time" and "page load time" information at the bottom of the page, do let me know if anything unusual shows up there.
(from here they're typically < 0.5 sec for processing, and 1-2 sec for loading). Of the puzzles I solved yesterday for which I thought to check the latency (8 of 12 timed puzzles, 6M, 9D, 12D, KSD), I found the following: Code: Processing Loading Max 0.522 2.228 Mean 0.252 1.535 Median 0.232 1.426 Min 0.135 1.346
That's from Texas, fwiw. Feels much faster than before, honestly. Thanks for upgrading.
|
|
|
|
pnm
Posted on: Fri Oct 18, 2013 6:54 pm
Posts: 3301 Joined: Thu May 12, 2011 11:58 pm
|
Re: server change
jaek wrote: That's from Texas, fwiw. Feels much faster than before, honestly. Thanks for upgrading. Great, thanks for the info. I could log all the latencies + locations to get a better picture (if I find some time for that..). And strictly speaking it was a downgrade, but to a server than runs 1 site (instead of the 220+, many of which get hacked on a regular basis )
|
|
|
|
pnm
Posted on: Sun Oct 27, 2013 5:53 pm
Posts: 3301 Joined: Thu May 12, 2011 11:58 pm
|
Re: server change
I've added a few more tweaks and optimizations, the page should load a bit faster still
|
|
|
|
bram
Posted on: Mon Oct 28, 2013 3:06 am
Posts: 253 Joined: Tue May 24, 2011 4:55 pm
|
Re: server change
pnm wrote: And strictly speaking it was a downgrade, but to a server than runs 1 site (instead of the 220+, many of which get hacked on a regular basis ) Best downgrade ever! There has been no lag at all since this site escaped from Horrible Hosting, Inc. – not even during the critical first hour after midnight CET
|
|
|
|
bram
Posted on: Sat Jan 18, 2014 2:39 am
Posts: 253 Joined: Tue May 24, 2011 4:55 pm
|
Re: server change
I don't know if this is due to a server problem, but for the first time in nearly three months I have experienced lagging when submitting the puzzles – and finally the dreaded error message: There were 3 attempts to send your solution,and it is still not working. Our apologies,please try again later. But even if I got the error message, the puzzle in question did show up in my history and also duly "turned green" on the front page. As before, the forum (and the loading of puzzles, unlike the submission of solved puzzles to the server) doesn't seem to be slowed down. (edited to add:) At 02:00 CET, I noticed the problem had disappeared. Goodnight
|
|
|
|
pnm
Posted on: Sat Jan 18, 2014 10:20 am
Posts: 3301 Joined: Thu May 12, 2011 11:58 pm
|
Re: server change
bram wrote: I don't know if this is due to a server problem, but for the first time in nearly three months I have experienced lagging when submitting the puzzles – and finally the dreaded error message: Yes, I'm seeing that too, a couple of times these past few days. Last night around 00.30 CET. The server is busy then, but not too busy I think. I've installed a system stats collector on the server (should have done that right away of course), and will check them later. Patrick
|
|
|
|
pnm
Posted on: Wed Jan 22, 2014 5:51 pm
Posts: 3301 Joined: Thu May 12, 2011 11:58 pm
|
Re: server change
bram wrote: I don't know if this is due to a server problem, but for the first time in nearly three months I have experienced lagging when submitting the puzzles – and finally the dreaded error message: It seems this happens whenever a few people (3 or more (!)) access the rankings page at the same time. Parts of the code there are still terribly inefficient, thereby overloading the database server. I've put in one efficiency improvement just now, which already makes a huge difference. In the longer term I want to have the rankings pages be managed by the same code that now does the 'ticker': it'll continuously keep track of the rankings lists and serve those as requested, instead of recomputing them every time someone requests the page (which should make them orders of magnitude faster and as a result no longer interfere with the rest of the site :) Patrick
|
|
|
|
bram
Posted on: Wed Jan 22, 2014 9:22 pm
Posts: 253 Joined: Tue May 24, 2011 4:55 pm
|
Re: server change
pnm wrote: It seems this happens whenever a few people (3 or more (!)) access the rankings page at the same time. What?! I have sometimes opened 3 different rankings windows at the same time (Europe, World, extra points) before finishing the day's last puzzle so as to F5-refresh them immediately afterwards and have my handle and flag appear at the top of each page, to the right of "The latest solution today was submitted by:". Makes for glorious-looking screenshots – which I am in the habit of taking after reaching a milestone (such as a new position in the all-time rankings or *ahem* my recent 60,000 points). Oh, the vanity
|
|
|
|
|