IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

PS1_IPP_CzarLog_20110912: neb_optimization_20110916

File neb_optimization_20110916, 3.1 KB (added by Serge CHASTEL, 15 years ago)
Line 
1OPTIMIZE TABLE cabinet;
2+------------------+----------+----------+----------+
3| Table | Op | Msg_type | Msg_text |
4+------------------+----------+----------+----------+
5| nebulous.cabinet | optimize | status | OK |
6+------------------+----------+----------+----------+
71 row in set (2.39 sec)
8
9OPTIMIZE TABLE deleted;
10+------------------+----------+----------+----------+
11| Table | Op | Msg_type | Msg_text |
12+------------------+----------+----------+----------+
13| nebulous.deleted | optimize | status | OK |
14+------------------+----------+----------+----------+
151 row in set (15.25 sec)
16
17OPTIMIZE TABLE directory;
18+--------------------+----------+----------+----------+
19| Table | Op | Msg_type | Msg_text |
20+--------------------+----------+----------+----------+
21| nebulous.directory | optimize | status | OK |
22+--------------------+----------+----------+----------+
231 row in set (14 min 56.96 sec)
24
25OPTIMIZE TABLE lock_record;
26+----------------------+----------+----------+----------+
27| Table | Op | Msg_type | Msg_text |
28+----------------------+----------+----------+----------+
29| nebulous.lock_record | optimize | status | OK |
30+----------------------+----------+----------+----------+
311 row in set (1.30 sec)
32
33OPTIMIZE TABLE log;
34+--------------+----------+----------+----------+
35| Table | Op | Msg_type | Msg_text |
36+--------------+----------+----------+----------+
37| nebulous.log | optimize | status | OK |
38+--------------+----------+----------+----------+
391 row in set (1.28 sec)
40
41OPTIMIZE TABLE mountedvol;
42+---------------------+----------+----------+----------+
43| Table | Op | Msg_type | Msg_text |
44+---------------------+----------+----------+----------+
45| nebulous.mountedvol | optimize | status | OK |
46+---------------------+----------+----------+----------+
471 row in set (1.33 sec)
48
49OPTIMIZE TABLE volume;
50+-----------------+----------+----------+----------+
51| Table | Op | Msg_type | Msg_text |
52+-----------------+----------+----------+----------+
53| nebulous.volume | optimize | status | OK |
54+-----------------+----------+----------+----------+
551 row in set (1.33 sec)
56
57OPTIMIZE TABLE storage_object_xattr;
58+-------------------------------+----------+----------+----------+
59| Table | Op | Msg_type | Msg_text |
60+-------------------------------+----------+----------+----------+
61| nebulous.storage_object_xattr | optimize | status | OK |
62+-------------------------------+----------+----------+----------+
631 row in set (37 min 55.83 sec)
64
65OPTIMIZE TABLE storage_object_attr;
66+------------------------------+----------+----------+----------+
67| Table | Op | Msg_type | Msg_text |
68+------------------------------+----------+----------+----------+
69| nebulous.storage_object_attr | optimize | status | OK |
70+------------------------------+----------+----------+----------+
711 row in set (1 hour 9 min 55.56 sec)
72
73Not performed:
74OPTIMIZE TABLE storage_object;
75OPTIMIZE TABLE instance;
76