Skip to content

Instantly share code, notes, and snippets.

@CajuCLC

CajuCLC/Magento-Indexing-Locks.md

Forked from tegansnyder/Magento-Indexing-Locks.md
Last active August 23, 2018 17:35
Show Gist options
  • Save CajuCLC/49c739c8fb4701c5a9293eac8efab203 to your computer and use it in GitHub Desktop.
Save CajuCLC/49c739c8fb4701c5a9293eac8efab203 to your computer and use it in GitHub Desktop.
Download ZIP
Magento EE Indexer Locks
Raw
Magento-Indexing-Locks.md

Here is how we can see if we have MySQL locks due to indexing:

Display locks:
SELECT IS_USED_LOCK('magento.reindex_full');
Releasing locks:
SELECT RELEASE_LOCK('magento.reindex_full');
Create a lock:
SELECT GET_LOCK('magento.reindex_full', 5);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment