aabumuslimov

(SELECT "DB Total" AS "Table",
ROUND(SUM(data_length) / 1048576) AS "Data",
ROUND(SUM(index_length) / 1048576) AS "Index",
ROUND(SUM(data_length + index_length) / 1048576) AS "Total"
FROM information_schema.TABLES 
WHERE table_schema = "7523")
UNION ALL
(SELECT
 table_name,
 IF(data_length > 0 AND data_length < 104857.6, 0.1, ROUND(data_length / 1048576, 1)),

aabumuslimov

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