Unexplained database slowness

Message boards : News : Unexplained database slowness
Message board moderation

To post messages, you must log in.

Previous · 1 · 2 · 3 · 4 · 5

AuthorMessage
JohnDK Crowdfunding Project Donor*Special Project $250 donor
Volunteer tester
Avatar

Send message
Joined: 28 May 00
Posts: 1222
Credit: 451,243,443
RAC: 1,127
Denmark
Message 1930568 - Posted: 17 Apr 2018, 21:06:09 UTC - in response to Message 1930427.  

Thanks for the progress report Eric. Fingers crossed. Everything seems to hitting on all cylinders since the reorg. Good Job!

+1
ID: 1930568 · Report as offensive
Profile Keith Myers Special Project $250 donor
Volunteer tester
Avatar

Send message
Joined: 29 Apr 01
Posts: 13164
Credit: 1,160,866,277
RAC: 1,873
United States
Message 1930570 - Posted: 17 Apr 2018, 21:10:04 UTC

Isn't this a new process we haven't seen before on the servers?

splitter_throttle_sah bruno
Seti@Home classic workunits:20,676 CPU time:74,226 hours

A proud member of the OFA (Old Farts Association)
ID: 1930570 · Report as offensive
Profile Kissagogo27 Special Project $75 donor
Avatar

Send message
Joined: 6 Nov 99
Posts: 716
Credit: 8,032,827
RAC: 62
France
Message 1930579 - Posted: 17 Apr 2018, 22:18:54 UTC

i've just seen it , splitters speed limit ?
ID: 1930579 · Report as offensive
Profile Keith Myers Special Project $250 donor
Volunteer tester
Avatar

Send message
Joined: 29 Apr 01
Posts: 13164
Credit: 1,160,866,277
RAC: 1,873
United States
Message 1930580 - Posted: 17 Apr 2018, 22:33:14 UTC - in response to Message 1930579.  

i've just seen it , splitters speed limit ?

No, I think it is the process that knocks the splitters offline when the RTS buffer hits its max limit trip-point of around 620-640K. I've caught the splitters offline several times when the RTS buffer gets full. When the splitters go offline, it frees up resources for the file deleters and purgers to get caught up. You can see the behavior in the Haveland graphs.
Seti@Home classic workunits:20,676 CPU time:74,226 hours

A proud member of the OFA (Old Farts Association)
ID: 1930580 · Report as offensive
Profile Jimbocous Project Donor
Volunteer tester
Avatar

Send message
Joined: 1 Apr 13
Posts: 1855
Credit: 268,616,081
RAC: 1,349
United States
Message 1930599 - Posted: 18 Apr 2018, 1:13:02 UTC - in response to Message 1930560.  

I wonder if we will ever hit the 145K/hour return rate again as long as there are Arecibo tasks going out. . .

I imagine we will, once the glut of APs goes away.
I think that's the more relevant factor here, rather than Aricebo VLARs.
ID: 1930599 · Report as offensive
kittyman Crowdfunding Project Donor*Special Project $75 donorSpecial Project $250 donor
Volunteer tester
Avatar

Send message
Joined: 9 Jul 00
Posts: 51470
Credit: 1,018,363,574
RAC: 1,004
United States
Message 1930715 - Posted: 18 Apr 2018, 17:18:57 UTC

Great news on the DB reorg, Eric!
And the shortened outages are a refreshing change as well!
I hope things stay flowing if the result return rate goes back up at some point.
But in any case, very nice to see the servers working efficiently.
"Time is simply the mechanism that keeps everything from happening all at once."

ID: 1930715 · Report as offensive
juan BFP Crowdfunding Project Donor*Special Project $75 donorSpecial Project $250 donor
Volunteer tester
Avatar

Send message
Joined: 16 Mar 07
Posts: 9786
Credit: 572,710,851
RAC: 3,799
Panama
Message 1930729 - Posted: 18 Apr 2018, 19:33:10 UTC - in response to Message 1930715.  

Great news on the DB reorg, Eric!
And the shortened outages are a refreshing change as well!
I hope things stay flowing if the result return rate goes back up at some point.
But in any case, very nice to see the servers working efficiently.

