Hi,
I am experiencing a query locking issue on my Percona XtraDB Cluster (version 8.0.36-28.1 for Linux, WSREP version 26.1.4.3).
To resolve the issue, I am running the cluster on a single node
I am running the following update query:
UPDATE products SET productBrand = 'TEST' WHERE customerID = '25117' AND productID IN (25555346, ..., 25747112);
The total number of rows affected by this query is 8763. When I run the query with productID 8763, it completes successfully in about 4 seconds. However, if I add one more productID (so there are 8764 rows), the query does not complete and locks the entire table.
Could this be due to a limitation in the Percona XtraDB Cluster configuration? If so, what would be the relevant limit that would affect this?
Thanks in advance for any suggestions or guidance.