Troubleshooting locking issues
- Perfectly optimized query runs slow?
- Application does not receive answers from MySQL server?
- Updates get rejected?
All these are symptoms of locking issues. Understanding how to troubleshoot them is essential for database applications that use more than one connection.
In this webinar we will discuss three kinds of locks that MySQL supports, how they can affect the application and effective diagnostic methods. You will know when table, row and metadata locks are acquired, how to find that are currently is in use, how they can affect your application and how to fix issues that they cause.