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: