mysql> OPTIMIZE TABLE Label; +------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------+----------+----------+----------+ | gpc1.Label | optimize | status | OK | +------------+----------+----------+----------+ 1 row in set (1.51 sec) mysql> OPTIMIZE TABLE addMask; +--------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------+----------+----------+----------+ | gpc1.addMask | optimize | status | OK | +--------------+----------+----------+----------+ 1 row in set (1.27 sec) mysql> OPTIMIZE TABLE addProcessedExp; +----------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------+----------+----------+----------+ | gpc1.addProcessedExp | optimize | status | OK | +----------------------+----------+----------+----------+ 1 row in set (4.13 sec) mysql> OPTIMIZE TABLE addRun; +-------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------+----------+----------+----------+ | gpc1.addRun | optimize | status | OK | +-------------+----------+----------+----------+ 1 row in set (9.14 sec) mysql> OPTIMIZE TABLE calDB; +------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------+----------+----------+----------+ | gpc1.calDB | optimize | status | OK | +------------+----------+----------+----------+ 1 row in set (1.32 sec) mysql> OPTIMIZE TABLE calRun; +-------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------+----------+----------+----------+ | gpc1.calRun | optimize | status | OK | +-------------+----------+----------+----------+ 1 row in set (1.28 sec) mysql> OPTIMIZE TABLE camMask; +--------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------+----------+----------+----------+ | gpc1.camMask | optimize | status | OK | +--------------+----------+----------+----------+ 1 row in set (1.21 sec) mysql> OPTIMIZE TABLE camProcessedExp; +----------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------+----------+----------+----------+ | gpc1.camProcessedExp | optimize | status | OK | +----------------------+----------+----------+----------+ 1 row in set (9.42 sec) mysql> OPTIMIZE TABLE camRun; +-------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------+----------+----------+----------+ | gpc1.camRun | optimize | status | OK | +-------------+----------+----------+----------+ 1 row in set (14.42 sec) mysql> OPTIMIZE TABLE chipBackgroundImfile; +---------------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------+----------+----------+----------+ | gpc1.chipBackgroundImfile | optimize | status | OK | +---------------------------+----------+----------+----------+ 1 row in set (6.09 sec) mysql> OPTIMIZE TABLE chipBackgroundRun; +------------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------+----------+----------+----------+ | gpc1.chipBackgroundRun | optimize | status | OK | +------------------------+----------+----------+----------+ 1 row in set (1.50 sec) mysql> OPTIMIZE TABLE chipImfile; +-----------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------+----------+----------+----------+ | gpc1.chipImfile | optimize | status | OK | +-----------------+----------+----------+----------+ 1 row in set (3 min 24.41 sec) mysql> OPTIMIZE TABLE chipMask; +---------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------+----------+----------+----------+ | gpc1.chipMask | optimize | status | OK | +---------------+----------+----------+----------+ 1 row in set (1.39 sec) mysql> OPTIMIZE TABLE chipProcessedImfile; +--------------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------------+----------+----------+----------+ | gpc1.chipProcessedImfile | optimize | status | OK | +--------------------------+----------+----------+----------+ 1 row in set (18 min 47.04 sec) mysql> OPTIMIZE TABLE chipRun; +--------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------+----------+----------+----------+ | gpc1.chipRun | optimize | status | OK | +--------------+----------+----------+----------+ 1 row in set (12.48 sec) mysql> OPTIMIZE TABLE dbversion; +----------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------+----------+----------+----------+ | gpc1.dbversion | optimize | status | OK | +----------------+----------+----------+----------+ 1 row in set (1.08 sec) mysql> OPTIMIZE TABLE detInputExp; +------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------+----------+----------+----------+ | gpc1.detInputExp | optimize | status | OK | +------------------+----------+----------+----------+ 1 row in set (1.72 sec) mysql> OPTIMIZE TABLE detNormalizedExp; +-----------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------+----------+----------+----------+ | gpc1.detNormalizedExp | optimize | status | OK | +-----------------------+----------+----------+----------+ 1 row in set (1.24 sec) mysql> OPTIMIZE TABLE detNormalizedImfile; +--------------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------------+----------+----------+----------+ | gpc1.detNormalizedImfile | optimize | status | OK | +--------------------------+----------+----------+----------+ 1 row in set (1.52 sec) mysql> OPTIMIZE TABLE detNormalizedStatImfile; +------------------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------+----------+----------+----------+ | gpc1.detNormalizedStatImfile | optimize | status | OK | +------------------------------+----------+----------+----------+ 1 row in set (1.28 sec) mysql> OPTIMIZE TABLE detProcessedExp; +----------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------+----------+----------+----------+ | gpc1.detProcessedExp | optimize | status | OK | +----------------------+----------+----------+----------+ 1 row in set (1.37 sec) mysql> OPTIMIZE TABLE detProcessedImfile; +-------------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------+----------+----------+----------+ | gpc1.detProcessedImfile | optimize | status | OK | +-------------------------+----------+----------+----------+ 1 row in set (14.96 sec) mysql> OPTIMIZE TABLE detRegisteredImfile; +--------------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------------+----------+----------+----------+ | gpc1.detRegisteredImfile | optimize | status | OK | +--------------------------+----------+----------+----------+ 1 row in set (1.42 sec) mysql> OPTIMIZE TABLE detResidExp; +------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------+----------+----------+----------+ | gpc1.detResidExp | optimize | status | OK | +------------------+----------+----------+----------+ 1 row in set (1.58 sec) mysql> OPTIMIZE TABLE detResidImfile; +---------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------+----------+----------+----------+ | gpc1.detResidImfile | optimize | status | OK | +---------------------+----------+----------+----------+ 1 row in set (18.63 sec) mysql> OPTIMIZE TABLE detRun; +-------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------+----------+----------+----------+ | gpc1.detRun | optimize | status | OK | +-------------+----------+----------+----------+ 1 row in set (5.43 sec) mysql> OPTIMIZE TABLE detRunSummary; +--------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------+----------+----------+----------+ | gpc1.detRunSummary | optimize | status | OK | +--------------------+----------+----------+----------+ 1 row in set (1.11 sec) mysql> OPTIMIZE TABLE detStackedImfile; +-----------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------+----------+----------+----------+ | gpc1.detStackedImfile | optimize | status | OK | +-----------------------+----------+----------+----------+ 1 row in set (1.44 sec) mysql> OPTIMIZE TABLE detectionEfficiency; +--------------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------------+----------+----------+----------+ | gpc1.detectionEfficiency | optimize | status | OK | +--------------------------+----------+----------+----------+ 1 row in set (40.75 sec) mysql> OPTIMIZE TABLE diffInputSkyfile; +-----------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------+----------+----------+----------+ | gpc1.diffInputSkyfile | optimize | status | OK | +-----------------------+----------+----------+----------+ 1 row in set (8 min 6.78 sec) mysql> OPTIMIZE TABLE diffPhotRun; +------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------+----------+----------+----------+ | gpc1.diffPhotRun | optimize | status | OK | +------------------+----------+----------+----------+ 1 row in set (1.57 sec) mysql> OPTIMIZE TABLE diffPhotSkyfile; +----------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------+----------+----------+----------+ | gpc1.diffPhotSkyfile | optimize | status | OK | +----------------------+----------+----------+----------+ 1 row in set (10.94 sec) mysql> OPTIMIZE TABLE diffRun; +--------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------+----------+----------+----------+ | gpc1.diffRun | optimize | status | OK | +--------------+----------+----------+----------+ 1 row in set (7.58 sec) mysql> OPTIMIZE TABLE diffSkyfile; +------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------+----------+----------+----------+ | gpc1.diffSkyfile | optimize | status | OK | +------------------+----------+----------+----------+ 1 row in set (7 min 39.92 sec) mysql> OPTIMIZE TABLE diffSummary; +------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------+----------+----------+----------+ | gpc1.diffSummary | optimize | status | OK | +------------------+----------+----------+----------+ 1 row in set (6.02 sec) mysql> OPTIMIZE TABLE distComponent; +--------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------+----------+----------+----------+ | gpc1.distComponent | optimize | status | OK | +--------------------+----------+----------+----------+ 1 row in set (5 min 37.66 sec) mysql> OPTIMIZE TABLE distRun; +--------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------+----------+----------+----------+ | gpc1.distRun | optimize | status | OK | +--------------+----------+----------+----------+ 1 row in set (31.63 sec) mysql> OPTIMIZE TABLE distTarget; +-----------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------+----------+----------+----------+ | gpc1.distTarget | optimize | status | OK | +-----------------+----------+----------+----------+ 1 row in set (1.38 sec) mysql> OPTIMIZE TABLE dqstatsContent; +---------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------+----------+----------+----------+ | gpc1.dqstatsContent | optimize | status | OK | +---------------------+----------+----------+----------+ 1 row in set (16.37 sec) mysql> OPTIMIZE TABLE dqstatsRun; +-----------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------+----------+----------+----------+ | gpc1.dqstatsRun | optimize | status | OK | +-----------------+----------+----------+----------+ 1 row in set (1.45 sec) mysql> OPTIMIZE TABLE fakeMask; +---------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------+----------+----------+----------+ | gpc1.fakeMask | optimize | status | OK | +---------------+----------+----------+----------+ 1 row in set (1.22 sec) mysql> OPTIMIZE TABLE fakeProcessedImfile; +--------------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------------+----------+----------+----------+ | gpc1.fakeProcessedImfile | optimize | status | OK | +--------------------------+----------+----------+----------+ 1 row in set (5 min 42.07 sec) mysql> OPTIMIZE TABLE fakeRun; +--------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------+----------+----------+----------+ | gpc1.fakeRun | optimize | status | OK | +--------------+----------+----------+----------+ 1 row in set (11.32 sec) mysql> OPTIMIZE TABLE flatcorrAddstarLink; +--------------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------------+----------+----------+----------+ | gpc1.flatcorrAddstarLink | optimize | status | OK | +--------------------------+----------+----------+----------+ 1 row in set (1.42 sec) mysql> OPTIMIZE TABLE flatcorrCamLink; +----------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------+----------+----------+----------+ | gpc1.flatcorrCamLink | optimize | status | OK | +----------------------+----------+----------+----------+ 1 row in set (1.42 sec) mysql> OPTIMIZE TABLE flatcorrChipLink; +-----------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------+----------+----------+----------+ | gpc1.flatcorrChipLink | optimize | status | OK | +-----------------------+----------+----------+----------+ 1 row in set (1.45 sec) mysql> OPTIMIZE TABLE flatcorrRun; +------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------+----------+----------+----------+ | gpc1.flatcorrRun | optimize | status | OK | +------------------+----------+----------+----------+ 1 row in set (1.57 sec) mysql> OPTIMIZE TABLE lapExp; +-------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------+----------+----------+----------+ | gpc1.lapExp | optimize | status | OK | +-------------+----------+----------+----------+ 1 row in set (4.32 sec) mysql> OPTIMIZE TABLE lapRun; +-------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------+----------+----------+----------+ | gpc1.lapRun | optimize | status | OK | +-------------+----------+----------+----------+ 1 row in set (1.62 sec) mysql> OPTIMIZE TABLE lapSequence; +------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------+----------+----------+----------+ | gpc1.lapSequence | optimize | status | OK | +------------------+----------+----------+----------+ 1 row in set (1.25 sec) mysql> OPTIMIZE TABLE magicDSFile; +------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------+----------+----------+----------+ | gpc1.magicDSFile | optimize | status | OK | +------------------+----------+----------+----------+ 1 row in set (16 min 27.05 sec) mysql> OPTIMIZE TABLE magicDSRun; +-----------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------+----------+----------+----------+ | gpc1.magicDSRun | optimize | status | OK | +-----------------+----------+----------+----------+ 1 row in set (36.68 sec) mysql> OPTIMIZE TABLE magicDSUpdateRun; +-----------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------+----------+----------+----------+ | gpc1.magicDSUpdateRun | optimize | status | OK | +-----------------------+----------+----------+----------+ 1 row in set (5.33 sec) mysql> OPTIMIZE TABLE magicInputSkyfile; +------------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------+----------+----------+----------+ | gpc1.magicInputSkyfile | optimize | status | OK | +------------------------+----------+----------+----------+ 1 row in set (1 min 43.45 sec) mysql> OPTIMIZE TABLE magicMask; +----------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------+----------+----------+----------+ | gpc1.magicMask | optimize | status | OK | +----------------+----------+----------+----------+ 1 row in set (4.49 sec) mysql> OPTIMIZE TABLE magicNodeResult; +----------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------+----------+----------+----------+ | gpc1.magicNodeResult | optimize | status | OK | +----------------------+----------+----------+----------+ 1 row in set (4 min 50.11 sec) mysql> OPTIMIZE TABLE magicRun; +---------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------+----------+----------+----------+ | gpc1.magicRun | optimize | status | OK | +---------------+----------+----------+----------+ 1 row in set (8.96 sec) mysql> OPTIMIZE TABLE magicTree; +----------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------+----------+----------+----------+ | gpc1.magicTree | optimize | status | OK | +----------------+----------+----------+----------+ 1 row in set (15 min 45.35 sec) mysql> OPTIMIZE TABLE magicUpdateRun; +---------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------+----------+----------+----------+ | gpc1.magicUpdateRun | optimize | status | OK | +---------------------+----------+----------+----------+ 1 row in set (2.84 sec) mysql> OPTIMIZE TABLE minidvodbCopy; +--------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------+----------+----------+----------+ | gpc1.minidvodbCopy | optimize | status | OK | +--------------------+----------+----------+----------+ 1 row in set (1.43 sec) mysql> OPTIMIZE TABLE minidvodbProcessed; +-------------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------+----------+----------+----------+ | gpc1.minidvodbProcessed | optimize | status | OK | +-------------------------+----------+----------+----------+ 1 row in set (1.49 sec) mysql> OPTIMIZE TABLE minidvodbRun; +-------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------+----------+----------+----------+ | gpc1.minidvodbRun | optimize | status | OK | +-------------------+----------+----------+----------+ 1 row in set (1.44 sec) mysql> OPTIMIZE TABLE newExp; +-------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------+----------+----------+----------+ | gpc1.newExp | optimize | status | OK | +-------------+----------+----------+----------+ 1 row in set (14.50 sec) mysql> OPTIMIZE TABLE newImfile; +----------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------+----------+----------+----------+ | gpc1.newImfile | optimize | status | OK | +----------------+----------+----------+----------+ 1 row in set (4 min 29.06 sec) mysql> OPTIMIZE TABLE publishClient; +--------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------+----------+----------+----------+ | gpc1.publishClient | optimize | status | OK | +--------------------+----------+----------+----------+ 1 row in set (1.40 sec) mysql> OPTIMIZE TABLE publishDone; +------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------+----------+----------+----------+ | gpc1.publishDone | optimize | status | OK | +------------------+----------+----------+----------+ 1 row in set (4.08 sec) mysql> OPTIMIZE TABLE publishRun; +-----------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------+----------+----------+----------+ | gpc1.publishRun | optimize | status | OK | +-----------------+----------+----------+----------+ 1 row in set (9.03 sec) mysql> OPTIMIZE TABLE pzDataStore; +------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------+----------+----------+----------+ | gpc1.pzDataStore | optimize | status | OK | +------------------+----------+----------+----------+ 1 row in set (1.33 sec) mysql> OPTIMIZE TABLE pzDownloadExp; +--------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------+----------+----------+----------+ | gpc1.pzDownloadExp | optimize | status | OK | +--------------------+----------+----------+----------+ 1 row in set (6.29 sec) mysql> OPTIMIZE TABLE pzDownloadImfile; +-----------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------+----------+----------+----------+ | gpc1.pzDownloadImfile | optimize | status | OK | +-----------------------+----------+----------+----------+ 1 row in set (7 min 59.24 sec) mysql> OPTIMIZE TABLE rawExp; +-------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------+----------+----------+----------+ | gpc1.rawExp | optimize | status | OK | +-------------+----------+----------+----------+ 1 row in set (16.77 sec) mysql> OPTIMIZE TABLE rawImfile; +----------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------+----------+----------+----------+ | gpc1.rawImfile | optimize | status | OK | +----------------+----------+----------+----------+ 1 row in set (27 min 11.68 sec) mysql> OPTIMIZE TABLE rcDSFileset; +------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------+----------+----------+----------+ | gpc1.rcDSFileset | optimize | status | OK | +------------------+----------+----------+----------+ 1 row in set (18.26 sec) mysql> OPTIMIZE TABLE rcDestination; +--------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------+----------+----------+----------+ | gpc1.rcDestination | optimize | status | OK | +--------------------+----------+----------+----------+ 1 row in set (1.14 sec) mysql> OPTIMIZE TABLE rcInterest; +-----------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------+----------+----------+----------+ | gpc1.rcInterest | optimize | status | OK | +-----------------+----------+----------+----------+ 1 row in set (1.49 sec) mysql> OPTIMIZE TABLE rcRun; +------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------+----------+----------+----------+ | gpc1.rcRun | optimize | status | OK | +------------+----------+----------+----------+ 1 row in set (1.31 sec) mysql> OPTIMIZE TABLE receiveFile; +------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------+----------+----------+----------+ | gpc1.receiveFile | optimize | status | OK | +------------------+----------+----------+----------+ 1 row in set (1.11 sec) mysql> OPTIMIZE TABLE receiveFileset; +---------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------+----------+----------+----------+ | gpc1.receiveFileset | optimize | status | OK | +---------------------+----------+----------+----------+ 1 row in set (1.10 sec) mysql> OPTIMIZE TABLE receiveResult; +--------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------+----------+----------+----------+ | gpc1.receiveResult | optimize | status | OK | +--------------------+----------+----------+----------+ 1 row in set (1.09 sec) mysql> OPTIMIZE TABLE receiveSource; +--------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------+----------+----------+----------+ | gpc1.receiveSource | optimize | status | OK | +--------------------+----------+----------+----------+ 1 row in set (1.12 sec) mysql> OPTIMIZE TABLE stackAssociation; +-----------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------+----------+----------+----------+ | gpc1.stackAssociation | optimize | status | OK | +-----------------------+----------+----------+----------+ 1 row in set (1.35 sec) mysql> OPTIMIZE TABLE stackAssociationMap; +--------------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------------+----------+----------+----------+ | gpc1.stackAssociationMap | optimize | status | OK | +--------------------------+----------+----------+----------+ 1 row in set (4.10 sec) mysql> OPTIMIZE TABLE stackInputSkyfile; +------------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------+----------+----------+----------+ | gpc1.stackInputSkyfile | optimize | status | OK | +------------------------+----------+----------+----------+ 1 row in set (44.45 sec) mysql> OPTIMIZE TABLE stackRun; +---------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------+----------+----------+----------+ | gpc1.stackRun | optimize | status | OK | +---------------+----------+----------+----------+ 1 row in set (14.76 sec) mysql> OPTIMIZE TABLE stackSumSkyfile; +----------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------+----------+----------+----------+ | gpc1.stackSumSkyfile | optimize | status | OK | +----------------------+----------+----------+----------+ 1 row in set (19.43 sec) mysql> OPTIMIZE TABLE stackSummary; +-------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------+----------+----------+----------+ | gpc1.stackSummary | optimize | status | OK | +-------------------+----------+----------+----------+ 1 row in set (1.36 sec) mysql> OPTIMIZE TABLE staticskyInput; +---------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------+----------+----------+----------+ | gpc1.staticskyInput | optimize | status | OK | +---------------------+----------+----------+----------+ 1 row in set (1.57 sec) mysql> OPTIMIZE TABLE staticskyResult; +----------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------+----------+----------+----------+ | gpc1.staticskyResult | optimize | status | OK | +----------------------+----------+----------+----------+ 1 row in set (1.88 sec) mysql> OPTIMIZE TABLE staticskyRun; +-------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------+----------+----------+----------+ | gpc1.staticskyRun | optimize | status | OK | +-------------------+----------+----------+----------+ 1 row in set (1.99 sec) mysql> OPTIMIZE TABLE summitExp; +----------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------+----------+----------+----------+ | gpc1.summitExp | optimize | status | OK | +----------------+----------+----------+----------+ 1 row in set (8.23 sec) mysql> OPTIMIZE TABLE summitImfile; +-------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------+----------+----------+----------+ | gpc1.summitImfile | optimize | status | OK | +-------------------+----------+----------+----------+ 1 row in set (8 min 15.60 sec) mysql> OPTIMIZE TABLE warpBackgroundRun; +------------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------+----------+----------+----------+ | gpc1.warpBackgroundRun | optimize | status | OK | +------------------------+----------+----------+----------+ 1 row in set (1.68 sec) mysql> OPTIMIZE TABLE warpBackgroundSkyfile; +----------------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------+----------+----------+----------+ | gpc1.warpBackgroundSkyfile | optimize | status | OK | +----------------------------+----------+----------+----------+ 1 row in set (7.34 sec) mysql> OPTIMIZE TABLE warpImfile; +-----------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------+----------+----------+----------+ | gpc1.warpImfile | optimize | status | OK | +-----------------+----------+----------+----------+ 1 row in set (6 min 9.49 sec) mysql> OPTIMIZE TABLE warpMask; +---------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------+----------+----------+----------+ | gpc1.warpMask | optimize | status | OK | +---------------+----------+----------+----------+ 1 row in set (1.41 sec) mysql> OPTIMIZE TABLE warpRun; +--------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------+----------+----------+----------+ | gpc1.warpRun | optimize | status | OK | +--------------+----------+----------+----------+ 1 row in set (13.55 sec) OPTIMIZE TABLE warpSkyCellMap; +---------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------+----------+----------+----------+ | gpc1.warpSkyCellMap | optimize | status | OK | +---------------------+----------+----------+----------+ mysql> OPTIMIZE TABLE warpSkyfile; +------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------+----------+----------+----------+ | gpc1.warpSkyfile | optimize | status | OK | +------------------+----------+----------+----------+ 1 row in set (20 min 42.05 sec) mysql> OPTIMIZE TABLE warpSummary; +------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------+----------+----------+----------+ | gpc1.warpSummary | optimize | status | OK | +------------------+----------+----------+----------+ 1 row in set (12.29 sec)