ydenyshchenk

<?php
/*
###############################################
WARNING: this script truncates url rewrite tables and generates system url rewrites;
ALL CUSTOM URL REWRITES WILL BE DELETED
###############################################
*/

const BATCH_SIZE = 5;

ydenyshchenk

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' 

ydenyshchenk

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 

ydenyshchenk

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);

ydenyshchenk

--- 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" />
+-->

ydenyshchenk

--- 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) : '';
+

ydenyshchenk

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"/>