+ 1
ID: 1930729 · Report as offensive
Profile Jimbocous Project Donor
Volunteer tester
Avatar

Send message
Joined: 1 Apr 13
Posts: 1855
Credit: 268,616,081
RAC: 1,349
United States
Message 1930788 - Posted: 19 Apr 2018, 2:43:38 UTC - in response to Message 1930729.  

Great news on the DB reorg, Eric!
And the shortened outages are a refreshing change as well!
I hope things stay flowing if the result return rate goes back up at some point.
But in any case, very nice to see the servers working efficiently.

+ 1

+1
ID: 1930788 · Report as offensive
Profile popandbob
Volunteer tester

Send message
Joined: 19 Mar 05
Posts: 551
Credit: 4,673,015
RAC: 0
Canada
Message 1931105 - Posted: 20 Apr 2018, 22:46:57 UTC - in response to Message 1930580.  

i've just seen it , splitters speed limit ?

No, I think it is the process that knocks the splitters offline when the RTS buffer hits its max limit trip-point of around 620-640K. I've caught the splitters offline several times when the RTS buffer gets full. When the splitters go offline, it frees up resources for the file deleters and purgers to get caught up. You can see the behavior in the Haveland graphs.


The Splitters have that function build in. I suspect the function of this new process is to reduce the number of splitters running when under heavy db load to allow for other processes to take priority.


Do you Good Search for Seti@Home? http://www.goodsearch.com/?charityid=888957
Or Good Shop? http://www.goodshop.com/?charityid=888957
ID: 1931105 · Report as offensive
Profile Keith Myers Special Project $250 donor
Volunteer tester
Avatar

Send message
Joined: 29 Apr 01
Posts: 13164
Credit: 1,160,866,277
RAC: 1,873
United States
Message 1931194 - Posted: 21 Apr 2018, 4:42:55 UTC - in response to Message 1931105.  
Last modified: 21 Apr 2018, 4:43:36 UTC

Could be. Next we need to catch that process in the act of being enabled and then go look at the Haveland graphs for synchronicity.
Seti@Home classic workunits:20,676 CPU time:74,226 hours

A proud member of the OFA (Old Farts Association)
ID: 1931194 · Report as offensive
Profile popandbob
Volunteer tester

Send message
Joined: 19 Mar 05
Posts: 551
Credit: 4,673,015
RAC: 0
Canada
Message 1931448 - Posted: 22 Apr 2018, 23:09:35 UTC - in response to Message 1931194.  

Could be. Next we need to catch that process in the act of being enabled and then go look at the Haveland graphs for synchronicity.

Process currently running - only 3 Green Bank splitters running - remaining splitters are not running.


Do you Good Search for Seti@Home? http://www.goodsearch.com/?charityid=888957
Or Good Shop? http://www.goodshop.com/?charityid=888957
ID: 1931448 · Report as offensive
Profile Keith Myers Special Project $250 donor
Volunteer tester
Avatar

Send message
Joined: 29 Apr 01
Posts: 13164
Credit: 1,160,866,277
RAC: 1,873
United States
Message 1931460 - Posted: 23 Apr 2018, 0:11:10 UTC - in response to Message 1931448.  

Caught it once before but could not make any conclusions. It's running now and all MB splitters are running with NO AP splitters. There is a lot of "grass" spikes in the file deleters graphs. More than I am accustomed to seeing. I think we are just wildly guessing the purpose at this point and probably would need Eric to actually explain what the process is and when it gets enabled and disabled to understand it.
Seti@Home classic workunits:20,676 CPU time:74,226 hours

A proud member of the OFA (Old Farts Association)
ID: 1931460 · Report as offensive
Profile James Butler
Volunteer tester

Send message
Joined: 29 Jun 17
Posts: 8
Credit: 2,319,998
RAC: 0
United Kingdom
Message 1931819 - Posted: 25 Apr 2018, 12:30:06 UTC

I am not getting any work today, please can someone look into this, Thankyou
ID: 1931819 · Report as offensive
Profile Keith Myers Special Project $250 donor
Volunteer tester
Avatar

