Skip to content

Instantly share code, notes, and snippets.

@srogier

srogier/gist:e769c347fc0e009c898b8d86f8086629

Created September 30, 2016 07:51
Show Gist options
  • Save srogier/e769c347fc0e009c898b8d86f8086629 to your computer and use it in GitHub Desktop.
Save srogier/e769c347fc0e009c898b8d86f8086629 to your computer and use it in GitHub Desktop.
Download ZIP
Optimize sur backup prod
Raw
gistfile1.txt
mysql> optimize table decitre_sales_flat_order;
+----------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_flat_order | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_flat_order | optimize | status | OK |
+----------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (1 min 27.08 sec)
mysql> optimize table decitre_downloadable_link_purchased;
+---------------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_downloadable_link_purchased | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_downloadable_link_purchased | optimize | status | OK |
+---------------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (14.36 sec)
mysql> optimize table decitre_downloadable_link_purchased_item;
+--------------------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+--------------------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_downloadable_link_purchased_item | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_downloadable_link_purchased_item | optimize | status | OK |
+--------------------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (10.82 sec)
mysql> optimize table decitre_sales_billing_agreement_order;
+-----------------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_billing_agreement_order | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_billing_agreement_order | optimize | status | OK |
+-----------------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (0.22 sec)
mysql> optimize table decitre_sales_flat_creditmemo;
+---------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_flat_creditmemo | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_flat_creditmemo | optimize | status | OK |
+---------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (0.34 sec)
mysql> optimize table decitre_sales_flat_creditmemo_comment;
+-----------------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_flat_creditmemo_comment | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_flat_creditmemo_comment | optimize | status | OK |
+-----------------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (0.24 sec)
mysql> optimize table decitre_sales_flat_creditmemo_grid;
+--------------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+--------------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_flat_creditmemo_grid | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_flat_creditmemo_grid | optimize | status | OK |
+--------------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (0.41 sec)
mysql> optimize table decitre_sales_flat_creditmemo_item;
+--------------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+--------------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_flat_creditmemo_item | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_flat_creditmemo_item | optimize | status | OK |
+--------------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (0.35 sec)
mysql> optimize table decitre_sales_flat_invoice;
+------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_flat_invoice | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_flat_invoice | optimize | status | OK |
+------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (9.92 sec)
mysql> optimize table decitre_sales_flat_invoice_comment;
+--------------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+--------------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_flat_invoice_comment | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_flat_invoice_comment | optimize | status | OK |
+--------------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (0.24 sec)
mysql> optimize table decitre_sales_flat_invoice_grid;
+-----------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_flat_invoice_grid | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_flat_invoice_grid | optimize | status | OK |
+-----------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (14.46 sec)
mysql> optimize table decitre_sales_flat_invoice_item;
+-----------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_flat_invoice_item | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_flat_invoice_item | optimize | status | OK |
+-----------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (10.17 sec)
mysql> optimize table decitre_sales_flat_order_address;
+------------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+------------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_flat_order_address | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_flat_order_address | optimize | status | OK |
+------------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (31.96 sec)
mysql> optimize table decitre_sales_flat_order_grid;
+---------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_flat_order_grid | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_flat_order_grid | optimize | status | OK |
+---------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (41.61 sec)
mysql> optimize table decitre_sales_flat_order_item;
+---------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_flat_order_item | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_flat_order_item | optimize | status | OK |
+---------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (1 min 31.77 sec)
mysql> optimize table decitre_downloadable_link_purchased_item;
+--------------------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+--------------------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_downloadable_link_purchased_item | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_downloadable_link_purchased_item | optimize | status | OK |
+--------------------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (8.13 sec)
mysql> optimize table decitre_sales_flat_order_payment;
+------------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+------------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_flat_order_payment | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_flat_order_payment | optimize | status | OK |
+------------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (47.92 sec)
mysql> optimize table decitre_sales_payment_transaction;
+-------------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_payment_transaction | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_payment_transaction | optimize | status | OK |
+-------------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (6.80 sec)
mysql> optimize table decitre_sales_flat_order_status_history;
+-------------------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_flat_order_status_history | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_flat_order_status_history | optimize | status | OK |
+-------------------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (1 min 46.09 sec)
mysql> optimize table decitre_sales_flat_shipment;
+-------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_flat_shipment | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_flat_shipment | optimize | status | OK |
+-------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (12.73 sec)
mysql> optimize table decitre_sales_flat_shipment_comment;
+---------------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_flat_shipment_comment | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_flat_shipment_comment | optimize | status | OK |
+---------------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (0.24 sec)
mysql> optimize table decitre_sales_flat_shipment_grid;
+------------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+------------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_flat_shipment_grid | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_flat_shipment_grid | optimize | status | OK |
+------------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (11.80 sec)
mysql> optimize table decitre_sales_flat_shipment_item;
+------------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+------------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_flat_shipment_item | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_flat_shipment_item | optimize | status | OK |
+------------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (10.32 sec)
mysql> optimize table decitre_sales_flat_shipment_track;
+-------------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_flat_shipment_track | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_flat_shipment_track | optimize | status | OK |
+-------------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (18.52 sec)
mysql> optimize table decitre_sales_payment_transaction;
+-------------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_payment_transaction | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_payment_transaction | optimize | status | OK |
+-------------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (10.09 sec)
mysql> optimize table decitre_sales_recurring_profile_order;
+-----------------------------------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------------------------------------+----------+----------+-------------------------------------------------------------------+
| magento.decitre_sales_recurring_profile_order | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| magento.decitre_sales_recurring_profile_order | optimize | status | OK |
+-----------------------------------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (0.24 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment