Login to manage your account

Your email Please enter a valid email address.

Password Forgot Password?

Please enter a valid password.

OR

Don't have an account yet? Sign up

What happens when InnoDB detects a deadlock?

A Both transactions hang until timeout
B It rolls back the transaction that has done less work
C It restarts the MySQL server
D It commits both transactions

Answer

It rolls back the transaction that has done less work

InnoDB detects the lock cycle and rolls back the cheaper victim with error 1213. Applications must be written to retry the failed transaction.

Login to manage your account

Your email id Please enter a valid email address.

Password Forgot Password?

Please enter a valid password.

OR

Don't have an account yet? Sign up as

Jobseeker

Employer