Nebulous Optimization

• Run as ipp on ippdb00 within a screen session
• Each table was optimized one after the other

mysql> OPTIMIZE TABLE cabinet;
+------------------+----------+----------+----------+
| Table            | Op       | Msg_type | Msg_text |
+------------------+----------+----------+----------+
| nebulous.cabinet | optimize | status   | OK       | 
+------------------+----------+----------+----------+
1 row in set (1.50 sec)

mysql> OPTIMIZE TABLE deleted;
+------------------+----------+----------+----------+
| Table            | Op       | Msg_type | Msg_text |
+------------------+----------+----------+----------+
| nebulous.deleted | optimize | status   | OK       | 
+------------------+----------+----------+----------+
1 row in set (1 min 39.04 sec)

mysql> OPTIMIZE TABLE directory;
+--------------------+----------+----------+----------+
| Table              | Op       | Msg_type | Msg_text |
+--------------------+----------+----------+----------+
| nebulous.directory | optimize | status   | OK       | 
+--------------------+----------+----------+----------+
1 row in set (13 min 45.74 sec)

mysql> OPTIMIZE TABLE instance;
+-------------------+----------+----------+----------+
| Table             | Op       | Msg_type | Msg_text |
+-------------------+----------+----------+----------+
| nebulous.instance | optimize | status   | OK       | 
+-------------------+----------+----------+----------+
1 row in set (21 hours 35 min 24.85 sec)

mysql> OPTIMIZE TABLE lock_record;
+----------------------+----------+----------+----------+
| Table                | Op       | Msg_type | Msg_text |
+----------------------+----------+----------+----------+
| nebulous.lock_record | optimize | status   | OK       | 
+----------------------+----------+----------+----------+
1 row in set (0.71 sec)

mysql> OPTIMIZE TABLE log;
+--------------+----------+----------+----------+
| Table        | Op       | Msg_type | Msg_text |
+--------------+----------+----------+----------+
| nebulous.log | optimize | status   | OK       | 
+--------------+----------+----------+----------+
1 row in set (0.66 sec)

mysql> OPTIMIZE TABLE mountedvol;
+---------------------+----------+----------+----------+
| Table               | Op       | Msg_type | Msg_text |
+---------------------+----------+----------+----------+
| nebulous.mountedvol | optimize | status   | OK       | 
+---------------------+----------+----------+----------+
1 row in set (1.02 sec)

mysql> OPTIMIZE TABLE storage_object;
+-------------------------+----------+----------+----------+
| Table                   | Op       | Msg_type | Msg_text |
+-------------------------+----------+----------+----------+
| nebulous.storage_object | optimize | status   | OK       |
+-------------------------+----------+----------+----------+
1 row in set (5 hours 30 min 21.45 sec)

mysql> OPTIMIZE TABLE storage_object_attr;
+------------------------------+----------+----------+----------+
| Table                        | Op       | Msg_type | Msg_text |
+------------------------------+----------+----------+----------+
| nebulous.storage_object_attr | optimize | status   | OK       |
+------------------------------+----------+----------+----------+
1 row in set (56 min 36.69 sec)

mysql> OPTIMIZE TABLE storage_object_xattr;
+-------------------------+----------+----------+----------+
| Table                   | Op       | Msg_type | Msg_text |
+-------------------------+----------+----------+----------+
| nebulous.storage_object | optimize | status   | OK       |
+-------------------------+----------+----------+----------+
1 row in set (5 hours 30 min 21.45 sec)

mysql> OPTIMIZE TABLE storage_object_attr;
+------------------------------+----------+----------+----------+
| Table                        | Op       | Msg_type | Msg_text |
+------------------------------+----------+----------+----------+
| nebulous.storage_object_attr | optimize | status   | OK       |
+------------------------------+----------+----------+----------+
1 row in set (56 min 36.69 sec)

mysql> OPTIMIZE TABLE storage_object_xattr;
+-------------------------------+----------+----------+----------+
| Table                         | Op       | Msg_type | Msg_text |
+-------------------------------+----------+----------+----------+
| nebulous.storage_object_xattr | optimize | status   | OK       |
+-------------------------------+----------+----------+----------+
1 row in set (16 min 6.31 sec)

mysql> OPTIMIZE TABLE volume;
+-----------------+----------+----------+----------+
| Table           | Op       | Msg_type | Msg_text |
+-----------------+----------+----------+----------+
| nebulous.volume | optimize | status   | OK       |
+-----------------+----------+----------+----------+
1 row in set (0.66 sec)