IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 1 and Version 2 of 201103_Optimization


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

--

Legend:

Unmodified
Added
Removed
Modified

  • 201103_Optimization

    v1 v2  
     1I'm detailing here the optimization performed on the Nebulous and gpc1 databases in march 2011.
     2
    13= Nebulous Optimization =
    24 * Run as ipp on ippdb00 within a screen session
    35 * Each table was optimized one after the other
     6   See attached log file: log.nebulous.optimization
     7 * Size variation (unfortunately I didn't record all the tables):
     8-------------------------------------------------------------------
     9|                      | #elements |  Size after  |  Size before |
     10| Table name           | in table  |  opt.(bytes) |  opt.(bytes) |
     11------------------------------------------------------------------
     12| cabinet              |         8 |              |              |
     13| deleted              |    510597 |              |              |
     14| directory            |   5264597 |              |              |
     15| instance             | 439024114 | 156091023360 | 204308742144 | -24%
     16| lock_record          |         0 |              |              |
     17| log                  |         0 |              |              |
     18| mountedvol           |        49 |              |              |
     19| storage_object       | 390559412 | 165691785216 | 204665257984 | -20%
     20| storage_object_attr  | 390559412 |              |              |
     21| storage_object_xattr |  53272583 |              |              |
     22| volume               |        52 |              |              |
     23------------------------------------------------------------------
    424
    5 {{{
    6 mysql> OPTIMIZE TABLE cabinet;
    7 +------------------+----------+----------+----------+
    8 | Table            | Op       | Msg_type | Msg_text |
    9 +------------------+----------+----------+----------+
    10 | nebulous.cabinet | optimize | status   | OK       |
    11 +------------------+----------+----------+----------+
    12 1 row in set (1.50 sec)
    13 
    14 mysql> OPTIMIZE TABLE deleted;
    15 +------------------+----------+----------+----------+
    16 | Table            | Op       | Msg_type | Msg_text |
    17 +------------------+----------+----------+----------+
    18 | nebulous.deleted | optimize | status   | OK       |
    19 +------------------+----------+----------+----------+
    20 1 row in set (1 min 39.04 sec)
    21 
    22 mysql> OPTIMIZE TABLE directory;
    23 +--------------------+----------+----------+----------+
    24 | Table              | Op       | Msg_type | Msg_text |
    25 +--------------------+----------+----------+----------+
    26 | nebulous.directory | optimize | status   | OK       |
    27 +--------------------+----------+----------+----------+
    28 1 row in set (13 min 45.74 sec)
    29 
    30 mysql> OPTIMIZE TABLE instance;
    31 +-------------------+----------+----------+----------+
    32 | Table             | Op       | Msg_type | Msg_text |
    33 +-------------------+----------+----------+----------+
    34 | nebulous.instance | optimize | status   | OK       |
    35 +-------------------+----------+----------+----------+
    36 1 row in set (21 hours 35 min 24.85 sec)
    37 
    38 mysql> OPTIMIZE TABLE lock_record;
    39 +----------------------+----------+----------+----------+
    40 | Table                | Op       | Msg_type | Msg_text |
    41 +----------------------+----------+----------+----------+
    42 | nebulous.lock_record | optimize | status   | OK       |
    43 +----------------------+----------+----------+----------+
    44 1 row in set (0.71 sec)
    45 
    46 mysql> OPTIMIZE TABLE log;
    47 +--------------+----------+----------+----------+
    48 | Table        | Op       | Msg_type | Msg_text |
    49 +--------------+----------+----------+----------+
    50 | nebulous.log | optimize | status   | OK       |
    51 +--------------+----------+----------+----------+
    52 1 row in set (0.66 sec)
    53 
    54 mysql> OPTIMIZE TABLE mountedvol;
    55 +---------------------+----------+----------+----------+
    56 | Table               | Op       | Msg_type | Msg_text |
    57 +---------------------+----------+----------+----------+
    58 | nebulous.mountedvol | optimize | status   | OK       |
    59 +---------------------+----------+----------+----------+
    60 1 row in set (1.02 sec)
    61 
    62 mysql> OPTIMIZE TABLE storage_object;
    63 +-------------------------+----------+----------+----------+
    64 | Table                   | Op       | Msg_type | Msg_text |
    65 +-------------------------+----------+----------+----------+
    66 | nebulous.storage_object | optimize | status   | OK       |
    67 +-------------------------+----------+----------+----------+
    68 1 row in set (5 hours 30 min 21.45 sec)
    69 
    70 mysql> OPTIMIZE TABLE storage_object_attr;
    71 +------------------------------+----------+----------+----------+
    72 | Table                        | Op       | Msg_type | Msg_text |
    73 +------------------------------+----------+----------+----------+
    74 | nebulous.storage_object_attr | optimize | status   | OK       |
    75 +------------------------------+----------+----------+----------+
    76 1 row in set (56 min 36.69 sec)
    77 
    78 mysql> OPTIMIZE TABLE storage_object_xattr;
    79 +-------------------------+----------+----------+----------+
    80 | Table                   | Op       | Msg_type | Msg_text |
    81 +-------------------------+----------+----------+----------+
    82 | nebulous.storage_object | optimize | status   | OK       |
    83 +-------------------------+----------+----------+----------+
    84 1 row in set (5 hours 30 min 21.45 sec)
    85 
    86 mysql> OPTIMIZE TABLE storage_object_attr;
    87 +------------------------------+----------+----------+----------+
    88 | Table                        | Op       | Msg_type | Msg_text |
    89 +------------------------------+----------+----------+----------+
    90 | nebulous.storage_object_attr | optimize | status   | OK       |
    91 +------------------------------+----------+----------+----------+
    92 1 row in set (56 min 36.69 sec)
    93 
    94 mysql> OPTIMIZE TABLE storage_object_xattr;
    95 +-------------------------------+----------+----------+----------+
    96 | Table                         | Op       | Msg_type | Msg_text |
    97 +-------------------------------+----------+----------+----------+
    98 | nebulous.storage_object_xattr | optimize | status   | OK       |
    99 +-------------------------------+----------+----------+----------+
    100 1 row in set (16 min 6.31 sec)
    101 
    102 mysql> OPTIMIZE TABLE volume;
    103 +-----------------+----------+----------+----------+
    104 | Table           | Op       | Msg_type | Msg_text |
    105 +-----------------+----------+----------+----------+
    106 | nebulous.volume | optimize | status   | OK       |
    107 +-----------------+----------+----------+----------+
    108 1 row in set (0.66 sec)
    109 }}}
    110 
     25= GPC1 Optimization =
    11126 *