MySQL: The total number of locks exceeds the lock table size16 February 2010·Updated: 26 November 2023·181 words·1 minIf you’re running an operation on a large number of rows within a table that uses the InnoDB storage engine, you might see this error:
MySQL: The total number of locks exceeds the lock table size29 January 2010·Updated: 26 November 2023·335 words·2 minsThis problem has cropped up for me a few times, but I’ve always forgotten to make a post about it.