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.
Reduce disk I/O for small reads using memory7 August 2008·Updated: 26 November 2023·353 words·2 minsMany applications that are used on a standard server perform quite a few of small writes to the disk (like MySQL or Apache).