IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

201103_Optimization: log.optimization.gpc1

File log.optimization.gpc1, 19.6 KB (added by Serge CHASTEL, 15 years ago)
Line 
1mysql> OPTIMIZE TABLE distTarget;
2+-----------------+----------+----------+----------+
3| Table | Op | Msg_type | Msg_text |
4+-----------------+----------+----------+----------+
5| gpc1.distTarget | optimize | status | OK |
6+-----------------+----------+----------+----------+
71 row in set (1.01 sec)
8
9mysql> OPTIMIZE TABLE dqstatsContent;
10+---------------------+----------+----------+----------+
11| Table | Op | Msg_type | Msg_text |
12+---------------------+----------+----------+----------+
13| gpc1.dqstatsContent | optimize | status | OK |
14+---------------------+----------+----------+----------+
151 row in set (14.80 sec)
16
17mysql> OPTIMIZE TABLE dqstatsRun;
18+-----------------+----------+----------+----------+
19| Table | Op | Msg_type | Msg_text |
20+-----------------+----------+----------+----------+
21| gpc1.dqstatsRun | optimize | status | OK |
22+-----------------+----------+----------+----------+
231 row in set (0.86 sec)
24
25mysql> OPTIMIZE TABLE fakeMask;
26+---------------+----------+----------+----------+
27| Table | Op | Msg_type | Msg_text |
28+---------------+----------+----------+----------+
29| gpc1.fakeMask | optimize | status | OK |
30+---------------+----------+----------+----------+
311 row in set (0.70 sec)
32
33mysql> OPTIMIZE TABLE fakeProcessedImfile;
34+--------------------------+----------+----------+----------+
35| Table | Op | Msg_type | Msg_text |
36+--------------------------+----------+----------+----------+
37| gpc1.fakeProcessedImfile | optimize | status | OK |
38+--------------------------+----------+----------+----------+
391 row in set (3 min 32.81 sec)
40
41mysql> OPTIMIZE TABLE fakeRun;
42+--------------+----------+----------+----------+
43| Table | Op | Msg_type | Msg_text |
44+--------------+----------+----------+----------+
45| gpc1.fakeRun | optimize | status | OK |
46+--------------+----------+----------+----------+
471 row in set (7.02 sec)
48
49mysql> OPTIMIZE TABLE flatcorrAddstarLink;
50+--------------------------+----------+----------+----------+
51| Table | Op | Msg_type | Msg_text |
52+--------------------------+----------+----------+----------+
53| gpc1.flatcorrAddstarLink | optimize | status | OK |
54+--------------------------+----------+----------+----------+
551 row in set (0.76 sec)
56
57mysql> OPTIMIZE TABLE flatcorrCamLink;
58+----------------------+----------+----------+----------+
59| Table | Op | Msg_type | Msg_text |
60+----------------------+----------+----------+----------+
61| gpc1.flatcorrCamLink | optimize | status | OK |
62+----------------------+----------+----------+----------+
631 row in set (0.73 sec)
64
65mysql> OPTIMIZE TABLE flatcorrChipLink;
66+-----------------------+----------+----------+----------+
67| Table | Op | Msg_type | Msg_text |
68+-----------------------+----------+----------+----------+
69| gpc1.flatcorrChipLink | optimize | status | OK |
70+-----------------------+----------+----------+----------+
711 row in set (0.70 sec)
72
73mysql> OPTIMIZE TABLE flatcorrRun;
74+------------------+----------+----------+----------+
75| Table | Op | Msg_type | Msg_text |
76+------------------+----------+----------+----------+
77| gpc1.flatcorrRun | optimize | status | OK |
78+------------------+----------+----------+----------+
791 row in set (0.72 sec)
80
81mysql> OPTIMIZE TABLE magicDSFile;
82+------------------+----------+----------+----------+
83| Table | Op | Msg_type | Msg_text |
84+------------------+----------+----------+----------+
85| gpc1.magicDSFile | optimize | status | OK |
86+------------------+----------+----------+----------+
871 row in set (6 min 30.67 sec)
88
89mysql> OPTIMIZE TABLE magicDSRun;
90+-----------------+----------+----------+----------+
91| Table | Op | Msg_type | Msg_text |
92+-----------------+----------+----------+----------+
93| gpc1.magicDSRun | optimize | status | OK |
94+-----------------+----------+----------+----------+
951 row in set (20.38 sec)
96
97mysql> OPTIMIZE TABLE magicDSUpdateRun;
98+-----------------------+----------+----------+----------+
99| Table | Op | Msg_type | Msg_text |
100+-----------------------+----------+----------+----------+
101| gpc1.magicDSUpdateRun | optimize | status | OK |
102+-----------------------+----------+----------+----------+
1031 row in set (4.91 sec)
104
105mysql> OPTIMIZE TABLE magicInputSkyfile;
106+------------------------+----------+----------+----------+
107| Table | Op | Msg_type | Msg_text |
108+------------------------+----------+----------+----------+
109| gpc1.magicInputSkyfile | optimize | status | OK |
110+------------------------+----------+----------+----------+
1111 row in set (1 min 10.32 sec)
112
113mysql> OPTIMIZE TABLE magicMask;
114+----------------+----------+----------+----------+
115| Table | Op | Msg_type | Msg_text |
116+----------------+----------+----------+----------+
117| gpc1.magicMask | optimize | status | OK |
118+----------------+----------+----------+----------+
1191 row in set (2.55 sec)
120
121mysql> OPTIMIZE TABLE magicNodeResult;
122+----------------------+----------+----------+----------+
123| Table | Op | Msg_type | Msg_text |
124+----------------------+----------+----------+----------+
125| gpc1.magicNodeResult | optimize | status | OK |
126+----------------------+----------+----------+----------+
1271 row in set (2 min 19.92 sec)
128
129mysql> OPTIMIZE TABLE magicRun;
130+---------------+----------+----------+----------+
131| Table | Op | Msg_type | Msg_text |
132+---------------+----------+----------+----------+
133| gpc1.magicRun | optimize | status | OK |
134+---------------+----------+----------+----------+
1351 row in set (5.64 sec)
136
137mysql> OPTIMIZE TABLE magicTree;
138+----------------+----------+----------+----------+
139| Table | Op | Msg_type | Msg_text |
140+----------------+----------+----------+----------+
141| gpc1.magicTree | optimize | status | OK |
142+----------------+----------+----------+----------+
1431 row in set (10 min 17.58 sec)
144
145mysql> OPTIMIZE TABLE magicUpdateRun;
146+---------------------+----------+----------+----------+
147| Table | Op | Msg_type | Msg_text |
148+---------------------+----------+----------+----------+
149| gpc1.magicUpdateRun | optimize | status | OK |
150+---------------------+----------+----------+----------+
1511 row in set (3.24 sec)
152
153mysql> OPTIMIZE TABLE minidvodbCopy;
154+--------------------+----------+----------+----------+
155| Table | Op | Msg_type | Msg_text |
156+--------------------+----------+----------+----------+
157| gpc1.minidvodbCopy | optimize | status | OK |
158+--------------------+----------+----------+----------+
1591 row in set (0.71 sec)
160
161mysql> OPTIMIZE TABLE minidvodbProcessed;
162+-------------------------+----------+----------+----------+
163| Table | Op | Msg_type | Msg_text |
164+-------------------------+----------+----------+----------+
165| gpc1.minidvodbProcessed | optimize | status | OK |
166+-------------------------+----------+----------+----------+
1671 row in set (0.81 sec)
168
169mysql> OPTIMIZE TABLE minidvodbRun;
170+-------------------+----------+----------+----------+
171| Table | Op | Msg_type | Msg_text |
172+-------------------+----------+----------+----------+
173| gpc1.minidvodbRun | optimize | status | OK |
174+-------------------+----------+----------+----------+
1751 row in set (0.82 sec)
176
177mysql> OPTIMIZE TABLE newExp;
178+-------------+----------+----------+----------+
179| Table | Op | Msg_type | Msg_text |
180+-------------+----------+----------+----------+
181| gpc1.newExp | optimize | status | OK |
182+-------------+----------+----------+----------+
1831 row in set (27.20 sec)
184
185mysql> OPTIMIZE TABLE newImfile;
186+----------------+----------+----------+----------+
187| Table | Op | Msg_type | Msg_text |
188+----------------+----------+----------+----------+
189| gpc1.newImfile | optimize | status | OK |
190+----------------+----------+----------+----------+
1911 row in set (4 min 51.75 sec)
192
193mysql> OPTIMIZE TABLE publishClient;
194+--------------------+----------+----------+----------+
195| Table | Op | Msg_type | Msg_text |
196+--------------------+----------+----------+----------+
197| gpc1.publishClient | optimize | status | OK |
198+--------------------+----------+----------+----------+
1991 row in set (0.79 sec)
200
201mysql> OPTIMIZE TABLE publishDone;
202+------------------+----------+----------+----------+
203| Table | Op | Msg_type | Msg_text |
204+------------------+----------+----------+----------+
205| gpc1.publishDone | optimize | status | OK |
206+------------------+----------+----------+----------+
2071 row in set (3.15 sec)
208
209mysql> OPTIMIZE TABLE publishRun;
210+-----------------+----------+----------+----------+
211| Table | Op | Msg_type | Msg_text |
212+-----------------+----------+----------+----------+
213| gpc1.publishRun | optimize | status | OK |
214+-----------------+----------+----------+----------+
2151 row in set (6.25 sec)
216
217mysql> OPTIMIZE TABLE pzDataStore;
218+------------------+----------+----------+----------+
219| Table | Op | Msg_type | Msg_text |
220+------------------+----------+----------+----------+
221| gpc1.pzDataStore | optimize | status | OK |
222+------------------+----------+----------+----------+
2231 row in set (0.65 sec)
224
225mysql> OPTIMIZE TABLE pzDownloadExp;
226+--------------------+----------+----------+----------+
227| Table | Op | Msg_type | Msg_text |
228+--------------------+----------+----------+----------+
229| gpc1.pzDownloadExp | optimize | status | OK |
230+--------------------+----------+----------+----------+
2311 row in set (4.99 sec)
232
233mysql> OPTIMIZE TABLE pzDownloadImfile;
234+-----------------------+----------+----------+----------+
235| Table | Op | Msg_type | Msg_text |
236+-----------------------+----------+----------+----------+
237| gpc1.pzDownloadImfile | optimize | status | OK |
238+-----------------------+----------+----------+----------+
2391 row in set (8 min 2.67 sec)
240
241mysql> OPTIMIZE TABLE rawExp;
242+-------------+----------+----------+----------+
243| Table | Op | Msg_type | Msg_text |
244+-------------+----------+----------+----------+
245| gpc1.rawExp | optimize | status | OK |
246+-------------+----------+----------+----------+
2471 row in set (12.14 sec)
248
249mysql> OPTIMIZE TABLE rawImfile;
250+----------------+----------+----------+----------+
251| Table | Op | Msg_type | Msg_text |
252+----------------+----------+----------+----------+
253| gpc1.rawImfile | optimize | status | OK |
254+----------------+----------+----------+----------+
2551 row in set (31 min 33.19 sec)
256
257mysql> OPTIMIZE TABLE rcDSFileset;
258+------------------+----------+----------+----------+
259| Table | Op | Msg_type | Msg_text |
260+------------------+----------+----------+----------+
261| gpc1.rcDSFileset | optimize | status | OK |
262+------------------+----------+----------+----------+
2631 row in set (13.31 sec)
264
265mysql> OPTIMIZE TABLE rcDestination;
266+--------------------+----------+----------+----------+
267| Table | Op | Msg_type | Msg_text |
268+--------------------+----------+----------+----------+
269| gpc1.rcDestination | optimize | status | OK |
270+--------------------+----------+----------+----------+
2711 row in set (0.55 sec)
272
273mysql> OPTIMIZE TABLE rcInterest;
274+-----------------+----------+----------+----------+
275| Table | Op | Msg_type | Msg_text |
276+-----------------+----------+----------+----------+
277| gpc1.rcInterest | optimize | status | OK |
278+-----------------+----------+----------+----------+
2791 row in set (0.78 sec)
280
281mysql> OPTIMIZE TABLE rcRun;
282+------------+----------+----------+----------+
283| Table | Op | Msg_type | Msg_text |
284+------------+----------+----------+----------+
285| gpc1.rcRun | optimize | status | OK |
286+------------+----------+----------+----------+
2871 row in set (0.62 sec)
288
289mysql> OPTIMIZE TABLE receiveFile;
290+------------------+----------+----------+----------+
291| Table | Op | Msg_type | Msg_text |
292+------------------+----------+----------+----------+
293| gpc1.receiveFile | optimize | status | OK |
294+------------------+----------+----------+----------+
2951 row in set (0.61 sec)
296
297mysql> OPTIMIZE TABLE receiveFileset;
298+---------------------+----------+----------+----------+
299| Table | Op | Msg_type | Msg_text |
300+---------------------+----------+----------+----------+
301| gpc1.receiveFileset | optimize | status | OK |
302+---------------------+----------+----------+----------+
3031 row in set (0.55 sec)
304
305mysql> OPTIMIZE TABLE receiveResult;
306+--------------------+----------+----------+----------+
307| Table | Op | Msg_type | Msg_text |
308+--------------------+----------+----------+----------+
309| gpc1.receiveResult | optimize | status | OK |
310+--------------------+----------+----------+----------+
3111 row in set (0.49 sec)
312
313mysql> OPTIMIZE TABLE receiveSource;
314+--------------------+----------+----------+----------+
315| Table | Op | Msg_type | Msg_text |
316+--------------------+----------+----------+----------+
317| gpc1.receiveSource | optimize | status | OK |
318+--------------------+----------+----------+----------+
3191 row in set (0.55 sec)
320
321mysql> OPTIMIZE TABLE stackAssociation;
322+-----------------------+----------+----------+----------+
323| Table | Op | Msg_type | Msg_text |
324+-----------------------+----------+----------+----------+
325| gpc1.stackAssociation | optimize | status | OK |
326+-----------------------+----------+----------+----------+
3271 row in set (0.76 sec)
328
329mysql> OPTIMIZE TABLE stackAssociationMap;
330+--------------------------+----------+----------+----------+
331| Table | Op | Msg_type | Msg_text |
332+--------------------------+----------+----------+----------+
333| gpc1.stackAssociationMap | optimize | status | OK |
334+--------------------------+----------+----------+----------+
3351 row in set (1.95 sec)
336
337mysql> OPTIMIZE TABLE stackInputSkyfile;
338+------------------------+----------+----------+----------+
339| Table | Op | Msg_type | Msg_text |
340+------------------------+----------+----------+----------+
341| gpc1.stackInputSkyfile | optimize | status | OK |
342+------------------------+----------+----------+----------+
3431 row in set (30.29 sec)
344
345mysql> OPTIMIZE TABLE stackRun;
346+---------------+----------+----------+----------+
347| Table | Op | Msg_type | Msg_text |
348+---------------+----------+----------+----------+
349| gpc1.stackRun | optimize | status | OK |
350+---------------+----------+----------+----------+
3511 row in set (8.60 sec)
352
353mysql> OPTIMIZE TABLE stackSumSkyfile;
354+----------------------+----------+----------+----------+
355| Table | Op | Msg_type | Msg_text |
356+----------------------+----------+----------+----------+
357| gpc1.stackSumSkyfile | optimize | status | OK |
358+----------------------+----------+----------+----------+
3591 row in set (8.66 sec)
360
361mysql> OPTIMIZE TABLE stackSummary;
362+-------------------+----------+----------+----------+
363| Table | Op | Msg_type | Msg_text |
364+-------------------+----------+----------+----------+
365| gpc1.stackSummary | optimize | status | OK |
366+-------------------+----------+----------+----------+
3671 row in set (0.55 sec)
368
369mysql> OPTIMIZE TABLE staticskyInput;
370+---------------------+----------+----------+----------+
371| Table | Op | Msg_type | Msg_text |
372+---------------------+----------+----------+----------+
373| gpc1.staticskyInput | optimize | status | OK |
374+---------------------+----------+----------+----------+
3751 row in set (0.52 sec)
376
377mysql> OPTIMIZE TABLE staticskyResult;
378+----------------------+----------+----------+----------+
379| Table | Op | Msg_type | Msg_text |
380+----------------------+----------+----------+----------+
381| gpc1.staticskyResult | optimize | status | OK |
382+----------------------+----------+----------+----------+
3831 row in set (0.53 sec)
384
385mysql> OPTIMIZE TABLE staticskyRun;
386+-------------------+----------+----------+----------+
387| Table | Op | Msg_type | Msg_text |
388+-------------------+----------+----------+----------+
389| gpc1.staticskyRun | optimize | status | OK |
390+-------------------+----------+----------+----------+
3911 row in set (0.49 sec)
392
393mysql> OPTIMIZE TABLE summitExp;
394+----------------+----------+----------+----------+
395| Table | Op | Msg_type | Msg_text |
396+----------------+----------+----------+----------+
397| gpc1.summitExp | optimize | status | OK |
398+----------------+----------+----------+----------+
3991 row in set (5.02 sec)
400
401mysql> OPTIMIZE TABLE summitImfile;
402+-------------------+----------+----------+----------+
403| Table | Op | Msg_type | Msg_text |
404+-------------------+----------+----------+----------+
405| gpc1.summitImfile | optimize | status | OK |
406+-------------------+----------+----------+----------+
4071 row in set (5 min 30.26 sec)
408
409mysql> OPTIMIZE TABLE warpBackgroundRun;
410+------------------------+----------+----------+----------+
411| Table | Op | Msg_type | Msg_text |
412+------------------------+----------+----------+----------+
413| gpc1.warpBackgroundRun | optimize | status | OK |
414+------------------------+----------+----------+----------+
4151 row in set (1.05 sec)
416
417mysql> OPTIMIZE TABLE warpBackgroundSkyfile;
418+----------------------------+----------+----------+----------+
419| Table | Op | Msg_type | Msg_text |
420+----------------------------+----------+----------+----------+
421| gpc1.warpBackgroundSkyfile | optimize | status | OK |
422+----------------------------+----------+----------+----------+
4231 row in set (4.51 sec)
424
425mysql> OPTIMIZE TABLE warpImfile;
426+-----------------+----------+----------+----------+
427| Table | Op | Msg_type | Msg_text |
428+-----------------+----------+----------+----------+
429| gpc1.warpImfile | optimize | status | OK |
430+-----------------+----------+----------+----------+
4311 row in set (5 min 19.26 sec)
432
433mysql> OPTIMIZE TABLE warpMask;
434+---------------+----------+----------+----------+
435| Table | Op | Msg_type | Msg_text |
436+---------------+----------+----------+----------+
437| gpc1.warpMask | optimize | status | OK |
438+---------------+----------+----------+----------+
4391 row in set (0.68 sec)
440
441mysql> OPTIMIZE TABLE warpRun;
442+--------------+----------+----------+----------+
443| Table | Op | Msg_type | Msg_text |
444+--------------+----------+----------+----------+
445| gpc1.warpRun | optimize | status | OK |
446+--------------+----------+----------+----------+
4471 row in set (11.45 sec)
448
449mysql> OPTIMIZE TABLE warpSkyCellMap;
450+---------------------+----------+----------+----------+
451| Table | Op | Msg_type | Msg_text |
452+---------------------+----------+----------+----------+
453| gpc1.warpSkyCellMap | optimize | status | OK |
454+---------------------+----------+----------+----------+
4551 row in set (21 min 53.95 sec)
456
457mysql> OPTIMIZE TABLE warpSkyfile;
458+------------------+----------+----------+----------+
459| Table | Op | Msg_type | Msg_text |
460+------------------+----------+----------+----------+
461| gpc1.warpSkyfile | optimize | status | OK |
462+------------------+----------+----------+----------+
4631 row in set (11 min 17.15 sec)
464
465mysql> OPTIMIZE TABLE warpSummary;
466+------------------+----------+----------+----------+
467| Table | Op | Msg_type | Msg_text |
468+------------------+----------+----------+----------+
469| gpc1.warpSummary | optimize | status | OK |
470+------------------+----------+----------+----------+
4711 row in set (4.17 sec)
472