My indexer:reindex process for Design config grid, Customer Grid, and Catalog Search always stuck at processing:

enter image description here

i already reset the indexer, but when i run indexer:reindex again, it stucks at processing

php bin/magento indexer:reset

and the same goes when i try to invalid the indexer from db

update indexer_state set status = 'invalid'
  • How much data you have in your system? Jan 28, 2019 at 7:58
  • @SukumarGorai what data?
    – Hunter
    Jan 28, 2019 at 7:58
  • Orders, customers, products etc are data. Jan 28, 2019 at 7:59
  • @SukumarGorai 8789 products , 2139 orders, 769 customers
    – Hunter
    Jan 28, 2019 at 8:05
  • have you tried reindexing after reset?
    – fmsthird
    Jan 28, 2019 at 8:05

3 Answers 3


Check if you have any cron running every minute and if it relates with those reindexes . If any of crons is related to those indexer that are running , try to increase the time of the cron for those , and test again. Are you running on a Magento 2 Enterprice or Community ?

Try to increase Schedule Ahead for option and then run php bin/magento cron:run --group=index enter image description here


When i inspect mysql process from SHOW PROCESSLIST; at mysql terminal, turns out there are too many lock on my magento 2 database

in order to fix this i need to stop and then start mysql again:

service mysqld stop
service mysqld start 

In case you're using MariaDB, you should check Magento's recommendation: here

Reindexing on MariaDB 10.4 and 10.6 takes more time compared to previous MariaDB or MySQL versions. To speed up reindexing, we recommend setting these MariaDB configuration parameters:


optimizer_use_condition_selectivity = 1

Access to your database and set configuration:

set global optimizer_switch='rowid_filter=off';
set global optimizer_use_condition_selectivity = 1;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.