title: Magento Indexing locks tables
body: <p>I am having issues while indexing in running on Magento EE 1.12. Some of the tables are locked during indexing and customers are unable to complete the order. They receive SQL error when submitting their orders. </p>
  
  <p>Indexing is also taking too long. </p>
  
  <p>Any ideas?</p>
  
  <p>Steve</p>