Subscribe to the
Percona Newsletter

Subscribe Now!
  Thursday, May 12, 2016    Sveta Smirnova

- 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.

About the Author

Sveta Smirnova

Sveta joined Percona in 2015. Her main professional interests are problem solving, working with tricky issues, bugs, finding patterns which can solve typical issues quicker, teaching others how to deal with MySQL issues, bugs and gotchas effectively. Before joining Percona Sveta worked as Support Engineer in MySQL Bugs Analysis Support Group in MySQL AB-Sun-Oracle. She is author of book "MySQL Troubleshooting" and JSON UDF functions for MySQL.