Questions tagged [mview]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
25 views

How to relate an entity type to an entity_id within an indexer's mview changelog?

I am trying to contribute to some performance enhancements on the indexing of my website. I'm having an issue knowing which entity types are being referred to in the changelog (*_cl) tables. As a ...
0
votes
0answers
11 views

Update on Schedule execute indexer multiple time

I have created a custom indexer in my project and configured it to work on 'Update on Schedule'. It is working fine but I have observed, it is executed multiple times even if there is no change in the ...
1
vote
1answer
81 views

How to call Magento2 mview reindexer programmatically

I have line of code which schedule full or partial reindex cron job. using Trigger::REINDEX_SCOPE_PARTIAL and Trigger::REINDEX_SCOPE_FULL parameter. public function restoreIndexers($reindex = false, ...
5
votes
2answers
1k views

Deleting values from `_cl` tables

This is a 2 part question. Main question: How risky is to delete the records from the *_cl tables (cataloginventory_stock_cl, catalog_product_attribute_cl, ...) where the version_id field is lower ...
2
votes
1answer
463 views

Remove trigger creation when changing an indexer mode

I've disabled the Magento_Bundle module because I don't need it. But now when I try to set the catalogsearch_fulltext index to schedule via cli: php bin/magento indexer:set-mode schedule ...
33
votes
3answers
12k views

what is mview in magento2?

First of all what i know : Index management is useful for increasing store performance. EAV has one disadvantage.it will store data into different tables.so that retrieving data is time consuming. ...
7
votes
2answers
2k views

Custom indexer on Magento2

I'm trying to create a custom indexer on Magento2. I defined a mview.xml and one indexer.xml as follows: indexer.xml: <?xml version="1.0" encoding="UTF-8"?> <config xmlns:xsi="http://www....