- Feb 5, 2001
- 2,994
- 19
- 81
We never did claim to have totally solved the "slow feeder query" problem plaguing us a month ago (and well before that). The adjustments we made to the database and the way we set up our queries have helped, but last night and well into today mysql fell back into its old habits again. We have a policy to not care about this anymore as we don't have the time, the problem is relatively transient, and we'll be upgrading mysql versions soon enough. My gut tells me this is caused by some kind of mysql housecleaning that gets tickled every so often depending on load.
Aside from that we went ahead with our changes to the science database and employed new solaris versions of the assimilators and splitters. Later (i.e. tomorrow or beyond) we'll install linux versions of the assimilators and validators (thus getting the last remaining backend bits off of kryten). One thing at a time, folks.
The validator queue was growing again. Seems like kryten perhaps needed a reboot to clear its network pipes so I did that. Now the queue is draining. Damn pesky mounts! Soon the validators will run on bruno, i.e. the same machine with the result files. That'll be much better.
- Matt
#____Total Work Done____Todays WD_____AWD________overtake_______Team-name
01______226.736.938______750.074______925.208______impossible______SETI.USA
02______215.386.174______386.236______396.347______impossible______SETI.Germany
03_______94.787.214______110.433_______84.135______impossible______BroadbandReports.com Team Starfire
04_______81.954.420______247.392______224.352______impossible______L'Alliance Francophone
05_______76.842.031______108.548______101.188______impossible______Czech National Team
06_______75.940.080______139.468______150.517______impossible______BOINC Synergy
07_______65.404.354______108.633______110.845______impossible______SETI@Netherlands
08_______43.782.542_______10.319________7.155______impossible______OcUK - Overclockers UK
09_______39.628.262______163.551______148.592______impossible______The Knights Who Say Ni!
10_______33.223.818______-11.231______-17.656______1.882 days______BOINC.Italy
11_______29.007.952_______63.748_______52.425______impossible______Overclockers.com
12_______26.180.036_______82.344_______90.527______impossible______Team Art Bell
13_______23.901.762_______62.883_______61.324______impossible______Team 2ch
14_______19.782.039_______49.411_______50.754______impossible______The Planetary Society
15_______15.050.459_______17.615_______29.224______impossible______Ars Technica
16________9.609.334______105.901______103.798______impossible______Team MacNN
17________2.273.935_______11.372_______-6.484________351 days______Universe Examiners
18_______47.236.232_______70.736_______76.913______notanoption_____TeAm AnandTech
19_______-2.535.662_______22.656________7.755________327 days______Phoenix Rising
20_______-6.832.798_______51.479_______42.131________162 days______SETI@Taiwan
21_______-9.515.045______-35.457______-42.343______impossible______Planet 3DNow!
22_______-9.790.486_______11.196_______-8.988______impossible______Amateur Radio Operators
23_______-9.811.289_______-9.198_______-6.153______impossible______Hewlett-Packard
24______-10.376.050______-16.921______-23.785______impossible______PC Perspective Killer Frogs
25______-11.507.604______-25.261______-32.758______impossible______2CPU.com
26______-11.658.146_______-8.831_______-5.819______impossible______Canada
27______-13.058.265_______19.997_______13.305________981 days______SETI@China
28______-14.945.116________1.503________6.680______2.237 days______Team MacAddict
29______-15.110.313_______42.610_______22.248________679 days______Dutch Power Cows
30______-15.195.461_______88.680_______80.050________190 days______Team Starfire World BOINC
31______-15.553.331_______-9.068______-13.371______impossible______Team NIPPON
32______-16.797.967______-33.074______-38.695______impossible______Portugal@Home
33______-16.990.662______-24.914______-35.623______impossible______BOINC@Denmark
34______-17.027.415______-52.148______-57.388______impossible______Picard
35______-17.106.327______-16.374______-18.318______impossible______BOINC SETI@home RUSSIA
36______-18.688.350______-46.504______-52.006______impossible______LittleWhiteDog
37______-18.905.160________1.098_______-5.566______impossible______Hungary
38______-21.876.478_______24.234_______13.297______1.645 days______UK BOINC Team
39______-22.227.672______-36.960______-43.901______impossible______Team EDGE
40______-22.434.947______-23.670______-27.560______impossible______SETI@klamm.de
41______-23.294.464______-21.883______-26.913______impossible______HispaSeti & BOINC
42______-23.322.433______-11.840______-10.473______impossible______U.S.Air Force
43______-23.540.222_______13.932________9.615______2.448 days______US NAVY
44______-23.699.536______-26.383______-30.070______impossible______BOINC@AUSTRALIA
45______-24.334.942________9.452_______-2.726______impossible______SETI.hr
46______-24.395.677______-30.061______-32.431______impossible______SETI Sverige [Sweden]
47______-26.234.278______-23.528______-28.812______impossible______BOINC UK
48______-26.295.542______-30.730______-43.427______impossible______The Final Front Ear
49______-26.901.669______-40.887______-42.528______impossible______SETI@Home Poland
50______-27.000.956______-46.947______-52.071______impossible______World Wide S.E.T.I.
Appart for Anandtech's stats, it shows how much more/less than Anandtech.
Also shows based on Average Work Done how many days for Anandtech to overtake the team, or be overtaken by a team behind