Send message
Joined: 29 Apr 01
Posts: 13164
Credit: 1,160,866,277
RAC: 1,873
United States
Message 1931858 - Posted: 25 Apr 2018, 17:20:38 UTC - in response to Message 1931819.  

Work is flowing fine to everyone else. You are the only one having issues. Post the first 30 lines of the Event Log after first startup of BOINC so we can see if any errors are being logged.
Seti@Home classic workunits:20,676 CPU time:74,226 hours

A proud member of the OFA (Old Farts Association)
ID: 1931858 · Report as offensive
Profile James Butler
Volunteer tester

Send message
Joined: 29 Jun 17
Posts: 8
Credit: 2,319,998
RAC: 0
United Kingdom
Message 1931869 - Posted: 25 Apr 2018, 19:42:38 UTC - in response to Message 1931858.  
Last modified: 25 Apr 2018, 19:42:55 UTC

25/04/2018 15:46:18 | SETI@home Beta Test | Sending scheduler request: To fetch work.
25/04/2018 15:46:18 | SETI@home Beta Test | Requesting new tasks for CPU
25/04/2018 15:46:20 | SETI@home Beta Test | Scheduler request completed: got 0 new tasks
25/04/2018 15:46:20 | SETI@home Beta Test | Project has no tasks available
25/04/2018 15:52:38 | SETI@home Beta Test | Sending scheduler request: To fetch work.
25/04/2018 15:52:38 | SETI@home Beta Test | Requesting new tasks for NVIDIA GPU
25/04/2018 15:52:40 | SETI@home Beta Test | Scheduler request completed: got 0 new tasks
25/04/2018 15:52:40 | SETI@home Beta Test | Project has no tasks available
25/04/2018 17:01:32 | SETI@home Beta Test | Sending scheduler request: To fetch work.
25/04/2018 17:01:32 | SETI@home Beta Test | Requesting new tasks for CPU
25/04/2018 17:01:34 | SETI@home Beta Test | Scheduler request completed: got 0 new tasks
25/04/2018 17:01:34 | SETI@home Beta Test | Project has no tasks available
25/04/2018 17:19:04 | SETI@home Beta Test | Sending scheduler request: To fetch work.
25/04/2018 17:19:04 | SETI@home Beta Test | Requesting new tasks for NVIDIA GPU
25/04/2018 17:19:05 | SETI@home Beta Test | Scheduler request completed: got 0 new tasks
25/04/2018 17:19:05 | SETI@home Beta Test | Project has no tasks available
ID: 1931869 · Report as offensive
Richard Haselgrove Project Donor
Volunteer tester

Send message
Joined: 4 Jul 99
Posts: 14660
Credit: 200,643,578
RAC: 874
United Kingdom
Message 1931870 - Posted: 25 Apr 2018, 19:48:43 UTC - in response to Message 1931869.  

Those are requests for SETI@home BETA work, where there is a front-page news item:

We will be out of work for a while

Check the discussion thread at that website for more recent updates.
ID: 1931870 · Report as offensive
rob smith Crowdfunding Project Donor*Special Project $75 donorSpecial Project $250 donor
Volunteer moderator
Volunteer tester

Send message
Joined: 7 Mar 03
Posts: 22324
Credit: 416,307,556
RAC: 380
United Kingdom
Message 1931871 - Posted: 25 Apr 2018, 19:49:50 UTC

Ah - you are looking at the SETI Beta project, which has a very low availability of tasks. That project is used to test new applications, or to "prove" selected parts of the servers, and should not be replied on to be a continuous source of tasks.
Bob Smith
Member of Seti PIPPS (Pluto is a Planet Protest Society)
Somewhere in the (un)known Universe?
ID: 1931871 · Report as offensive
Previous · 1 · 2 · 3 · 4 · 5

Message boards : News : Unexplained database slowness


 
©2024 University of California
 
SETI@home and Astropulse are funded by grants from the National Science Foundation, NASA, and donations from SETI@home volunteers. AstroPulse is funded in part by the NSF through grant AST-0307956.