Gathering of Tweakers

quote: http://setiathome.berkeley.edu/tech_news.php

22 Jul 2008 21:16:02 UTC
Yesterday afternoon we installed in a new scheduler which included some updates necessary for the upcoming Astropulse rollout. However, our network performance took an immediate hit. After about 10 minutes trying to figure out what was causing this Jeff and I realized our scheduler switch perfectly coincided with several expensive credit-analysis queries Eric was running, also in regards to the Astropulse rollout. So it wasn't the scheduler - just the database getting overloaded. That got cleared up quickly.

Last night I noticed people complaining about Mac computers being denied work. This is still an issue, probably with the new scheduler implementation, and we'll address it shortly.

We had the regular weekly outage today during which I tackled some extra things. First off, due to continuing mysql database performance issues we completely dropped the credited_job table (before we just dropped the indexes). Reminder: this is the table that connects user ids in the mysql database to result ids in the science database, so we know who did what. This is also the only table in the mysql database that grows without bounds, and therefore has been the cause of much headaches as of late. Don't worry - we have all this data archives in three formats in three different locations, and will continue to collect this data in flat file format. I also checked the integrity of the database filesystem now that it was cleaner. No problems there. I started up the projects and mysql is currently handling well over 2000 queries/sec without breaking a sweat.

- Matt

Daily Top 30
Flushers: 96 / 856 (11,2 %)
pos		daily	member	total
1.	(2)	33.165	[DPC]TeamGrazzie	8.403.327	(3)
2.	(1)	20.913	[DPC] Switch	4.404.256	(6)
3.	(1)	18.091	hansR	10.580.258	(1)
4.	()	15.434	Sp@ceNv@der	7.729.689	(4)
5.	()	7.394	Searchy! Internet Services V.O.F.	5.260.320	(5)
6.	()	6.983	o25o & Dharkon	3.417.672	(7)
7.	(2)	5.380	MAX3400	1.193.946	(13)
8.	()	4.965	AmeComputers	536.257	(26)
9.	(2)	4.168	ray	409.348	(35)
10.	(2)	3.431	Jox444	356.236	(44)
11.	(5)	3.379	[DPC]Trancemaus	1.751.519	(9)
12.	(2)	3.262	F@stmem	921.452	(19)
13.	()	2.684	dr bommel	95.399	(104)
14.	(7)	2.368	Ensign Wildfire	1.550.794	(10)
15.	(13)	2.190	[DPC]Team Zuid-Holland	1.340.019	(11)
16.	(1)	1.943	Override	532.962	(27)
17.	(7)	1.826	Mr Beamer	899.520	(20)
18.	(2)	1.480	Dellape	63.239	(124)
19.	(4)	1.167	Asgoroth	110.135	(91)
20.	(1)	982	Tijntje	1.001.565	(18)
21.	(3)	978	Berkie	865.077	(21)
22.	()	880	sebastiaan	451.506	(32)
23.	(2)	851	Edwin van der Geest	237.846	(60)
24.	(3)	847	Administrator	299.172	(52)
25.	(7)	825	ZeroNRG	20.433	(231)
26.	(7)	790	-0-	92.572	(106)
27.	(3)	732	Dr.Drax	407.338	(36)
28.	(7)	691	Robin Ovaere	122.081	(85)
29.	(3)	626	holy-shit	371.836	(41)
30.	(50)	531	Joey van den Berge	112.516	(89)
	More...

