MySQL Forums
Forum List  »  InnoDB

Re: Lock wait timeout exceeded; try restarting transaction error - do I need a different index?
Posted by: Peter Brawley
Date: February 24, 2018 10:49AM

> not sure how to get the tabs to space the columns out correctly

BBCode code tags

> SIMPLE myTable ALL NULL NULL NULL NULL 51017825

Right, MySQL can't find an index it likes for this query, I'd experiment to try to find one it can use.

innodb_buffer_pool_size is way too low, should be ~70% of available RAM. Once that's fixed, an index may bring performance to acceptable levels. If not, you may have to choose between adding RAM or doing a workaround, eg chunk the deletion job.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Lock wait timeout exceeded; try restarting transaction error - do I need a different index?
482
February 24, 2018 10:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.