![]() ![]() mysql> set global innodbprintalldeadlocks1 Query OK, 0 rows affected (0. After executing the above statement, let us execute the below syntax in order to display all deadlock logs. INSERT INTO serverseeduse (id, clientSeed, nonce, serverSeedId) VALUES (DEFAULT, 'clientSeed', DEFAULT, 1) If executed only once or after the previous query has finished, works just fine but once executed concurrently 2 or more times the deadlock happens. Out of 9 concurrent transactions 3 of those gets rolled back as deadlock victim. Display all deadlock logs in MySQL First of all, you need to enable innodbprintalldeadlocks. Transaction C requests lock for author 1.Transaction B requests lock for author 1. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |