IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

201103_Optimization: log.optimization.nebulous

File log.optimization.nebulous, 4.9 KB (added by Serge CHASTEL, 15 years ago)
Line 
1mysql> OPTIMIZE TABLE cabinet;
2+------------------+----------+----------+----------+
3| Table | Op | Msg_type | Msg_text |
4+------------------+----------+----------+----------+
5| nebulous.cabinet | optimize | status | OK |
6+------------------+----------+----------+----------+
71 row in set (1.50 sec)
8
9mysql> OPTIMIZE TABLE deleted;
10+------------------+----------+----------+----------+
11| Table | Op | Msg_type | Msg_text |
12+------------------+----------+----------+----------+
13| nebulous.deleted | optimize | status | OK |
14+------------------+----------+----------+----------+
151 row in set (1 min 39.04 sec)
16
17mysql> OPTIMIZE TABLE directory;
18+--------------------+----------+----------+----------+
19| Table | Op | Msg_type | Msg_text |
20+--------------------+----------+----------+----------+
21| nebulous.directory | optimize | status | OK |
22+--------------------+----------+----------+----------+
231 row in set (13 min 45.74 sec)
24
25mysql> OPTIMIZE TABLE instance;
26+-------------------+----------+----------+----------+
27| Table | Op | Msg_type | Msg_text |
28+-------------------+----------+----------+----------+
29| nebulous.instance | optimize | status | OK |
30+-------------------+----------+----------+----------+
311 row in set (21 hours 35 min 24.85 sec)
32
33mysql> OPTIMIZE TABLE lock_record;
34+----------------------+----------+----------+----------+
35| Table | Op | Msg_type | Msg_text |
36+----------------------+----------+----------+----------+
37| nebulous.lock_record | optimize | status | OK |
38+----------------------+----------+----------+----------+
391 row in set (0.71 sec)
40
41mysql> OPTIMIZE TABLE log;
42+--------------+----------+----------+----------+
43| Table | Op | Msg_type | Msg_text |
44+--------------+----------+----------+----------+
45| nebulous.log | optimize | status | OK |
46+--------------+----------+----------+----------+
471 row in set (0.66 sec)
48
49mysql> OPTIMIZE TABLE mountedvol;
50+---------------------+----------+----------+----------+
51| Table | Op | Msg_type | Msg_text |
52+---------------------+----------+----------+----------+
53| nebulous.mountedvol | optimize | status | OK |
54+---------------------+----------+----------+----------+
551 row in set (1.02 sec)
56
57mysql> OPTIMIZE TABLE storage_object;
58+-------------------------+----------+----------+----------+
59| Table | Op | Msg_type | Msg_text |
60+-------------------------+----------+----------+----------+
61| nebulous.storage_object | optimize | status | OK |
62+-------------------------+----------+----------+----------+
63
64mysql> OPTIMIZE TABLE storage_object_attr;
65+------------------------------+----------+----------+----------+
66| Table | Op | Msg_type | Msg_text |
67+------------------------------+----------+----------+----------+
68| nebulous.storage_object_attr | optimize | status | OK |
69+------------------------------+----------+----------+----------+
701 row in set (56 min 36.69 sec)
71
72mysql> OPTIMIZE TABLE storage_object_xattr;
73+-------------------------------+----------+----------+----------+
74| Table | Op | Msg_type | Msg_text |
75+-------------------------------+----------+----------+----------+
76| nebulous.storage_object_xattr | optimize | status | OK |
77+-------------------------------+----------+----------+----------+
781 row in set (16 min 6.31 sec)
79
80mysql> OPTIMIZE TABLE volume;
81+-----------------+----------+----------+----------+
82| Table | Op | Msg_type | Msg_text |
83+-----------------+----------+----------+----------+
84| nebulous.volume | optimize | status | OK |
85+-----------------+----------+----------+----------+
861 row in set (0.66 sec)
87
88-------------------------------------------------------------------
89|| || #elements || Size after || Size before ||
90|| Table name || in table || opt.(bytes) || opt.(bytes) ||
91------------------------------------------------------------------
92|| cabinet || 8 || || ||
93|| deleted || 510597 || || ||
94|| directory || 5264597 || || ||
95|| instance || 439024114 || 156091023360 || 204308742144 || -24%
96|| lock_record || 0 || || ||
97|| log || 0 || || ||
98|| mountedvol || 49 || || ||
99|| storage_object || 390559412 || 165691785216 || 204665257984 || -20%
100|| storage_object_attr || 390559412 || || ||
101|| storage_object_xattr || 53272583 || || ||
102|| volume || 52 || || ||
103------------------------------------------------------------------