mage_cataloginventory_stock_status Issue

[KiranBhushan]

Hi,

We have our website built on Magento 1.9CE , for the last few days our website slows down because of high CPU utilization, On checking the process list we found that some action is triggering the alter query on mage_cataloginventory_stock_status thereby resulting in Waiting for table metadata lock state on the same table in case of any select query.

As a result, many processes get stuck and eventually system slows down

Please let us know how to resolve this error, one thing that i would like to mention is 

 database engine in mage_cataloginventory_stock_status table is Innodb.

Regards

Kiran Bhushan

[Sunil Patel]

Hello @KiranBhushan

maybe you change indexer mode to on save?

try to change indexer mode to on schedule and check it

[KiranBhushan]

Hi Sunil,

I am new to magento , can you please let me know where the changes needs to be done as suggested by you.

Regards

Kiran Bhushan

[Sunil Patel]

Hello @KiranBhushan

https://docs.magento.com/m1/ce/user_guide/system-operations/index-modes.html

If helpful then mark as solution.

[KiranBhushan]

Hi Sunil,

 Thanks for the info, one thing that I would like to confirm if the index mode is changed to manual update any product added or updated to reflect on the website will result in manual intervention via admin panel. In the attached doc cron job is also one solution, I believe changing the index mode to the manual is a sort of cron job only, the only difference being it will be triggered manually not automatically.

Regards

Kiran Bhushan

[Sunil Patel · Accepted solution]

Hello @KiranBhushan

yes it is do reindex manually when you change mode to manually.

So solution purpose you can create cron job for that

https://support.cloudways.com/reindexing-magento-data-cron-job/

hope it will help you.

If help you then mark as solution.