Skip to content

Instantly share code, notes, and snippets.

View mclevenger's full-sized avatar

Mark Clevenger mclevenger

View GitHub Profile
@mclevenger
mclevenger / Repairdb_after_run.txt
Created November 26, 2012 20:25
Magento Repairdb.php results before/after repair ran on old.dev Mage version 1.12.02
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
@mclevenger
mclevenger / Pdo.php
Created November 22, 2012 17:44
Magento/Zend override for addressing pdo deadlock issue
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
mclevenger / Abstract.php
Created November 22, 2012 05:36
Magento Overrride with patch for fixing the db deadlock error issue
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
/**