IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Initial Version and Version 1 of 201103_Optimization


Ignore:
Timestamp:
Mar 4, 2011, 2:24:04 PM (15 years ago)
Author:
Serge CHASTEL
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • 201103_Optimization

    v1 v1  
     1= Nebulous Optimization =
     2 * Run as ipp on ippdb00 within a screen session
     3 * Each table was optimized one after the other
     4
     5{{{
     6mysql> OPTIMIZE TABLE cabinet;
     7+------------------+----------+----------+----------+
     8| Table            | Op       | Msg_type | Msg_text |
     9+------------------+----------+----------+----------+
     10| nebulous.cabinet | optimize | status   | OK       |
     11+------------------+----------+----------+----------+
     121 row in set (1.50 sec)
     13
     14mysql> OPTIMIZE TABLE deleted;
     15+------------------+----------+----------+----------+
     16| Table            | Op       | Msg_type | Msg_text |
     17+------------------+----------+----------+----------+
     18| nebulous.deleted | optimize | status   | OK       |
     19+------------------+----------+----------+----------+
     201 row in set (1 min 39.04 sec)
     21
     22mysql> OPTIMIZE TABLE directory;
     23+--------------------+----------+----------+----------+
     24| Table              | Op       | Msg_type | Msg_text |
     25+--------------------+----------+----------+----------+
     26| nebulous.directory | optimize | status   | OK       |
     27+--------------------+----------+----------+----------+
     281 row in set (13 min 45.74 sec)
     29
     30mysql> OPTIMIZE TABLE instance;
     31+-------------------+----------+----------+----------+
     32| Table             | Op       | Msg_type | Msg_text |
     33+-------------------+----------+----------+----------+
     34| nebulous.instance | optimize | status   | OK       |
     35+-------------------+----------+----------+----------+
     361 row in set (21 hours 35 min 24.85 sec)
     37
     38mysql> OPTIMIZE TABLE lock_record;
     39+----------------------+----------+----------+----------+
     40| Table                | Op       | Msg_type | Msg_text |
     41+----------------------+----------+----------+----------+
     42| nebulous.lock_record | optimize | status   | OK       |
     43+----------------------+----------+----------+----------+
     441 row in set (0.71 sec)
     45
     46mysql> OPTIMIZE TABLE log;
     47+--------------+----------+----------+----------+
     48| Table        | Op       | Msg_type | Msg_text |
     49+--------------+----------+----------+----------+
     50| nebulous.log | optimize | status   | OK       |
     51+--------------+----------+----------+----------+
     521 row in set (0.66 sec)
     53
     54mysql> OPTIMIZE TABLE mountedvol;
     55+---------------------+----------+----------+----------+
     56| Table               | Op       | Msg_type | Msg_text |
     57+---------------------+----------+----------+----------+
     58| nebulous.mountedvol | optimize | status   | OK       |
     59+---------------------+----------+----------+----------+
     601 row in set (1.02 sec)
     61
     62mysql> OPTIMIZE TABLE storage_object;
     63+-------------------------+----------+----------+----------+
     64| Table                   | Op       | Msg_type | Msg_text |
     65+-------------------------+----------+----------+----------+
     66| nebulous.storage_object | optimize | status   | OK       |
     67+-------------------------+----------+----------+----------+
     681 row in set (5 hours 30 min 21.45 sec)
     69
     70mysql> OPTIMIZE TABLE storage_object_attr;
     71+------------------------------+----------+----------+----------+
     72| Table                        | Op       | Msg_type | Msg_text |
     73+------------------------------+----------+----------+----------+
     74| nebulous.storage_object_attr | optimize | status   | OK       |
     75+------------------------------+----------+----------+----------+
     761 row in set (56 min 36.69 sec)
     77
     78mysql> OPTIMIZE TABLE storage_object_xattr;
     79+-------------------------+----------+----------+----------+
     80| Table                   | Op       | Msg_type | Msg_text |
     81+-------------------------+----------+----------+----------+
     82| nebulous.storage_object | optimize | status   | OK       |
     83+-------------------------+----------+----------+----------+
     841 row in set (5 hours 30 min 21.45 sec)
     85
     86mysql> OPTIMIZE TABLE storage_object_attr;
     87+------------------------------+----------+----------+----------+
     88| Table                        | Op       | Msg_type | Msg_text |
     89+------------------------------+----------+----------+----------+
     90| nebulous.storage_object_attr | optimize | status   | OK       |
     91+------------------------------+----------+----------+----------+
     921 row in set (56 min 36.69 sec)
     93
     94mysql> OPTIMIZE TABLE storage_object_xattr;
     95+-------------------------------+----------+----------+----------+
     96| Table                         | Op       | Msg_type | Msg_text |
     97+-------------------------------+----------+----------+----------+
     98| nebulous.storage_object_xattr | optimize | status   | OK       |
     99+-------------------------------+----------+----------+----------+
     1001 row in set (16 min 6.31 sec)
     101
     102mysql> OPTIMIZE TABLE volume;
     103+-----------------+----------+----------+----------+
     104| Table           | Op       | Msg_type | Msg_text |
     105+-----------------+----------+----------+----------+
     106| nebulous.volume | optimize | status   | OK       |
     107+-----------------+----------+----------+----------+
     1081 row in set (0.66 sec)
     109}}}
     110
     111 *