This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
/* | |
############################################### | |
WARNING: this script truncates url rewrite tables and generates system url rewrites; | |
ALL CUSTOM URL REWRITES WILL BE DELETED | |
############################################### | |
*/ | |
const BATCH_SIZE = 5; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select 'enterprise_url_rewrite_redirect_cl' as changelog, count(cl.version_id) from `enterprise_url_rewrite_redirect_cl` cl left join enterprise_mview_metadata emm on emm.changelog_name = 'enterprise_url_rewrite_redirect_cl' where cl.version_id > emm.version_id | |
union select 'cataloginventory_stock_status_cl' as changelog, count(cl.version_id) from `cataloginventory_stock_status_cl` cl left join enterprise_mview_metadata emm on emm.changelog_name = 'cataloginventory_stock_status_cl' where cl.version_id > emm.version_id | |
union select 'enterprise_url_rewrite_category_cl' as changelog, count(cl.version_id) from `enterprise_url_rewrite_category_cl` cl left join enterprise_mview_metadata emm on emm.changelog_name = 'enterprise_url_rewrite_category_cl' where cl.version_id > emm.version_id | |
union select 'enterprise_url_rewrite_product_cl' as changelog, count(cl.version_id) from `enterprise_url_rewrite_product_cl` cl left join enterprise_mview_metadata emm on emm.changelog_name = 'enterprise_url_rewrite_product_cl' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT m.metadata_id, m.table_name, m.changelog_name, IF(ccd.value = 1, "On Save", "Scheduled") AS "Mode", m.version_id AS "Processed version", v.version_id AS "Changelog version" | |
, CAST(v.version_id AS SIGNED) - CAST(m.version_id AS SIGNED) AS "Behind" | |
FROM ( | |
(SELECT "enterprise_url_rewrite_redirect_cl" AS changelog_name, "index_management/index_options/redirect_url_rewrite" AS path, version_id FROM enterprise_url_rewrite_redirect_cl ORDER BY version_id DESC LIMIT 1) | |
UNION (SELECT "cataloginventory_stock_status_cl", "index_management/index_options/product_price_and_stock", version_id FROM cataloginventory_stock_status_cl ORDER BY version_id DESC LIMIT 1) | |
UNION (SELECT "catalogsearch_fulltext_cl", "index_management/index_options/fulltext", version_id FROM catalogsearch_fulltext_cl ORDER BY version_id DESC LIMIT 1) | |
UNION (SELECT "enterprise_url_rewrite_category_cl", "index_management/index_options/category_url_rewrite", version_id FROM enterprise_url_rewrite_category_cl ORDER BY version_id DESC LIMIT 1) | |
UNION |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
diff --git a/index.php b/index.php | |
index bec6b29..fdce413 100644 | |
--- a/index.php | |
+++ b/index.php | |
@@ -84,4 +84,46 @@ $mageRunCode = isset($_SERVER['MAGE_RUN_CODE']) ? $_SERVER['MAGE_RUN_CODE'] : '' | |
/* Run store or run website */ | |
$mageRunType = isset($_SERVER['MAGE_RUN_TYPE']) ? $_SERVER['MAGE_RUN_TYPE'] : 'store'; | |
+$totalLoadTimeStart = microtime(true); | |
Mage::run($mageRunCode, $mageRunType); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--- vendor/magento/module-scalable-checkout/etc/di.xml 2016-12-09 07:24:58.000000000 +0200 | |
+++ vendor/magento/module-scalable-checkout/etc/di.xml 2017-02-02 12:08:20.000000000 +0200 | |
@@ -6,9 +6,12 @@ | |
*/ | |
--> | |
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd"> | |
+<!-- | |
<preference for="Magento\Framework\ForeignKey\ConfigInterface" type="Magento\Framework\ForeignKey\Config" /> | |
<preference for="Magento\Framework\ForeignKey\ConstraintInterface" type="\Magento\Framework\ForeignKey\Constraint" /> | |
+--> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--- vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php 2015-10-29 16:34:55.000000000 +0200 | |
+++ vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php 2016-12-29 01:24:41.000000000 +0200 | |
@@ -220,6 +220,23 @@ | |
*/ | |
public function query($sql, $bind = array()) | |
{ | |
+ //DEBUG | |
+ global $allDbQueries; | |
+ $bindJson = $bind ? json_encode($bind) : ''; | |
+ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
diff --git app/etc/di.xml app/etc/di.xml | |
index 69403de..b43d771 100755 | |
--- app/etc/di.xml | |
+++ app/etc/di.xml | |
@@ -93,7 +93,12 @@ | |
<preference for="Magento\Framework\Api\MetadataObjectInterface" type="Magento\Framework\Api\AttributeMetadata"/> | |
<preference for="Magento\Framework\Api\SearchCriteriaInterface" type="Magento\Framework\Api\SearchCriteria"/> | |
<preference for="Magento\Framework\App\Rss\UrlBuilderInterface" type="Magento\Framework\App\Rss\UrlBuilder"/> | |
- <preference for="Magento\Framework\DB\LoggerInterface" type="Magento\Framework\DB\Logger\Quiet"/> | |
+ <preference for="Magento\Framework\DB\LoggerInterface" type="Magento\Framework\DB\Logger\File"/> |