The total number of locks exceeds the lock table size for query
We are seeing a number of database query errors in our Wordpress logs that state, "The total number of locks exceeds the lock table size for query". This occurs on queries for wp_options and wp_posts. We believe this to be a cause of slow performance when using the Wordpress dashboard.
This error appears to have something to do with the buffer pool size, but aside from that, we can't figure out how to fix.