Shulou(Shulou.com)05/31 Report--

This article mainly shows you the "sample Analysis of innodb query Lock", which is easy to understand and clear. I hope it can help you solve your doubts. Let the editor lead you to study and study the "sample Analysis of innodb query Lock".

Innodb query lock

Select r.trx_id waiting_trx_id, r.trx_mysql_thread_Id waiting_thread,b.TRX_STATE holer_state,r.trx_state blocking_state

R.trx_query waiting_query, b.trx_id blocking_trx_id

B.trx_mysql_thread_id blocking_thread, b.trx_query blocking_query

From information_schema.innodb_lock_waits w inner join information_schema.innodb_trx b on b.trx_id = w.blocking_trx_id

Inner join information_schema.innodb_trx r on r.trx_id = w.requesting_trx_id

The above is all the contents of the article "sample Analysis of innodb query Lock". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.