Overall Top 30
pos		total	member	daily
1.	()	10.580.258	hansR	18.091	(3)
2.	()	9.117.462	REISinformatiegroep	0	(-)
3.	()	8.403.327	[DPC]TeamGrazzie	33.165	(1)
4.	()	7.729.689	Sp@ceNv@der	15.434	(4)
5.	()	5.260.320	Searchy! Internet Services V.O.F.	7.394	(5)
6.	()	4.404.256	[DPC] Switch	20.913	(2)
7.	()	3.417.672	o25o & Dharkon	6.983	(6)
8.	()	2.431.385	[DPC]Spinpoint	244	(45)
9.	()	1.751.519	[DPC]Trancemaus	3.379	(11)
10.	()	1.550.794	Ensign Wildfire	2.368	(14)
11.	()	1.340.019	[DPC]Team Zuid-Holland	2.190	(15)
12.	()	1.275.466	Jan Zandvliet & x-RaY99	173	(52)
13.	()	1.193.946	MAX3400	5.380	(7)
14.	()	1.077.001	Speedy67 & Friends	175	(51)
15.	()	1.074.636	visvogel	173	(53)
16.	()	1.049.597	[DPC]SjoQing	0	(-)
17.	()	1.043.115	[DPC] Anticimex & Lock Metaaldetectie	0	(-)
18.	()	1.001.565	Tijntje	982	(20)
19.	()	921.452	F@stmem	3.262	(12)
20.	()	899.520	Mr Beamer	1.826	(17)
21.	()	865.077	Berkie	978	(21)
22.	()	673.789	Psyed	0	(-)
23.	()	642.151	Rydo	51	(86)
24.	()	634.180	Dadoke	326	(36)
25.	()	626.692	MaNDaRK	0	(-)
26.	()	536.257	AmeComputers	4.965	(8)
27.	()	532.962	Override	1.943	(16)
28.	()	494.866	Zwahillius	0	(-)
29.	()	473.016	Team_Elteor_Borislavj	117	(62)
30.	()	472.183	dpijl10	0	(-)
	More...

Teams Daily Top 15
pos		daily	team	total
1.	()	1.318.398	SETI.USA	734.153.945	(1)
22.	(1)	220.438	BOINC@AUSTRALIA	82.807.924	(31)
23.	(2)	207.243	Canada	97.423.043	(22)
24.	(2)	198.186	BOINC@Poland	65.175.654	(38)
25.	(1)	195.512	PC Perspective Killer Frogs	86.833.890	(29)
26.	()	191.853	UK BOINC Team	88.170.384	(27)
27.	()	189.829	Team Art Bell	156.352.393	(11)
28.	(1)	187.219	Elite Games	57.918.936	(41)
29.	(1)	186.312	Dutch Power Cows	88.560.873	(26)
30.	()	177.118	BOINC SETI@home RUSSIA	78.758.700	(32)
31.	(1)	158.077	Planet 3DNow!	63.278.788	(39)
32.	(1)	150.150	Team NIPPON	76.240.127	(33)
33.	(1)	147.761	Phoenix Rising	105.691.549	(21)
34.	(3)	142.404	AUSTRIA - NATIONAL - TEAM	86.838.584	(28)
35.	(1)	135.134	Ars Technica	114.000.676	(20)
36.	(1)	127.854	BOINC.Italy	116.356.944	(19)
	More...

Teams Overall Top 15
pos		total	team	daily
1.	()	734.153.945	SETI.USA	1.318.398	(1)
19.	()	116.356.944	BOINC.Italy	127.854	(36)
20.	()	114.000.676	Ars Technica	135.134	(35)
21.	()	105.691.549	Phoenix Rising	147.761	(33)
22.	(1)	97.423.043	Canada	207.243	(23)
23.	(1)	97.377.181	Universe Examiners	105.539	(43)
24.	()	95.667.921	US NAVY	305.278	(11)
25.	()	88.825.993	U.S.Air Force	266.397	(16)
26.	()	88.560.873	Dutch Power Cows	186.312	(29)
27.	()	88.170.384	UK BOINC Team	191.853	(26)
28.	()	86.838.584	AUSTRIA - NATIONAL - TEAM	142.404	(34)
29.	()	86.833.890	PC Perspective Killer Frogs	195.512	(25)
30.	()	86.820.039	Amateur Radio Operators	251.434	(20)
31.	()	82.807.924	BOINC@AUSTRALIA	220.438	(22)
32.	()	78.758.700	BOINC SETI@home RUSSIA	177.118	(30)
33.	()	76.240.127	Team NIPPON	150.150	(32)
	More...

Megaflush Top 5
pos	Team	Flush	Date
1.	[DPC] Switch	74.525	25-04-2008
2.	[DPC]TeamGrazzie	46.517	21-06-2008
3.	Sp@ceNv@der	46.081	12-07-2008
4.	hansR	42.659	12-07-2008
5.	Searchy! Internet Services V.O.F.	32.326	25-04-2008
More...