mclevenger

Magento Overrride with patch for fixing the db deadlock error issue

FILE PATH:

/var/www/dev.linentablecloth.com/app/code/local/Mage/Sales/Model/Abstract.php

SOURCE CODE:

<?php
/**

mclevenger

Magento/Zend override for addressing pdo deadlock issue 

(we are not sure about the safety and effectiveness of this fix) 

FILE PATH:

app/code/local/Zend/Db/Statement/Pdo.php


<?php

mclevenger

ACTUALLY I USED THE WRONG DATABASE AS A REFERENCE ON THIS ONE

Change storage engine type on table "catalog_category_anc_categs_index_tmp" from MEMORY to INNODB
Change storage engine type on table "catalog_category_anc_products_index_tmp" from MEMORY to INNODB
Change storage engine type on table "catalog_category_product_index_enbl_tmp" from MEMORY to INNODB
Change storage engine type on table "catalog_category_product_index_tmp" from MEMORY to INNODB
Change storage engine type on table "catalog_product_index_eav_decimal_tmp" from MEMORY to INNODB
Change storage engine type on table "catalog_product_index_eav_tmp" from MEMORY to INNODB
Change storage engine type on table "catalog_product_index_price_bundle_opt_tmp" from MEMORY to INNODB
Change storage engine type on table "catalog_product_index_price_bundle_sel_tmp" from MEMORY to INNODB