Magento SQL Database Table Storage Engine Fixes - Innodb and MyIsam

We’ve had a few problems recently with the way the default Magento installation sets up the table storage engine for the various tables in SQL. Innodb should be used for the majority of tables with a few exceptions. The below SQL fixes the tables to their correct format as recommended by Magento. This works for CE version 1.7.0.2 so a few manual amendments may need to be made for Enterprise or older versions. In theory, this should clear up a lot of the ‘lock’ issues people face when editing products or orders in the admin. MyIsam queues ‘SQL’ and locks the table until a process has been completed. Innodb handles multiple reads and writes much better.

Always backup your SQL before any major updates like the below!

ALTER TABLE `admin_assert` ENGINE=InnoDB; ALTER TABLE `admin_role` ENGINE=InnoDB; ALTER TABLE `admin_rule` ENGINE=InnoDB; ALTER TABLE `admin_user` ENGINE=InnoDB; ALTER TABLE `adminnotification_inbox` ENGINE=InnoDB; ALTER TABLE `api_assert` ENGINE=InnoDB; ALTER TABLE `api_role` ENGINE=InnoDB; ALTER TABLE `api_rule` ENGINE=InnoDB; ALTER TABLE `api_session` ENGINE=InnoDB; ALTER TABLE `api_user` ENGINE=InnoDB; ALTER TABLE `catalog_category_anc_categs_index_idx` ENGINE=InnoDB; ALTER TABLE `catalog_category_anc_categs_index_tmp` ENGINE=InnoDB; ALTER TABLE `catalog_category_anc_products_index_idx` ENGINE=InnoDB; ALTER TABLE `catalog_category_anc_products_index_tmp` ENGINE=InnoDB; ALTER TABLE `catalog_category_entity` ENGINE=InnoDB; ALTER TABLE `catalog_category_entity_datetime` ENGINE=InnoDB; ALTER TABLE `catalog_category_entity_decimal` ENGINE=InnoDB; ALTER TABLE `catalog_category_entity_int` ENGINE=InnoDB; ALTER TABLE `catalog_category_entity_text` ENGINE=InnoDB; ALTER TABLE `catalog_category_entity_varchar` ENGINE=InnoDB; ALTER TABLE `catalog_category_product` ENGINE=InnoDB; ALTER TABLE `catalog_category_product_index` ENGINE=InnoDB; ALTER TABLE `catalog_category_product_index_enbl_idx` ENGINE=InnoDB; ALTER TABLE `catalog_category_product_index_enbl_tmp` ENGINE=InnoDB; ALTER TABLE `catalog_category_product_index_idx` ENGINE=InnoDB; ALTER TABLE `catalog_category_product_index_tmp` ENGINE=InnoDB; ALTER TABLE `catalog_compare_item` ENGINE=InnoDB; ALTER TABLE `catalog_eav_attribute` ENGINE=InnoDB; ALTER TABLE `catalog_product_bundle_option` ENGINE=InnoDB; ALTER TABLE `catalog_product_bundle_option_value` ENGINE=InnoDB; ALTER TABLE `catalog_product_bundle_price_index` ENGINE=InnoDB; ALTER TABLE `catalog_product_bundle_selection` ENGINE=InnoDB; ALTER TABLE `catalog_product_bundle_selection_price` ENGINE=InnoDB; ALTER TABLE `catalog_product_bundle_stock_index` ENGINE=InnoDB; ALTER TABLE `catalog_product_enabled_index` ENGINE=InnoDB; ALTER TABLE `catalog_product_entity` ENGINE=InnoDB; ALTER TABLE `catalog_product_entity_datetime` ENGINE=InnoDB; ALTER TABLE `catalog_product_entity_decimal` ENGINE=InnoDB; ALTER TABLE `catalog_product_entity_gallery` ENGINE=InnoDB; ALTER TABLE `catalog_product_entity_int` ENGINE=InnoDB; ALTER TABLE `catalog_product_entity_media_gallery` ENGINE=InnoDB; ALTER TABLE `catalog_product_entity_media_gallery_value` ENGINE=InnoDB; ALTER TABLE `catalog_product_entity_text` ENGINE=InnoDB; ALTER TABLE `catalog_product_entity_tier_price` ENGINE=InnoDB; ALTER TABLE `catalog_product_entity_varchar` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_eav` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_eav_decimal` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_eav_decimal_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_eav_decimal_tmp` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_eav_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_eav_tmp` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_bundle_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_bundle_opt_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_bundle_opt_tmp` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_bundle_sel_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_bundle_sel_tmp` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_bundle_tmp` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_cfg_opt_agr_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_cfg_opt_agr_tmp` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_cfg_opt_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_cfg_opt_tmp` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_downlod_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_downlod_tmp` ENGINE=MEMORY; ALTER TABLE `catalog_product_index_price_final_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_final_tmp` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_opt_agr_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_opt_agr_tmp` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_opt_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_opt_tmp` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_tmp` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_tier_price` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_website` ENGINE=InnoDB; ALTER TABLE `catalog_product_link` ENGINE=InnoDB; ALTER TABLE `catalog_product_link_attribute` ENGINE=InnoDB; ALTER TABLE `catalog_product_link_attribute_decimal` ENGINE=InnoDB; ALTER TABLE `catalog_product_link_attribute_int` ENGINE=InnoDB; ALTER TABLE `catalog_product_link_attribute_varchar` ENGINE=InnoDB; ALTER TABLE `catalog_product_link_type` ENGINE=InnoDB; ALTER TABLE `catalog_product_option` ENGINE=InnoDB; ALTER TABLE `catalog_product_option_price` ENGINE=InnoDB; ALTER TABLE `catalog_product_option_title` ENGINE=InnoDB; ALTER TABLE `catalog_product_option_type_price` ENGINE=InnoDB; ALTER TABLE `catalog_product_option_type_title` ENGINE=InnoDB; ALTER TABLE `catalog_product_option_type_value` ENGINE=InnoDB; ALTER TABLE `catalog_product_relation` ENGINE=InnoDB; ALTER TABLE `catalog_product_super_attribute` ENGINE=InnoDB; ALTER TABLE `catalog_product_super_attribute_label` ENGINE=InnoDB; ALTER TABLE `catalog_product_super_attribute_pricing` ENGINE=InnoDB; ALTER TABLE `catalog_product_super_link` ENGINE=InnoDB; ALTER TABLE `catalog_product_website` ENGINE=InnoDB; ALTER TABLE `cataloginventory_stock` ENGINE=InnoDB; ALTER TABLE `cataloginventory_stock_item` ENGINE=InnoDB; ALTER TABLE `cataloginventory_stock_status` ENGINE=InnoDB; ALTER TABLE `cataloginventory_stock_status_idx` ENGINE=InnoDB; ALTER TABLE `cataloginventory_stock_status_tmp` ENGINE=InnoDB; ALTER TABLE `catalogrule` ENGINE=InnoDB; ALTER TABLE `catalogrule_affected_product` ENGINE=InnoDB; ALTER TABLE `catalogrule_group_website` ENGINE=InnoDB; ALTER TABLE `catalogrule_product` ENGINE=InnoDB; ALTER TABLE `catalogrule_product_price` ENGINE=InnoDB; ALTER TABLE `catalogsearch_fulltext` ENGINE=MyISAM; ALTER TABLE `catalogsearch_query` ENGINE=InnoDB; ALTER TABLE `catalogsearch_recommendations` ENGINE=InnoDB; ALTER TABLE `catalogsearch_result` ENGINE=InnoDB; ALTER TABLE `checkout_agreement` ENGINE=InnoDB; ALTER TABLE `checkout_agreement_store` ENGINE=InnoDB; ALTER TABLE `cms_block` ENGINE=InnoDB; ALTER TABLE `cms_page_store` ENGINE=InnoDB; ALTER TABLE `core_cache` ENGINE=InnoDB; ALTER TABLE `core_cache_option` ENGINE=InnoDB; ALTER TABLE `core_cache_tag` ENGINE=InnoDB; ALTER TABLE `core_config_data` ENGINE=InnoDB; ALTER TABLE `core_email_template` ENGINE=InnoDB; ALTER TABLE `core_flag` ENGINE=InnoDB; ALTER TABLE `core_layout_link` ENGINE=InnoDB; ALTER TABLE `core_layout_update` ENGINE=InnoDB; ALTER TABLE `core_resource` ENGINE=InnoDB; ALTER TABLE `core_session` ENGINE=InnoDB; ALTER TABLE `core_store` ENGINE=InnoDB; ALTER TABLE `core_store_group` ENGINE=InnoDB; ALTER TABLE `core_translate` ENGINE=InnoDB; ALTER TABLE `core_url_rewrite` ENGINE=InnoDB; ALTER TABLE `core_variable` ENGINE=InnoDB; ALTER TABLE `core_variable_value` ENGINE=InnoDB; ALTER TABLE `core_website` ENGINE=InnoDB; ALTER TABLE `coupon_aggregated` ENGINE=InnoDB; ALTER TABLE `coupon_aggregated_order` ENGINE=InnoDB; ALTER TABLE `coupon_aggregated_updated` ENGINE=InnoDB; ALTER TABLE `cron_schedule` ENGINE=InnoDB; ALTER TABLE `customer_address_entity` ENGINE=InnoDB; ALTER TABLE `customer_address_entity_datetime` ENGINE=InnoDB; ALTER TABLE `customer_address_entity_decimal` ENGINE=InnoDB; ALTER TABLE `customer_address_entity_int` ENGINE=InnoDB; ALTER TABLE `customer_address_entity_text` ENGINE=InnoDB; ALTER TABLE `customer_address_entity_varchar` ENGINE=InnoDB; ALTER TABLE `customer_eav_attribute` ENGINE=InnoDB; ALTER TABLE `customer_eav_attribute_website` ENGINE=InnoDB; ALTER TABLE `customer_entity` ENGINE=InnoDB; ALTER TABLE `customer_entity_datetime` ENGINE=InnoDB; ALTER TABLE `customer_entity_decimal` ENGINE=InnoDB; ALTER TABLE `customer_entity_int` ENGINE=InnoDB; ALTER TABLE `customer_entity_text` ENGINE=InnoDB; ALTER TABLE `customer_entity_varchar` ENGINE=InnoDB; ALTER TABLE `customer_form_attribute` ENGINE=InnoDB; ALTER TABLE `customer_group` ENGINE=InnoDB; ALTER TABLE `dataflow_batch` ENGINE=InnoDB; ALTER TABLE `dataflow_batch_export` ENGINE=InnoDB; ALTER TABLE `dataflow_batch_import` ENGINE=InnoDB; ALTER TABLE `dataflow_import_data` ENGINE=InnoDB; ALTER TABLE `dataflow_profile` ENGINE=InnoDB; ALTER TABLE `dataflow_profile_history` ENGINE=InnoDB; ALTER TABLE `dataflow_session` ENGINE=InnoDB; ALTER TABLE `design_change` ENGINE=InnoDB; ALTER TABLE `directory_country` ENGINE=InnoDB; ALTER TABLE `directory_country_format` ENGINE=InnoDB; ALTER TABLE `directory_country_region` ENGINE=InnoDB; ALTER TABLE `directory_country_region_name` ENGINE=InnoDB; ALTER TABLE `directory_currency_rate` ENGINE=InnoDB; ALTER TABLE `downloadable_link` ENGINE=InnoDB; ALTER TABLE `downloadable_link_price` ENGINE=InnoDB; ALTER TABLE `downloadable_link_purchased` ENGINE=InnoDB; ALTER TABLE `downloadable_link_purchased_item` ENGINE=InnoDB; ALTER TABLE `downloadable_link_title` ENGINE=InnoDB; ALTER TABLE `downloadable_sample` ENGINE=InnoDB; ALTER TABLE `downloadable_sample_title` ENGINE=InnoDB; ALTER TABLE `eav_attribute` ENGINE=InnoDB; ALTER TABLE `eav_attribute_group` ENGINE=InnoDB; ALTER TABLE `eav_attribute_label` ENGINE=InnoDB; ALTER TABLE `eav_attribute_option` ENGINE=InnoDB; ALTER TABLE `eav_attribute_option_value` ENGINE=InnoDB; ALTER TABLE `eav_attribute_set` ENGINE=InnoDB; ALTER TABLE `eav_entity` ENGINE=InnoDB; ALTER TABLE `eav_entity_attribute` ENGINE=InnoDB; ALTER TABLE `eav_entity_datetime` ENGINE=InnoDB; ALTER TABLE `eav_entity_decimal` ENGINE=InnoDB; ALTER TABLE `eav_entity_int` ENGINE=InnoDB; ALTER TABLE `eav_entity_store` ENGINE=InnoDB; ALTER TABLE `eav_entity_text` ENGINE=InnoDB; ALTER TABLE `eav_entity_type` ENGINE=InnoDB; ALTER TABLE `eav_entity_varchar` ENGINE=InnoDB; ALTER TABLE `eav_form_element` ENGINE=InnoDB; ALTER TABLE `eav_form_fieldset` ENGINE=InnoDB; ALTER TABLE `eav_form_fieldset_label` ENGINE=InnoDB; ALTER TABLE `eav_form_type` ENGINE=InnoDB; ALTER TABLE `eav_form_type_entity` ENGINE=InnoDB; ALTER TABLE `gift_message` ENGINE=InnoDB; ALTER TABLE `googlecheckout_notification` ENGINE=InnoDB; ALTER TABLE `importexport_importdata` ENGINE=InnoDB; ALTER TABLE `index_event` ENGINE=InnoDB; ALTER TABLE `index_process` ENGINE=InnoDB; ALTER TABLE `index_process_event` ENGINE=InnoDB; ALTER TABLE `log_customer` ENGINE=MyISAM; ALTER TABLE `log_quote` ENGINE=MyISAM; ALTER TABLE `log_summary` ENGINE=MyISAM; ALTER TABLE `log_summary_type` ENGINE=MyISAM; ALTER TABLE `log_url` ENGINE=MyISAM; ALTER TABLE `log_url_info` ENGINE=MyISAM; ALTER TABLE `log_visitor` ENGINE=MyISAM; ALTER TABLE `log_visitor_info` ENGINE=MyISAM; ALTER TABLE `log_visitor_online` ENGINE=MyISAM; ALTER TABLE `newsletter_problem` ENGINE=InnoDB; ALTER TABLE `newsletter_queue` ENGINE=InnoDB; ALTER TABLE `newsletter_queue_link` ENGINE=InnoDB; ALTER TABLE `newsletter_queue_store_link` ENGINE=InnoDB; ALTER TABLE `newsletter_subscriber` ENGINE=InnoDB; ALTER TABLE `newsletter_template` ENGINE=InnoDB; ALTER TABLE `paypal_cert` ENGINE=InnoDB; ALTER TABLE `paypal_payment_transaction` ENGINE=InnoDB; ALTER TABLE `paypal_settlement_report` ENGINE=InnoDB; ALTER TABLE `paypal_settlement_report_row` ENGINE=InnoDB; ALTER TABLE `persistent_session` ENGINE=InnoDB; ALTER TABLE `poll` ENGINE=InnoDB; ALTER TABLE `poll_answer` ENGINE=InnoDB; ALTER TABLE `poll_store` ENGINE=InnoDB; ALTER TABLE `poll_vote` ENGINE=InnoDB; ALTER TABLE `product_alert_price` ENGINE=MyISAM; ALTER TABLE `product_alert_stock` ENGINE=MyISAM; ALTER TABLE `rating` ENGINE=InnoDB; ALTER TABLE `rating_entity` ENGINE=InnoDB; ALTER TABLE `rating_option` ENGINE=InnoDB; ALTER TABLE `rating_option_vote` ENGINE=InnoDB; ALTER TABLE `rating_option_vote_aggregated` ENGINE=InnoDB; ALTER TABLE `rating_store` ENGINE=InnoDB; ALTER TABLE `rating_title` ENGINE=InnoDB; ALTER TABLE `report_compared_product_index` ENGINE=InnoDB; ALTER TABLE `report_event` ENGINE=InnoDB; ALTER TABLE `report_event_types` ENGINE=InnoDB; ALTER TABLE `report_viewed_product_index` ENGINE=InnoDB; ALTER TABLE `review` ENGINE=InnoDB; ALTER TABLE `review_detail` ENGINE=InnoDB; ALTER TABLE `review_entity` ENGINE=InnoDB; ALTER TABLE `review_entity_summary` ENGINE=InnoDB; ALTER TABLE `review_status` ENGINE=InnoDB; ALTER TABLE `review_store` ENGINE=InnoDB; ALTER TABLE `sales_bestsellers_aggregated_daily` ENGINE=InnoDB; ALTER TABLE `sales_bestsellers_aggregated_monthly` ENGINE=InnoDB; ALTER TABLE `sales_bestsellers_aggregated_yearly` ENGINE=InnoDB; ALTER TABLE `sales_billing_agreement` ENGINE=InnoDB; ALTER TABLE `sales_billing_agreement_order` ENGINE=InnoDB; ALTER TABLE `sales_flat_creditmemo` ENGINE=InnoDB; ALTER TABLE `sales_flat_creditmemo_comment` ENGINE=InnoDB; ALTER TABLE `sales_flat_creditmemo_grid` ENGINE=InnoDB; ALTER TABLE `sales_flat_creditmemo_item` ENGINE=InnoDB; ALTER TABLE `sales_flat_invoice` ENGINE=InnoDB; ALTER TABLE `sales_flat_invoice_comment` ENGINE=InnoDB; ALTER TABLE `sales_flat_invoice_grid` ENGINE=InnoDB; ALTER TABLE `sales_flat_invoice_item` ENGINE=InnoDB; ALTER TABLE `sales_flat_order` ENGINE=InnoDB; ALTER TABLE `sales_flat_order_address` ENGINE=InnoDB; ALTER TABLE `sales_flat_order_grid` ENGINE=InnoDB; ALTER TABLE `sales_flat_order_item` ENGINE=InnoDB; ALTER TABLE `sales_flat_order_payment` ENGINE=InnoDB; ALTER TABLE `sales_flat_order_status_history` ENGINE=InnoDB; ALTER TABLE `sales_flat_quote` ENGINE=InnoDB; ALTER TABLE `sales_flat_quote_address` ENGINE=InnoDB; ALTER TABLE `sales_flat_quote_address_item` ENGINE=InnoDB; ALTER TABLE `sales_flat_quote_item` ENGINE=InnoDB; ALTER TABLE `sales_flat_quote_item_option` ENGINE=InnoDB; ALTER TABLE `sales_flat_quote_payment` ENGINE=InnoDB; ALTER TABLE `sales_flat_quote_shipping_rate` ENGINE=InnoDB; ALTER TABLE `sales_flat_shipment` ENGINE=InnoDB; ALTER TABLE `sales_flat_shipment_comment` ENGINE=InnoDB; ALTER TABLE `sales_flat_shipment_grid` ENGINE=InnoDB; ALTER TABLE `sales_flat_shipment_item` ENGINE=InnoDB; ALTER TABLE `sales_flat_shipment_track` ENGINE=InnoDB; ALTER TABLE `sales_invoiced_aggregated` ENGINE=InnoDB; ALTER TABLE `sales_invoiced_aggregated_order` ENGINE=InnoDB; ALTER TABLE `sales_order_aggregated_created` ENGINE=InnoDB; ALTER TABLE `sales_order_aggregated_updated` ENGINE=InnoDB; ALTER TABLE `sales_order_status` ENGINE=InnoDB; ALTER TABLE `sales_order_status_label` ENGINE=InnoDB; ALTER TABLE `sales_order_status_state` ENGINE=InnoDB; ALTER TABLE `sales_order_tax` ENGINE=InnoDB; ALTER TABLE `sales_order_tax_item` ENGINE=InnoDB; ALTER TABLE `sales_payment_transaction` ENGINE=InnoDB; ALTER TABLE `sales_recurring_profile` ENGINE=InnoDB; ALTER TABLE `sales_recurring_profile_order` ENGINE=InnoDB; ALTER TABLE `sales_refunded_aggregated` ENGINE=InnoDB; ALTER TABLE `sales_refunded_aggregated_order` ENGINE=InnoDB; ALTER TABLE `sales_shipping_aggregated` ENGINE=InnoDB; ALTER TABLE `sales_shipping_aggregated_order` ENGINE=InnoDB; ALTER TABLE `salesrule` ENGINE=InnoDB; ALTER TABLE `salesrule_coupon` ENGINE=InnoDB; ALTER TABLE `salesrule_coupon_usage` ENGINE=InnoDB; ALTER TABLE `salesrule_customer` ENGINE=InnoDB; ALTER TABLE `salesrule_label` ENGINE=InnoDB; ALTER TABLE `salesrule_product_attribute` ENGINE=InnoDB; ALTER TABLE `sendfriend_log` ENGINE=MyISAM; ALTER TABLE `shipping_tablerate` ENGINE=InnoDB; ALTER TABLE `sitemap` ENGINE=InnoDB; ALTER TABLE `tag` ENGINE=InnoDB; ALTER TABLE `tag_properties` ENGINE=InnoDB; ALTER TABLE `tag_relation` ENGINE=InnoDB; ALTER TABLE `tag_summary` ENGINE=InnoDB; ALTER TABLE `tax_calculation` ENGINE=InnoDB; ALTER TABLE `tax_calculation_rate` ENGINE=InnoDB; ALTER TABLE `tax_calculation_rate_title` ENGINE=InnoDB; ALTER TABLE `tax_calculation_rule` ENGINE=InnoDB; ALTER TABLE `tax_class` ENGINE=InnoDB; ALTER TABLE `tax_order_aggregated_created` ENGINE=InnoDB; ALTER TABLE `tax_order_aggregated_updated` ENGINE=InnoDB; ALTER TABLE `weee_discount` ENGINE=InnoDB; ALTER TABLE `weee_tax` ENGINE=InnoDB; ALTER TABLE `widget` ENGINE=InnoDB; ALTER TABLE `widget_instance` ENGINE=InnoDB; ALTER TABLE `widget_instance_page` ENGINE=InnoDB; ALTER TABLE `widget_instance_page_layout` ENGINE=InnoDB; ALTER TABLE `wishlist` ENGINE=InnoDB; ALTER TABLE `wishlist_item` ENGINE=InnoDB; ALTER TABLE `wishlist_item_option` ENGINE=InnoDB; ALTER TABLE `xmlconnect_application` ENGINE=InnoDB; ALTER TABLE `xmlconnect_config_data` ENGINE=InnoDB; ALTER TABLE `xmlconnect_history` ENGINE=InnoDB; ALTER TABLE `xmlconnect_notification_template` ENGINE=InnoDB; ALTER TABLE `xmlconnect_queue` ENGINE=InnoDB;

If you have a multi-store Magento setup like we do for a few clients you will also need to do the below SQL alterations. In the below case we have 12 stores running off the one Magento installation.

ALTER TABLE `catalog_category_flat_store_1` ENGINE=InnoDB; ALTER TABLE `catalog_category_flat_store_2` ENGINE=InnoDB; ALTER TABLE `catalog_category_flat_store_3` ENGINE=InnoDB; ALTER TABLE `catalog_category_flat_store_4` ENGINE=InnoDB; ALTER TABLE `catalog_category_flat_store_5` ENGINE=InnoDB; ALTER TABLE `catalog_category_flat_store_6` ENGINE=InnoDB; ALTER TABLE `catalog_category_flat_store_7` ENGINE=InnoDB; ALTER TABLE `catalog_category_flat_store_8` ENGINE=InnoDB; ALTER TABLE `catalog_category_flat_store_9` ENGINE=InnoDB; ALTER TABLE `catalog_category_flat_store_10` ENGINE=InnoDB; ALTER TABLE `catalog_category_flat_store_11` ENGINE=InnoDB; ALTER TABLE `catalog_category_flat_store_12` ENGINE=InnoDB; ALTER TABLE `catalog_product_flat_1` ENGINE=InnoDB; ALTER TABLE `catalog_product_flat_2` ENGINE=InnoDB; ALTER TABLE `catalog_product_flat_3` ENGINE=InnoDB; ALTER TABLE `catalog_product_flat_4` ENGINE=InnoDB; ALTER TABLE `catalog_product_flat_5` ENGINE=InnoDB; ALTER TABLE `catalog_product_flat_6` ENGINE=InnoDB; ALTER TABLE `catalog_product_flat_7` ENGINE=InnoDB; ALTER TABLE `catalog_product_flat_8` ENGINE=InnoDB; ALTER TABLE `catalog_product_flat_9` ENGINE=InnoDB; ALTER TABLE `catalog_product_flat_10` ENGINE=InnoDB; ALTER TABLE `catalog_product_flat_11` ENGINE=InnoDB; ALTER TABLE `catalog_product_flat_12` ENGINE=InnoDB;

Magento SQL Database Table Storage Engine Fixes – Innodb and MyIsam

Work with Us

Trusted by...