Message boards :
News :
Database slowness
Message board moderation
Author | Message |
---|---|
Eric Korpela ![]() Send message Joined: 3 Apr 99 Posts: 1330 Credit: 33,446,954 RAC: 59,191 ![]() ![]() |
We're having some as yet unexplained slowness with the our BOINC database. There don't seem to be any hardware issues. Temperatures are running normal and all the drives seem good. Yet for some reason the query that fills the "ready to send" queue is running about 10 times slower than it normally does. Until I get it fixed, it means that on average we're sending out 3 workunits a second rather than 30+. I'll let you know when I've got it figured out. ![]() ![]() |
Grant (SSSF) Send message Joined: 19 Aug 99 Posts: 10765 Credit: 150,020,306 RAC: 103,144 ![]() ![]() |
Thanks for the update. Greatly appreciated. Grant Darwin NT |
kittyman ![]() ![]() Send message Joined: 9 Jul 00 Posts: 50198 Credit: 966,302,642 RAC: 178,735 ![]() ![]() |
Thank you, Eric. I know you put a lot of effort into it when things are not running as they should be. Very much appreciated! "The secret o' life is enjoying the passage of time." 1977, James Taylor "With cats." 2018, kittyman ![]() |
Rumsfeld Send message Joined: 2 Mar 00 Posts: 4 Credit: 5,114,097 RAC: 2,344 ![]() ![]() |
Thank you for the update! |
![]() ![]() ![]() ![]() Send message Joined: 19 Nov 00 Posts: 41217 Credit: 41,922,644 RAC: 9,586 ![]() ![]() |
Well done for keeping us up to date with events, and thank you to find time from your busy schedule. Gosh almost back to the heady days of Matts weekly report :-)) |
![]() ![]() Send message Joined: 18 Aug 99 Posts: 1392 Credit: 94,551,163 RAC: 53,218 ![]() ![]() |
Eric - Thanks for the update. I don't know if this makes any difference in your troubleshooting, but I haven't gotten an CPU tasks for several hours, in fact I'm down to 17 from 100. ![]() I don't buy computers, I build them!! |
![]() ![]() ![]() ![]() Send message Joined: 1 Dec 99 Posts: 2657 Credit: 369,769,486 RAC: 896,646 ![]() ![]() |
Cliff that is likely because the server normally fills the fastest component first. That would be your 750Ti's. I have a similar thing happening here, since there are not many Arecibo vlars about, the CPU doesn't get much. |
![]() ![]() Send message Joined: 7 Oct 17 Posts: 1 Credit: 559,795 RAC: 0 ![]() |
Thanks I was kinda confused |
Jim Green Send message Joined: 9 Feb 01 Posts: 1 Credit: 1,804,518 RAC: 46 ![]() |
Have you checked with your ISP? |
MODOC Send message Joined: 20 Oct 17 Posts: 1 Credit: 5,131 RAC: 0 ![]() |
since about 2 days it started it has become very slow my pc has just turned itself off and shut down and independently removed 2 annoying suspicious entries |
![]() ![]() Send message Joined: 20 Dec 05 Posts: 3116 Credit: 54,065,226 RAC: 15,897 ![]() ![]() |
Have you checked with your ISP? Eric is talking about the response of the BOINC database, which is all in one location, on one computer... even if SETI was having a slow ISP responce, (they aren't!) the symptoms displayed would be different. I've set all my fast machines to what I call "pester" mode... (every time the machine updates, [which it does every time it finishes and uploads a WU...] it requests new tasks...) . ![]() Hello, from Albany, California!... |
Eric Korpela ![]() Send message Joined: 3 Apr 99 Posts: 1330 Credit: 33,446,954 RAC: 59,191 ![]() ![]() |
I bumped the memory allocated to the database by 20% and transferred some common queries to the replica. Things things seem to have stabilized. ![]() ![]() |
Eric Korpela ![]() Send message Joined: 3 Apr 99 Posts: 1330 Credit: 33,446,954 RAC: 59,191 ![]() ![]() |
since about 2 days it started it has become very slow I was having similar symptoms, a few days ago. I fixed it by taking a damp Q-tip to the vanes of my CPU heat sink. CPU temperature dropped by 30C. One of these days someone will invent a self cleaning heat sink. (Reversible fan maybe?) ![]() ![]() |
![]() ![]() ![]() ![]() Send message Joined: 25 Dec 00 Posts: 24367 Credit: 43,781,545 RAC: 30,885 ![]() ![]() |
since about 2 days it started it has become very slow If only ... some bright engineer type decided to make the vanes come out like spokes on a wheel. Easy to clean the ends, impossible to get into the center. Also guess where the dust collects. In the tight spaces. Thankfully some other engineer invented canned air. I wonder how rocket scientists deal with this issue in zero g? ![]() ![]() |
![]() ![]() ![]() ![]() Send message Joined: 19 Nov 00 Posts: 41217 Credit: 41,922,644 RAC: 9,586 ![]() ![]() |
CPU temperature dropped by 30C.Gosh that is an amazing drop. No de-fluffing just a damp Q-tip? |
syffy c Send message Joined: 26 Jan 17 Posts: 94 Credit: 126,190 RAC: 0 ![]() |
Nice tip! :-) Thanks for all the hard work. |
![]() ![]() ![]() ![]() Send message Joined: 1 Dec 99 Posts: 2657 Credit: 369,769,486 RAC: 896,646 ![]() ![]() |
Hi there Eric, keep up the great work maintaining the system, especially on these long weekends. I just wonder if the file deletion slowness might point you in a direction of problem area to look at. I have noticed over the past 5-7 weeks the deletion process gets backlogged as well as can be seen in the haveland graphs affecting both AP and MB task clean up. Who knows, it could be something like an ailing network adaptor on a computer ... ![]() |
![]() ![]() Send message Joined: 20 Dec 05 Posts: 3116 Credit: 54,065,226 RAC: 15,897 ![]() ![]() |
since about 2 days it started it has become very slow Big can of pressurized air pointed in the reverse direction to the fan(s) on your radiator/heat sink (depending on whether you have liquid or air cooling...) always works for me... (every 6 months or so, my computers are in a dusty environment!) Of course, then my dust allergy kicks in... :-( . ![]() Hello, from Albany, California!... |
Yavanius ![]() Send message Joined: 8 Jul 99 Posts: 45 Credit: 242,081 RAC: 0 ![]() |
Vacuum hose to suck up the dust. |
bluestar Send message Joined: 5 Sep 12 Posts: 2898 Credit: 1,969,058 RAC: 0 |
Sometimes such a thing are called gremlins. Sorry, but I think I catch the point here. A bit of slowness being noticeable in the web-page, but now it is gone. |
©2019 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.