Category Archives: DeadLock

Day 25 Optimization

Locking is depends upon Isolation level and Storage Engine. MySQL uses table level locking (instead of page, row, or column locking) for all storage engines except InnoDB, which uses row level locking locking system in MySQL: Implicit Locking: To maintain the … Continue reading

Posted in DeadLock, Lock/Blocking, MySQL, Others, Performance Tuning, What I learned today | Tagged , , , | Leave a comment

Lock Info

Lock: As we have discussed about introduction locks here(in our earlier blog). Here we will discuss how to trouble shoot locking. Locking is good to maintain the consistency of our data. Means when someone is update our data no one … Continue reading

Posted in DeadLock, Lock/Blocking, Performance Tuning | Tagged | Leave a comment

Deadlock part 1 -brief.

I already shared some of the great links for deadlock in my earlier blog here got a question for my interview what is deadlock?, so would like to brief about it, following description would be deadlock by simple transactions which … Continue reading

Posted in DeadLock, General, What I learned today | Tagged | Leave a comment