* When two processes are waiting to update the rows of a table which are locked by another process, the situation is called a deadlock.
The reasons for it to happen are :
* lack of proper row lock commands.
* Poor design of front-end application
* It reduces the performance of the server severely.
* These locks get automatically released automatically when a commit/rollback operation is performed or any process is killed externally.
