IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

PS1_IPP_CzarLog_20110912: gpc1_optimization_20110916

File gpc1_optimization_20110916, 32.8 KB (added by Serge CHASTEL, 15 years ago)
Line 
1mysql> OPTIMIZE TABLE Label;
2+------------+----------+----------+----------+
3| Table | Op | Msg_type | Msg_text |
4+------------+----------+----------+----------+
5| gpc1.Label | optimize | status | OK |
6+------------+----------+----------+----------+
71 row in set (1.51 sec)
8
9mysql> OPTIMIZE TABLE addMask;
10+--------------+----------+----------+----------+
11| Table | Op | Msg_type | Msg_text |
12+--------------+----------+----------+----------+
13| gpc1.addMask | optimize | status | OK |
14+--------------+----------+----------+----------+
151 row in set (1.27 sec)
16
17mysql> OPTIMIZE TABLE addProcessedExp;
18+----------------------+----------+----------+----------+
19| Table | Op | Msg_type | Msg_text |
20+----------------------+----------+----------+----------+
21| gpc1.addProcessedExp | optimize | status | OK |
22+----------------------+----------+----------+----------+
231 row in set (4.13 sec)
24
25mysql> OPTIMIZE TABLE addRun;
26+-------------+----------+----------+----------+
27| Table | Op | Msg_type | Msg_text |
28+-------------+----------+----------+----------+
29| gpc1.addRun | optimize | status | OK |
30+-------------+----------+----------+----------+
311 row in set (9.14 sec)
32
33mysql> OPTIMIZE TABLE calDB;
34+------------+----------+----------+----------+
35| Table | Op | Msg_type | Msg_text |
36+------------+----------+----------+----------+
37| gpc1.calDB | optimize | status | OK |
38+------------+----------+----------+----------+
391 row in set (1.32 sec)
40
41mysql> OPTIMIZE TABLE calRun;
42+-------------+----------+----------+----------+
43| Table | Op | Msg_type | Msg_text |
44+-------------+----------+----------+----------+
45| gpc1.calRun | optimize | status | OK |
46+-------------+----------+----------+----------+
471 row in set (1.28 sec)
48
49mysql> OPTIMIZE TABLE camMask;
50+--------------+----------+----------+----------+
51| Table | Op | Msg_type | Msg_text |
52+--------------+----------+----------+----------+
53| gpc1.camMask | optimize | status | OK |
54+--------------+----------+----------+----------+
551 row in set (1.21 sec)
56
57mysql> OPTIMIZE TABLE camProcessedExp;
58+----------------------+----------+----------+----------+
59| Table | Op | Msg_type | Msg_text |
60+----------------------+----------+----------+----------+
61| gpc1.camProcessedExp | optimize | status | OK |
62+----------------------+----------+----------+----------+
631 row in set (9.42 sec)
64
65mysql> OPTIMIZE TABLE camRun;
66+-------------+----------+----------+----------+
67| Table | Op | Msg_type | Msg_text |
68+-------------+----------+----------+----------+
69| gpc1.camRun | optimize | status | OK |
70+-------------+----------+----------+----------+
711 row in set (14.42 sec)
72
73mysql> OPTIMIZE TABLE chipBackgroundImfile;
74+---------------------------+----------+----------+----------+
75| Table | Op | Msg_type | Msg_text |
76+---------------------------+----------+----------+----------+
77| gpc1.chipBackgroundImfile | optimize | status | OK |
78+---------------------------+----------+----------+----------+
791 row in set (6.09 sec)
80
81mysql> OPTIMIZE TABLE chipBackgroundRun;
82+------------------------+----------+----------+----------+
83| Table | Op | Msg_type | Msg_text |
84+------------------------+----------+----------+----------+
85| gpc1.chipBackgroundRun | optimize | status | OK |
86+------------------------+----------+----------+----------+
871 row in set (1.50 sec)
88
89mysql> OPTIMIZE TABLE chipImfile;
90+-----------------+----------+----------+----------+
91| Table | Op | Msg_type | Msg_text |
92+-----------------+----------+----------+----------+
93| gpc1.chipImfile | optimize | status | OK |
94+-----------------+----------+----------+----------+
951 row in set (3 min 24.41 sec)
96
97mysql> OPTIMIZE TABLE chipMask;
98+---------------+----------+----------+----------+
99| Table | Op | Msg_type | Msg_text |
100+---------------+----------+----------+----------+
101| gpc1.chipMask | optimize | status | OK |
102+---------------+----------+----------+----------+
1031 row in set (1.39 sec)
104
105mysql> OPTIMIZE TABLE chipProcessedImfile;
106+--------------------------+----------+----------+----------+
107| Table | Op | Msg_type | Msg_text |
108+--------------------------+----------+----------+----------+
109| gpc1.chipProcessedImfile | optimize | status | OK |
110+--------------------------+----------+----------+----------+
1111 row in set (18 min 47.04 sec)
112
113mysql> OPTIMIZE TABLE chipRun;
114+--------------+----------+----------+----------+
115| Table | Op | Msg_type | Msg_text |
116+--------------+----------+----------+----------+
117| gpc1.chipRun | optimize | status | OK |
118+--------------+----------+----------+----------+
1191 row in set (12.48 sec)
120
121mysql> OPTIMIZE TABLE dbversion;
122+----------------+----------+----------+----------+
123| Table | Op | Msg_type | Msg_text |
124+----------------+----------+----------+----------+
125| gpc1.dbversion | optimize | status | OK |
126+----------------+----------+----------+----------+
1271 row in set (1.08 sec)
128
129mysql> OPTIMIZE TABLE detInputExp;
130+------------------+----------+----------+----------+
131| Table | Op | Msg_type | Msg_text |
132+------------------+----------+----------+----------+
133| gpc1.detInputExp | optimize | status | OK |
134+------------------+----------+----------+----------+
1351 row in set (1.72 sec)
136
137mysql> OPTIMIZE TABLE detNormalizedExp;
138+-----------------------+----------+----------+----------+
139| Table | Op | Msg_type | Msg_text |
140+-----------------------+----------+----------+----------+
141| gpc1.detNormalizedExp | optimize | status | OK |
142+-----------------------+----------+----------+----------+
1431 row in set (1.24 sec)
144
145mysql> OPTIMIZE TABLE detNormalizedImfile;
146+--------------------------+----------+----------+----------+
147| Table | Op | Msg_type | Msg_text |
148+--------------------------+----------+----------+----------+
149| gpc1.detNormalizedImfile | optimize | status | OK |
150+--------------------------+----------+----------+----------+
1511 row in set (1.52 sec)
152
153mysql> OPTIMIZE TABLE detNormalizedStatImfile;
154+------------------------------+----------+----------+----------+
155| Table | Op | Msg_type | Msg_text |
156+------------------------------+----------+----------+----------+
157| gpc1.detNormalizedStatImfile | optimize | status | OK |
158+------------------------------+----------+----------+----------+
1591 row in set (1.28 sec)
160
161mysql> OPTIMIZE TABLE detProcessedExp;
162+----------------------+----------+----------+----------+
163| Table | Op | Msg_type | Msg_text |
164+----------------------+----------+----------+----------+
165| gpc1.detProcessedExp | optimize | status | OK |
166+----------------------+----------+----------+----------+
1671 row in set (1.37 sec)
168
169mysql> OPTIMIZE TABLE detProcessedImfile;
170+-------------------------+----------+----------+----------+
171| Table | Op | Msg_type | Msg_text |
172+-------------------------+----------+----------+----------+
173| gpc1.detProcessedImfile | optimize | status | OK |
174+-------------------------+----------+----------+----------+
1751 row in set (14.96 sec)
176
177mysql> OPTIMIZE TABLE detRegisteredImfile;
178+--------------------------+----------+----------+----------+
179| Table | Op | Msg_type | Msg_text |
180+--------------------------+----------+----------+----------+
181| gpc1.detRegisteredImfile | optimize | status | OK |
182+--------------------------+----------+----------+----------+
1831 row in set (1.42 sec)
184
185mysql> OPTIMIZE TABLE detResidExp;
186+------------------+----------+----------+----------+
187| Table | Op | Msg_type | Msg_text |
188+------------------+----------+----------+----------+
189| gpc1.detResidExp | optimize | status | OK |
190+------------------+----------+----------+----------+
1911 row in set (1.58 sec)
192
193mysql> OPTIMIZE TABLE detResidImfile;
194+---------------------+----------+----------+----------+
195| Table | Op | Msg_type | Msg_text |
196+---------------------+----------+----------+----------+
197| gpc1.detResidImfile | optimize | status | OK |
198+---------------------+----------+----------+----------+
1991 row in set (18.63 sec)
200
201mysql> OPTIMIZE TABLE detRun;
202+-------------+----------+----------+----------+
203| Table | Op | Msg_type | Msg_text |
204+-------------+----------+----------+----------+
205| gpc1.detRun | optimize | status | OK |
206+-------------+----------+----------+----------+
2071 row in set (5.43 sec)
208
209mysql> OPTIMIZE TABLE detRunSummary;
210+--------------------+----------+----------+----------+
211| Table | Op | Msg_type | Msg_text |
212+--------------------+----------+----------+----------+
213| gpc1.detRunSummary | optimize | status | OK |
214+--------------------+----------+----------+----------+
2151 row in set (1.11 sec)
216
217mysql> OPTIMIZE TABLE detStackedImfile;
218+-----------------------+----------+----------+----------+
219| Table | Op | Msg_type | Msg_text |
220+-----------------------+----------+----------+----------+
221| gpc1.detStackedImfile | optimize | status | OK |
222+-----------------------+----------+----------+----------+
2231 row in set (1.44 sec)
224
225mysql> OPTIMIZE TABLE detectionEfficiency;
226+--------------------------+----------+----------+----------+
227| Table | Op | Msg_type | Msg_text |
228+--------------------------+----------+----------+----------+
229| gpc1.detectionEfficiency | optimize | status | OK |
230+--------------------------+----------+----------+----------+
2311 row in set (40.75 sec)
232
233mysql> OPTIMIZE TABLE diffInputSkyfile;
234+-----------------------+----------+----------+----------+
235| Table | Op | Msg_type | Msg_text |
236+-----------------------+----------+----------+----------+
237| gpc1.diffInputSkyfile | optimize | status | OK |
238+-----------------------+----------+----------+----------+
2391 row in set (8 min 6.78 sec)
240
241mysql> OPTIMIZE TABLE diffPhotRun;
242+------------------+----------+----------+----------+
243| Table | Op | Msg_type | Msg_text |
244+------------------+----------+----------+----------+
245| gpc1.diffPhotRun | optimize | status | OK |
246+------------------+----------+----------+----------+
2471 row in set (1.57 sec)
248
249mysql> OPTIMIZE TABLE diffPhotSkyfile;
250+----------------------+----------+----------+----------+
251| Table | Op | Msg_type | Msg_text |
252+----------------------+----------+----------+----------+
253| gpc1.diffPhotSkyfile | optimize | status | OK |
254+----------------------+----------+----------+----------+
2551 row in set (10.94 sec)
256
257mysql> OPTIMIZE TABLE diffRun;
258+--------------+----------+----------+----------+
259| Table | Op | Msg_type | Msg_text |
260+--------------+----------+----------+----------+
261| gpc1.diffRun | optimize | status | OK |
262+--------------+----------+----------+----------+
2631 row in set (7.58 sec)
264
265mysql> OPTIMIZE TABLE diffSkyfile;
266+------------------+----------+----------+----------+
267| Table | Op | Msg_type | Msg_text |
268+------------------+----------+----------+----------+
269| gpc1.diffSkyfile | optimize | status | OK |
270+------------------+----------+----------+----------+
2711 row in set (7 min 39.92 sec)
272
273mysql> OPTIMIZE TABLE diffSummary;
274+------------------+----------+----------+----------+
275| Table | Op | Msg_type | Msg_text |
276+------------------+----------+----------+----------+
277| gpc1.diffSummary | optimize | status | OK |
278+------------------+----------+----------+----------+
2791 row in set (6.02 sec)
280
281mysql> OPTIMIZE TABLE distComponent;
282+--------------------+----------+----------+----------+
283| Table | Op | Msg_type | Msg_text |
284+--------------------+----------+----------+----------+
285| gpc1.distComponent | optimize | status | OK |
286+--------------------+----------+----------+----------+
2871 row in set (5 min 37.66 sec)
288
289mysql> OPTIMIZE TABLE distRun;
290+--------------+----------+----------+----------+
291| Table | Op | Msg_type | Msg_text |
292+--------------+----------+----------+----------+
293| gpc1.distRun | optimize | status | OK |
294+--------------+----------+----------+----------+
2951 row in set (31.63 sec)
296
297mysql> OPTIMIZE TABLE distTarget;
298+-----------------+----------+----------+----------+
299| Table | Op | Msg_type | Msg_text |
300+-----------------+----------+----------+----------+
301| gpc1.distTarget | optimize | status | OK |
302+-----------------+----------+----------+----------+
3031 row in set (1.38 sec)
304
305mysql> OPTIMIZE TABLE dqstatsContent;
306+---------------------+----------+----------+----------+
307| Table | Op | Msg_type | Msg_text |
308+---------------------+----------+----------+----------+
309| gpc1.dqstatsContent | optimize | status | OK |
310+---------------------+----------+----------+----------+
3111 row in set (16.37 sec)
312
313mysql> OPTIMIZE TABLE dqstatsRun;
314+-----------------+----------+----------+----------+
315| Table | Op | Msg_type | Msg_text |
316+-----------------+----------+----------+----------+
317| gpc1.dqstatsRun | optimize | status | OK |
318+-----------------+----------+----------+----------+
3191 row in set (1.45 sec)
320
321mysql> OPTIMIZE TABLE fakeMask;
322+---------------+----------+----------+----------+
323| Table | Op | Msg_type | Msg_text |
324+---------------+----------+----------+----------+
325| gpc1.fakeMask | optimize | status | OK |
326+---------------+----------+----------+----------+
3271 row in set (1.22 sec)
328
329mysql> OPTIMIZE TABLE fakeProcessedImfile;
330+--------------------------+----------+----------+----------+
331| Table | Op | Msg_type | Msg_text |
332+--------------------------+----------+----------+----------+
333| gpc1.fakeProcessedImfile | optimize | status | OK |
334+--------------------------+----------+----------+----------+
3351 row in set (5 min 42.07 sec)
336
337mysql> OPTIMIZE TABLE fakeRun;
338+--------------+----------+----------+----------+
339| Table | Op | Msg_type | Msg_text |
340+--------------+----------+----------+----------+
341| gpc1.fakeRun | optimize | status | OK |
342+--------------+----------+----------+----------+
3431 row in set (11.32 sec)
344
345mysql> OPTIMIZE TABLE flatcorrAddstarLink;
346+--------------------------+----------+----------+----------+
347| Table | Op | Msg_type | Msg_text |
348+--------------------------+----------+----------+----------+
349| gpc1.flatcorrAddstarLink | optimize | status | OK |
350+--------------------------+----------+----------+----------+
3511 row in set (1.42 sec)
352
353mysql> OPTIMIZE TABLE flatcorrCamLink;
354+----------------------+----------+----------+----------+
355| Table | Op | Msg_type | Msg_text |
356+----------------------+----------+----------+----------+
357| gpc1.flatcorrCamLink | optimize | status | OK |
358+----------------------+----------+----------+----------+
3591 row in set (1.42 sec)
360
361mysql> OPTIMIZE TABLE flatcorrChipLink;
362+-----------------------+----------+----------+----------+
363| Table | Op | Msg_type | Msg_text |
364+-----------------------+----------+----------+----------+
365| gpc1.flatcorrChipLink | optimize | status | OK |
366+-----------------------+----------+----------+----------+
3671 row in set (1.45 sec)
368
369mysql> OPTIMIZE TABLE flatcorrRun;
370+------------------+----------+----------+----------+
371| Table | Op | Msg_type | Msg_text |
372+------------------+----------+----------+----------+
373| gpc1.flatcorrRun | optimize | status | OK |
374+------------------+----------+----------+----------+
3751 row in set (1.57 sec)
376
377mysql> OPTIMIZE TABLE lapExp;
378+-------------+----------+----------+----------+
379| Table | Op | Msg_type | Msg_text |
380+-------------+----------+----------+----------+
381| gpc1.lapExp | optimize | status | OK |
382+-------------+----------+----------+----------+
3831 row in set (4.32 sec)
384
385mysql> OPTIMIZE TABLE lapRun;
386+-------------+----------+----------+----------+
387| Table | Op | Msg_type | Msg_text |
388+-------------+----------+----------+----------+
389| gpc1.lapRun | optimize | status | OK |
390+-------------+----------+----------+----------+
3911 row in set (1.62 sec)
392
393mysql> OPTIMIZE TABLE lapSequence;
394+------------------+----------+----------+----------+
395| Table | Op | Msg_type | Msg_text |
396+------------------+----------+----------+----------+
397| gpc1.lapSequence | optimize | status | OK |
398+------------------+----------+----------+----------+
3991 row in set (1.25 sec)
400
401mysql> OPTIMIZE TABLE magicDSFile;
402+------------------+----------+----------+----------+
403| Table | Op | Msg_type | Msg_text |
404+------------------+----------+----------+----------+
405| gpc1.magicDSFile | optimize | status | OK |
406+------------------+----------+----------+----------+
4071 row in set (16 min 27.05 sec)
408
409mysql> OPTIMIZE TABLE magicDSRun;
410+-----------------+----------+----------+----------+
411| Table | Op | Msg_type | Msg_text |
412+-----------------+----------+----------+----------+
413| gpc1.magicDSRun | optimize | status | OK |
414+-----------------+----------+----------+----------+
4151 row in set (36.68 sec)
416
417mysql> OPTIMIZE TABLE magicDSUpdateRun;
418+-----------------------+----------+----------+----------+
419| Table | Op | Msg_type | Msg_text |
420+-----------------------+----------+----------+----------+
421| gpc1.magicDSUpdateRun | optimize | status | OK |
422+-----------------------+----------+----------+----------+
4231 row in set (5.33 sec)
424
425mysql> OPTIMIZE TABLE magicInputSkyfile;
426+------------------------+----------+----------+----------+
427| Table | Op | Msg_type | Msg_text |
428+------------------------+----------+----------+----------+
429| gpc1.magicInputSkyfile | optimize | status | OK |
430+------------------------+----------+----------+----------+
4311 row in set (1 min 43.45 sec)
432
433mysql> OPTIMIZE TABLE magicMask;
434+----------------+----------+----------+----------+
435| Table | Op | Msg_type | Msg_text |
436+----------------+----------+----------+----------+
437| gpc1.magicMask | optimize | status | OK |
438+----------------+----------+----------+----------+
4391 row in set (4.49 sec)
440
441mysql> OPTIMIZE TABLE magicNodeResult;
442+----------------------+----------+----------+----------+
443| Table | Op | Msg_type | Msg_text |
444+----------------------+----------+----------+----------+
445| gpc1.magicNodeResult | optimize | status | OK |
446+----------------------+----------+----------+----------+
4471 row in set (4 min 50.11 sec)
448
449mysql> OPTIMIZE TABLE magicRun;
450+---------------+----------+----------+----------+
451| Table | Op | Msg_type | Msg_text |
452+---------------+----------+----------+----------+
453| gpc1.magicRun | optimize | status | OK |
454+---------------+----------+----------+----------+
4551 row in set (8.96 sec)
456
457mysql> OPTIMIZE TABLE magicTree;
458+----------------+----------+----------+----------+
459| Table | Op | Msg_type | Msg_text |
460+----------------+----------+----------+----------+
461| gpc1.magicTree | optimize | status | OK |
462+----------------+----------+----------+----------+
4631 row in set (15 min 45.35 sec)
464
465mysql> OPTIMIZE TABLE magicUpdateRun;
466+---------------------+----------+----------+----------+
467| Table | Op | Msg_type | Msg_text |
468+---------------------+----------+----------+----------+
469| gpc1.magicUpdateRun | optimize | status | OK |
470+---------------------+----------+----------+----------+
4711 row in set (2.84 sec)
472
473mysql> OPTIMIZE TABLE minidvodbCopy;
474+--------------------+----------+----------+----------+
475| Table | Op | Msg_type | Msg_text |
476+--------------------+----------+----------+----------+
477| gpc1.minidvodbCopy | optimize | status | OK |
478+--------------------+----------+----------+----------+
4791 row in set (1.43 sec)
480
481mysql> OPTIMIZE TABLE minidvodbProcessed;
482+-------------------------+----------+----------+----------+
483| Table | Op | Msg_type | Msg_text |
484+-------------------------+----------+----------+----------+
485| gpc1.minidvodbProcessed | optimize | status | OK |
486+-------------------------+----------+----------+----------+
4871 row in set (1.49 sec)
488
489mysql> OPTIMIZE TABLE minidvodbRun;
490+-------------------+----------+----------+----------+
491| Table | Op | Msg_type | Msg_text |
492+-------------------+----------+----------+----------+
493| gpc1.minidvodbRun | optimize | status | OK |
494+-------------------+----------+----------+----------+
4951 row in set (1.44 sec)
496
497mysql> OPTIMIZE TABLE newExp;
498+-------------+----------+----------+----------+
499| Table | Op | Msg_type | Msg_text |
500+-------------+----------+----------+----------+
501| gpc1.newExp | optimize | status | OK |
502+-------------+----------+----------+----------+
5031 row in set (14.50 sec)
504
505mysql> OPTIMIZE TABLE newImfile;
506+----------------+----------+----------+----------+
507| Table | Op | Msg_type | Msg_text |
508+----------------+----------+----------+----------+
509| gpc1.newImfile | optimize | status | OK |
510+----------------+----------+----------+----------+
5111 row in set (4 min 29.06 sec)
512
513mysql> OPTIMIZE TABLE publishClient;
514+--------------------+----------+----------+----------+
515| Table | Op | Msg_type | Msg_text |
516+--------------------+----------+----------+----------+
517| gpc1.publishClient | optimize | status | OK |
518+--------------------+----------+----------+----------+
5191 row in set (1.40 sec)
520
521mysql> OPTIMIZE TABLE publishDone;
522+------------------+----------+----------+----------+
523| Table | Op | Msg_type | Msg_text |
524+------------------+----------+----------+----------+
525| gpc1.publishDone | optimize | status | OK |
526+------------------+----------+----------+----------+
5271 row in set (4.08 sec)
528
529mysql> OPTIMIZE TABLE publishRun;
530+-----------------+----------+----------+----------+
531| Table | Op | Msg_type | Msg_text |
532+-----------------+----------+----------+----------+
533| gpc1.publishRun | optimize | status | OK |
534+-----------------+----------+----------+----------+
5351 row in set (9.03 sec)
536
537mysql> OPTIMIZE TABLE pzDataStore;
538+------------------+----------+----------+----------+
539| Table | Op | Msg_type | Msg_text |
540+------------------+----------+----------+----------+
541| gpc1.pzDataStore | optimize | status | OK |
542+------------------+----------+----------+----------+
5431 row in set (1.33 sec)
544
545mysql> OPTIMIZE TABLE pzDownloadExp;
546+--------------------+----------+----------+----------+
547| Table | Op | Msg_type | Msg_text |
548+--------------------+----------+----------+----------+
549| gpc1.pzDownloadExp | optimize | status | OK |
550+--------------------+----------+----------+----------+
5511 row in set (6.29 sec)
552
553mysql> OPTIMIZE TABLE pzDownloadImfile;
554+-----------------------+----------+----------+----------+
555| Table | Op | Msg_type | Msg_text |
556+-----------------------+----------+----------+----------+
557| gpc1.pzDownloadImfile | optimize | status | OK |
558+-----------------------+----------+----------+----------+
5591 row in set (7 min 59.24 sec)
560
561mysql> OPTIMIZE TABLE rawExp;
562+-------------+----------+----------+----------+
563| Table | Op | Msg_type | Msg_text |
564+-------------+----------+----------+----------+
565| gpc1.rawExp | optimize | status | OK |
566+-------------+----------+----------+----------+
5671 row in set (16.77 sec)
568
569mysql> OPTIMIZE TABLE rawImfile;
570+----------------+----------+----------+----------+
571| Table | Op | Msg_type | Msg_text |
572+----------------+----------+----------+----------+
573| gpc1.rawImfile | optimize | status | OK |
574+----------------+----------+----------+----------+
5751 row in set (27 min 11.68 sec)
576
577mysql> OPTIMIZE TABLE rcDSFileset;
578+------------------+----------+----------+----------+
579| Table | Op | Msg_type | Msg_text |
580+------------------+----------+----------+----------+
581| gpc1.rcDSFileset | optimize | status | OK |
582+------------------+----------+----------+----------+
5831 row in set (18.26 sec)
584
585mysql> OPTIMIZE TABLE rcDestination;
586+--------------------+----------+----------+----------+
587| Table | Op | Msg_type | Msg_text |
588+--------------------+----------+----------+----------+
589| gpc1.rcDestination | optimize | status | OK |
590+--------------------+----------+----------+----------+
5911 row in set (1.14 sec)
592
593mysql> OPTIMIZE TABLE rcInterest;
594+-----------------+----------+----------+----------+
595| Table | Op | Msg_type | Msg_text |
596+-----------------+----------+----------+----------+
597| gpc1.rcInterest | optimize | status | OK |
598+-----------------+----------+----------+----------+
5991 row in set (1.49 sec)
600
601mysql> OPTIMIZE TABLE rcRun;
602+------------+----------+----------+----------+
603| Table | Op | Msg_type | Msg_text |
604+------------+----------+----------+----------+
605| gpc1.rcRun | optimize | status | OK |
606+------------+----------+----------+----------+
6071 row in set (1.31 sec)
608
609mysql> OPTIMIZE TABLE receiveFile;
610+------------------+----------+----------+----------+
611| Table | Op | Msg_type | Msg_text |
612+------------------+----------+----------+----------+
613| gpc1.receiveFile | optimize | status | OK |
614+------------------+----------+----------+----------+
6151 row in set (1.11 sec)
616
617mysql> OPTIMIZE TABLE receiveFileset;
618+---------------------+----------+----------+----------+
619| Table | Op | Msg_type | Msg_text |
620+---------------------+----------+----------+----------+
621| gpc1.receiveFileset | optimize | status | OK |
622+---------------------+----------+----------+----------+
6231 row in set (1.10 sec)
624
625mysql> OPTIMIZE TABLE receiveResult;
626+--------------------+----------+----------+----------+
627| Table | Op | Msg_type | Msg_text |
628+--------------------+----------+----------+----------+
629| gpc1.receiveResult | optimize | status | OK |
630+--------------------+----------+----------+----------+
6311 row in set (1.09 sec)
632
633mysql> OPTIMIZE TABLE receiveSource;
634+--------------------+----------+----------+----------+
635| Table | Op | Msg_type | Msg_text |
636+--------------------+----------+----------+----------+
637| gpc1.receiveSource | optimize | status | OK |
638+--------------------+----------+----------+----------+
6391 row in set (1.12 sec)
640
641mysql> OPTIMIZE TABLE stackAssociation;
642+-----------------------+----------+----------+----------+
643| Table | Op | Msg_type | Msg_text |
644+-----------------------+----------+----------+----------+
645| gpc1.stackAssociation | optimize | status | OK |
646+-----------------------+----------+----------+----------+
6471 row in set (1.35 sec)
648
649mysql> OPTIMIZE TABLE stackAssociationMap;
650+--------------------------+----------+----------+----------+
651| Table | Op | Msg_type | Msg_text |
652+--------------------------+----------+----------+----------+
653| gpc1.stackAssociationMap | optimize | status | OK |
654+--------------------------+----------+----------+----------+
6551 row in set (4.10 sec)
656
657mysql> OPTIMIZE TABLE stackInputSkyfile;
658+------------------------+----------+----------+----------+
659| Table | Op | Msg_type | Msg_text |
660+------------------------+----------+----------+----------+
661| gpc1.stackInputSkyfile | optimize | status | OK |
662+------------------------+----------+----------+----------+
6631 row in set (44.45 sec)
664
665mysql> OPTIMIZE TABLE stackRun;
666+---------------+----------+----------+----------+
667| Table | Op | Msg_type | Msg_text |
668+---------------+----------+----------+----------+
669| gpc1.stackRun | optimize | status | OK |
670+---------------+----------+----------+----------+
6711 row in set (14.76 sec)
672
673mysql> OPTIMIZE TABLE stackSumSkyfile;
674+----------------------+----------+----------+----------+
675| Table | Op | Msg_type | Msg_text |
676+----------------------+----------+----------+----------+
677| gpc1.stackSumSkyfile | optimize | status | OK |
678+----------------------+----------+----------+----------+
6791 row in set (19.43 sec)
680
681mysql> OPTIMIZE TABLE stackSummary;
682+-------------------+----------+----------+----------+
683| Table | Op | Msg_type | Msg_text |
684+-------------------+----------+----------+----------+
685| gpc1.stackSummary | optimize | status | OK |
686+-------------------+----------+----------+----------+
6871 row in set (1.36 sec)
688
689mysql> OPTIMIZE TABLE staticskyInput;
690+---------------------+----------+----------+----------+
691| Table | Op | Msg_type | Msg_text |
692+---------------------+----------+----------+----------+
693| gpc1.staticskyInput | optimize | status | OK |
694+---------------------+----------+----------+----------+
6951 row in set (1.57 sec)
696
697mysql> OPTIMIZE TABLE staticskyResult;
698+----------------------+----------+----------+----------+
699| Table | Op | Msg_type | Msg_text |
700+----------------------+----------+----------+----------+
701| gpc1.staticskyResult | optimize | status | OK |
702+----------------------+----------+----------+----------+
7031 row in set (1.88 sec)
704
705mysql> OPTIMIZE TABLE staticskyRun;
706+-------------------+----------+----------+----------+
707| Table | Op | Msg_type | Msg_text |
708+-------------------+----------+----------+----------+
709| gpc1.staticskyRun | optimize | status | OK |
710+-------------------+----------+----------+----------+
7111 row in set (1.99 sec)
712
713mysql> OPTIMIZE TABLE summitExp;
714+----------------+----------+----------+----------+
715| Table | Op | Msg_type | Msg_text |
716+----------------+----------+----------+----------+
717| gpc1.summitExp | optimize | status | OK |
718+----------------+----------+----------+----------+
7191 row in set (8.23 sec)
720
721mysql> OPTIMIZE TABLE summitImfile;
722+-------------------+----------+----------+----------+
723| Table | Op | Msg_type | Msg_text |
724+-------------------+----------+----------+----------+
725| gpc1.summitImfile | optimize | status | OK |
726+-------------------+----------+----------+----------+
7271 row in set (8 min 15.60 sec)
728
729mysql> OPTIMIZE TABLE warpBackgroundRun;
730+------------------------+----------+----------+----------+
731| Table | Op | Msg_type | Msg_text |
732+------------------------+----------+----------+----------+
733| gpc1.warpBackgroundRun | optimize | status | OK |
734+------------------------+----------+----------+----------+
7351 row in set (1.68 sec)
736
737mysql> OPTIMIZE TABLE warpBackgroundSkyfile;
738+----------------------------+----------+----------+----------+
739| Table | Op | Msg_type | Msg_text |
740+----------------------------+----------+----------+----------+
741| gpc1.warpBackgroundSkyfile | optimize | status | OK |
742+----------------------------+----------+----------+----------+
7431 row in set (7.34 sec)
744
745mysql> OPTIMIZE TABLE warpImfile;
746+-----------------+----------+----------+----------+
747| Table | Op | Msg_type | Msg_text |
748+-----------------+----------+----------+----------+
749| gpc1.warpImfile | optimize | status | OK |
750+-----------------+----------+----------+----------+
7511 row in set (6 min 9.49 sec)
752
753mysql> OPTIMIZE TABLE warpMask;
754+---------------+----------+----------+----------+
755| Table | Op | Msg_type | Msg_text |
756+---------------+----------+----------+----------+
757| gpc1.warpMask | optimize | status | OK |
758+---------------+----------+----------+----------+
7591 row in set (1.41 sec)
760
761mysql> OPTIMIZE TABLE warpRun;
762+--------------+----------+----------+----------+
763| Table | Op | Msg_type | Msg_text |
764+--------------+----------+----------+----------+
765| gpc1.warpRun | optimize | status | OK |
766+--------------+----------+----------+----------+
7671 row in set (13.55 sec)
768
769OPTIMIZE TABLE warpSkyCellMap;
770+---------------------+----------+----------+----------+
771| Table | Op | Msg_type | Msg_text |
772+---------------------+----------+----------+----------+
773| gpc1.warpSkyCellMap | optimize | status | OK |
774+---------------------+----------+----------+----------+
775
776mysql> OPTIMIZE TABLE warpSkyfile;
777+------------------+----------+----------+----------+
778| Table | Op | Msg_type | Msg_text |
779+------------------+----------+----------+----------+
780| gpc1.warpSkyfile | optimize | status | OK |
781+------------------+----------+----------+----------+
7821 row in set (20 min 42.05 sec)
783
784mysql> OPTIMIZE TABLE warpSummary;
785+------------------+----------+----------+----------+
786| Table | Op | Msg_type | Msg_text |
787+------------------+----------+----------+----------+
788| gpc1.warpSummary | optimize | status | OK |
789+------------------+----------+----------+----------+
7901 row in set (12.29 sec)
791
792