Magento Version : 2.1.9
Total Products : 18k
Total Customers : 55k
I ran re-indexing using CLI in magento 2.1.9 and during catalog_category_product re-indexing i see this error into "Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction" var/log/exception.log.
so, if anyone know than please suggest me how can i fix that and how can i fast indexing using CLI