Innodb_lock_wait_timeout issue for magento

Asked May 26 '14 at 14:46

Active Jul 24 '14 at 07:17

Viewed 1,558 times

I am facing error in Innodb_lock_wait_timeout issue on MySQL. My application is on Magento and databases size is around 84 GB. While running Individual commands for re-indexing I am getting following error.
MySQL Lock wait timeout exceeded; try restarting transaction.

NOTE:- Mysql server is having 16 GB ram separately.

edited Jul 24 '14 at 07:17

Atur

1,712
6
32
42

asked May 26 '14 at 14:46

Nataraj

check this http://stackoverflow.com/questions/5836623/getting-lock-wait-timeout-exceeded-try-restarting-transaction-even-though-im – jdiver May 26 '14 at 19:15
Is the issue related to uploading a large size DB ? – Slimshadddyyy May 27 '14 at 04:21

Innodb_lock_wait_timeout issue for magento

0 Answers0