MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: The total number of locks exceeds the lock table sizeSource
Posted by: Peter Brawley
Date: October 07, 2019 11:16AM

See https://bugs.mysql.com/bug.php?id=83986, we'd have to see the log in order to understand how the query sequence elicited this crash.

If you can identify the query sequence, modifying the app for debugging purposes to log the result of show engine innodb status after each query might help illuminate what's going on.

If MySQL can use all 48GB, you could safely increase the buffer pool to 36GB.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
The total number of locks exceeds the lock table sizeSource
6219
Avi Vainshtein
October 07, 2019 02:16AM
Re: The total number of locks exceeds the lock table sizeSource
1374
Peter Brawley
October 07, 2019 11:16AM


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.