If you are working with warden setup for Magento 2 local development and your category indexer taking much time to perform indexing. This article is definitely for you to improve the performance of category indexers with the warden.
I am using MariaDB for the warden and it’s taking time to perform category indexer.
You need to set a few database variable configurations in the warden-env.yml file to fix the catalog category indexer speed-up issue:
db: command: - mysqld - --max_allowed_packet=1024M - --explicit_defaults_for_timestamp=on - --optimizer_search_depth=4 - --optimizer_use_condition_selectivity=1 - --optimizer_switch="rowid_filter=off"
After setting the above variables in the env file, You need to stop and restart the warden environment to see the effect on the project.