I'm detailing here the optimization performed on the Nebulous and gpc1 databases in march 2011.

Nebulous Optimization

• Run as ipp on ippdb00
• Each table was optimized one after the other See attached log file: -> log.nebulous.optimization
• Size variation (unfortunately I didn't record all the tables):

Table name	#elements in table	Size after opt.(bytes)	Size before opt.(bytes)
cabinet	8
deleted	510597
directory	5264597
instance	439024114	156091023360	204308742144	-24%
lock_record	0
log	0
mountedvol	49
storage_object	390559412	165691785216	204665257984	-20%
storage_object_attr	390559412
storage_object_xattr	53272583
volume	52

GPC1 Optimization

• Run as ipp on ippdb01
• Each table was optimized one after the other See attached log file: -> log.gpc1.optimization
• Size variation:

Total	110201241600	79408070656	-27.9%
Filename	Before	After	Variation	Look at that!
Label.ibd	131072	131072
addMask.ibd	98304	98304
addProcessedExp.ibd	26214400	26214400
addRun.ibd	58720256	54525952	-7.1%
calDB.ibd	114688	114688
calRun.ibd	131072	131072
camMask.ibd	98304	98304
camProcessedExp.ibd	100663296	88080384	-12.5%	||
camRun.ibd	117440512	109051904	-7.1%
chipBackgroundImfile.ibd	54525952	37748736	-30.8%	!||
chipBackgroundRun.ibd	8388608	819200	-90.2%	!!||
chipImfile.ibd	843055104	843055104
chipMask.ibd	98304	98304
chipProcessedImfile.ibd	8573157376	7004487680	-18.3%	||
chipRun.ibd	134217728	113246208	-15.6%	||
dbversion.ibd	98304	98304
detInputExp.ibd	12582912	11534336	-8.3%
detNormalizedExp.ibd	114688	114688
detNormalizedImfile.ibd	12582912	10485760	-16.7%	||
detNormalizedStatImfile.ibd	835584	655360	-21.6%	||
detProcessedExp.ibd	10485760	10485760
detProcessedImfile.ibd	373293056	264241152	-29.2%	!||
detRegisteredImfile.ibd	9437184	9437184
detResidExp.ibd	11534336	10485760	-9.1%
detResidImfile.ibd	381681664	255852544	-33.0%	!||
detRun.ibd	344064	344064
detRunSummary.ibd	147456	114688	-22.2%	||
detStackedImfile.ibd	11534336	10485760	-9.1%
detectionEfficiency.ibd	780140544	318767104	-59.1%	!!||
diffInputSkyfile.ibd	4102029312	4097835008	-0.1%
diffPhotRun.ibd	10485760	10485760
diffPhotSkyfile.ibd	226492416	121634816	-46.3%	!||
diffRun.ibd	67108864	58720256	-12.5%	||
diffSkyfile.ibd	4223664128	3070230528	-27.3%	!||
diffSummary.ibd	41943040	30408704	-27.5%	!||
distComponent.ibd	5402263552	2906652672	-46.2%	!||
distRun.ibd	314572800	247463936	-21.3%	||
distTarget.ibd	655360	655360
dqstatsContent.ibd	130023424	130023424
dqstatsRun.ibd	475136	491520
fakeMask.ibd	98304	98304
fakeProcessedImfile.ibd	4194304000	2323644416	-44.6%	!||
fakeRun.ibd	92274688	88080384	-4.5%
flatcorrAddstarLink.ibd	311296	311296
flatcorrCamLink.ibd	557056	557056
flatcorrChipLink.ibd	360448	360448
flatcorrRun.ibd	114688	114688
magicDSFile.ibd	8191475712	5607784448	-31.5%	!||
magicDSRun.ibd	255852544	239075328	-6.6%
magicDSUpdateRun.ibd	54525952	37748736	-30.8%	!||
magicInputSkyfile.ibd	427819008	427819008
magicMask.ibd	46137344	37748736	-18.2%	||
magicNodeResult.ibd	3984588800	2000683008	-49.8%	!||
magicRun.ibd	79691776	71303168	-10.5%	||
magicTree.ibd	5226102784	5226102784
magicUpdateRun.ibd	18874368	17825792	-5.6%
minidvodbCopy.ibd	131072	114688	-12.5%	||
minidvodbProcessed.ibd	180224	163840	-9.1%
minidvodbRun.ibd	196608	180224	-8.3%
newExp.ibd	100663296	96468992	-4.2%
newImfile.ibd	3632267264	2722103296	-25.1%	!||
publishClient.ibd	114688	114688
publishDone.ibd	31457280	25165824	-20.0%	||
publishRun.ibd	58720256	50331648	-14.3%	||
pzDataStore.ibd	98304	98304
pzDownloadExp.ibd	41943040	37748736	-10.0%
pzDownloadImfile.ibd	5951717376	3435134976	-42.3%	!||
rawExp.ibd	184549376	155189248	-15.9%	||
rawImfile.ibd	16655581184	14298382336	-14.2%	||
rcDSFileset.ibd	121634816	100663296	-17.2%	||
rcDestination.ibd	114688	114688
rcInterest.ibd	573440	589824
rcRun.ibd	131072	131072
receiveFile.ibd	131072	131072
receiveFileset.ibd	131072	131072
receiveResult.ibd	114688	114688
receiveSource.ibd	147456	147456
stackAssociation.ibd	524288	524288
stackAssociationMap.ibd	15728640	15728640
stackInputSkyfile.ibd	230686720	226492416	-1.8%
stackRun.ibd	125829120	109051904	-13.3%	||
stackSumSkyfile.ibd	134217728	109051904	-18.8%	||
stackSummary.ibd	475136	376832	-20.7%	||
staticskyInput.ibd	163840	163840
staticskyResult.ibd	196608	180224	-8.3%
staticskyRun.ibd	212992	196608	-7.7%
summitExp.ibd	67108864	58720256	-12.5%	||
summitImfile.ibd	5616173056	4630511616	-17.6%	||
warpBackgroundRun.ibd	1015808	917504	-9.7%
warpBackgroundSkyfile.ibd	75497472	54525952	-27.8%	!||
warpImfile.ibd	2646605824	2172649472	-17.9%	||
warpMask.ibd	98304	98304
warpRun.ibd	113246208	96468992	-14.8%	||
warpSkyCellMap.ibd	13170114560	5901385728	-55.2%	!!||
warpSkyfile.ibd	12532580352	9118416896	-27.2%	!||
warpSummary.ibd	75497472	54525952	-27.8%	!||