Magento reindexing.

Question

When I re-index the directory search index from the backend and at the same time, if my third-party users are looking for something with search in mysite, I get errors like

Error: SQLSTATE [HY000]: general error: 1205 Latency timed out waiting for lock; try restarting the transaction

please someone tell me how to overcome this problem.

Answer 1

This is a Magento bug that exists with Magento 1.7.

When overriding the catalogsearch_fulltext index, a transaction begins, which performs the following actions for each store in a row:

• Rebuild table catalogsearch_fulltext
• Reset : catalogsearch_query ( is_processed 0) catalogsearch_result

catalogsearch_query ( catalogsearch_query catalogsearch_result). , .

Magento Bug: http://www.magentocommerce.com/bug-tracking/issue/index/id/933

, ; , . reset . , .

, ElasticSearch .

Answer 2

.. , DB InnonDB.

Answer 3

(SSH).

Magento. .

// To check the indexer status.
php -f indexer.php status 

// To reindex the indexer data.
php -f indexer.php reindex

// To check the any help in this indexer process.
php -f indexer.php help

SSH, .