All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.

learn more… | top users | synonyms

4
votes
1answer
91 views
+50

MySQL locking in Duplicate Key Error

From the docs: If a duplicate-key error occurs, a shared lock on the duplicate index record is set. This use of a shared lock can result in deadlock should there be multiple sessions trying to ...
1
vote
2answers
31 views
+250

Galera: any drawback of enabling wsrep_log_conflicts and cert.log_conflicts?

We have a HAProxy which balances reads and writes to only one (of three) Galera nodes. If this balancing works fine, the parameters wsrep_log_conflicts and cert.log_conflicts should never log any ...