I have a MySQL database with 21M records and I'm trying to do an update on about 1M records but the query fails with ERROR 1206 (HY000): The total number of locks exceeds the lock table size.
Is it possible to update the table without acquiring locks?
I don't have access to change MySQL configuration parameters like innodb_buffer_pool_size
. Is there a different way to achieve the same?
Thanks
EDIT:
I think you can use the limit clause to do the updates in batches.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With