By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
| version() |
|---|
| 10.5.17-MariaDB-1:10.5.17+maria~deb11 |
create table mview_state
(
state_id int unsigned auto_increment comment 'View State ID'
primary key,
view_id varchar(255) null comment 'View ID',
mode varchar(16) default 'disabled' null comment 'View Mode',
status varchar(16) default 'idle' null comment 'View Status',
updated datetime null comment 'View updated time',
version_id int unsigned null comment 'View Version ID'
)
comment 'View State';
create index MVIEW_STATE_MODE
on mview_state (mode);
create index MVIEW_STATE_VIEW_ID
on mview_state (view_id);
Records: 0 Duplicates: 0 Warnings: 0
Records: 0 Duplicates: 0 Warnings: 0
SHOW GRANTS;
| Grants for root@localhost |
|---|
| GRANT ALL PRIVILEGES ON *.* TO `root`@`localhost` IDENTIFIED VIA mysql_native_password USING 'invalid' OR unix_socket WITH GRANT OPTION |
| GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION |
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (1, 'design_config_dummy', 'enabled', 'idle', '2021-06-29 22:30:05', 0);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (2, 'customer_dummy', 'disabled', 'idle', '2021-03-03 12:06:23', 0);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (3, 'catalog_category_product', 'enabled', 'idle', '2021-06-29 22:30:05', 461);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (4, 'catalog_product_category', 'enabled', 'idle', '2021-06-29 22:29:03', 98015);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (5, 'catalogrule_rule', 'enabled', 'idle', '2021-06-29 22:30:05', 0);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (6, 'catalog_product_attribute', 'enabled', 'idle', '2021-06-29 22:30:05', 2310051);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (7, 'cataloginventory_stock', 'enabled', 'idle', '2021-06-29 22:30:05', 90478);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (8, 'inventory', 'enabled', 'idle', '2021-06-29 22:30:05', 271476);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (9, 'catalogrule_product', 'enabled', 'idle', '2021-06-29 22:29:03', 2505904);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (10, 'catalog_product_price', 'enabled', 'working', '2021-06-29 22:30:05', 56676992);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (11, 'amasty_xsearch_category_fulltext', 'enabled', 'idle', '2021-06-29 22:29:03', 54687);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (12, 'catalogsearch_fulltext', 'enabled', 'idle', '2021-06-29 22:29:03', 2547077);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (33, 'amasty_mostviewed_rule_product', 'enabled', 'idle', '2021-06-29 22:29:03', 2);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (34, 'amasty_mostviewed_product_rule', 'enabled', 'idle', '2021-06-29 22:29:03', 17980739);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (35, 'amasty_sorting_bestseller', 'enabled', 'idle', '2021-06-29 22:29:03', 0);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (36, 'amasty_sorting_most_viewed', 'enabled', 'idle', '2021-06-29 22:29:03', 0);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (37, 'amasty_sorting_wished', 'enabled', 'idle', '2021-06-29 22:29:03', 0);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (38, 'amasty_yotpo_review', 'enabled', 'idle', '2021-06-29 22:30:16', 0);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (43, 'amasty_elastic_relevance_rule_rule', 'enabled', 'idle', '2021-06-29 22:29:03', 0);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (44, 'amasty_elastic_relevance_rule_product', 'enabled', 'idle', '2021-06-29 22:29:03', 18507058);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (45, 'amasty_elastic_popup_data', 'enabled', 'idle', '2021-06-29 22:29:03', 0);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (46, 'amasty_xlanding_product_page', 'enabled', 'idle', '2021-06-29 22:29:03', 13596598);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (47, 'amasty_xlanding_page_product', 'enabled', 'idle', '2021-06-29 22:29:03', 0);
INSERT INTO mview_state (state_id, view_id, mode, status, updated, version_id) VALUES (48, 'merchandiser_product_attribute', 'enabled', 'idle', '2021-06-29 22:29:03', 3027849);
select * from mview_state;
| state_id | view_id | mode | status | updated | version_id |
|---|---|---|---|---|---|
| 1 | design_config_dummy | enabled | idle | 2021-06-29 22:30:05 | 0 |
| 2 | customer_dummy | disabled | idle | 2021-03-03 12:06:23 | 0 |
| 3 | catalog_category_product | enabled | idle | 2021-06-29 22:30:05 | 461 |
| 4 | catalog_product_category | enabled | idle | 2021-06-29 22:29:03 | 98015 |
| 5 | catalogrule_rule | enabled | idle | 2021-06-29 22:30:05 | 0 |
| 6 | catalog_product_attribute | enabled | idle | 2021-06-29 22:30:05 | 2310051 |
| 7 | cataloginventory_stock | enabled | idle | 2021-06-29 22:30:05 | 90478 |
| 8 | inventory | enabled | idle | 2021-06-29 22:30:05 | 271476 |
| 9 | catalogrule_product | enabled | idle | 2021-06-29 22:29:03 | 2505904 |
| 10 | catalog_product_price | enabled | working | 2021-06-29 22:30:05 | 56676992 |
| 11 | amasty_xsearch_category_fulltext | enabled | idle | 2021-06-29 22:29:03 | 54687 |
| 12 | catalogsearch_fulltext | enabled | idle | 2021-06-29 22:29:03 | 2547077 |
| 33 | amasty_mostviewed_rule_product | enabled | idle | 2021-06-29 22:29:03 | 2 |
| 34 | amasty_mostviewed_product_rule | enabled | idle | 2021-06-29 22:29:03 | 17980739 |
| 35 | amasty_sorting_bestseller | enabled | idle | 2021-06-29 22:29:03 | 0 |
| 36 | amasty_sorting_most_viewed | enabled | idle | 2021-06-29 22:29:03 | 0 |
| 37 | amasty_sorting_wished | enabled | idle | 2021-06-29 22:29:03 | 0 |
| 38 | amasty_yotpo_review | enabled | idle | 2021-06-29 22:30:16 | 0 |
| 43 | amasty_elastic_relevance_rule_rule | enabled | idle | 2021-06-29 22:29:03 | 0 |
| 44 | amasty_elastic_relevance_rule_product | enabled | idle | 2021-06-29 22:29:03 | 18507058 |
| 45 | amasty_elastic_popup_data | enabled | idle | 2021-06-29 22:29:03 | 0 |
| 46 | amasty_xlanding_product_page | enabled | idle | 2021-06-29 22:29:03 | 13596598 |
| 47 | amasty_xlanding_page_product | enabled | idle | 2021-06-29 22:29:03 | 0 |
| 48 | merchandiser_product_attribute | enabled | idle | 2021-06-29 22:29:03 | 3027849 |