Skip to content

Instantly share code, notes, and snippets.

@tegansnyder

tegansnyder/Magento-Indexing-Locks.md

Last active October 18, 2017 15:02
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save tegansnyder/e7c879b66298c5033716 to your computer and use it in GitHub Desktop.
Save tegansnyder/e7c879b66298c5033716 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('db_name_here.reindex_full');
Releasing locks:
SELECT RELEASE_LOCK('db_name_here.reindex_full');
Create a lock:
SELECT GET_LOCK('db_name_here.reindex_full', 5);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment