{"id":13485,"date":"2024-03-15T07:13:01","date_gmt":"2024-03-15T07:13:01","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/"},"modified":"2025-08-05T19:04:35","modified_gmt":"2025-08-05T19:04:35","slug":"how-to-query-the-table-for-deadlocks-in-mysql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/","title":{"rendered":"MySQL Deadlock Check: Query for InnoDB Deadlocks"},"content":{"rendered":"

To investigate deadlock in a table, you can follow these steps:<\/p>\n

    \n
  1. Execute the following command to check the current deadlock situation:<\/li>\n
  2. Display the InnoDB storage engine status.<\/li>\n
  3. In the results, locate the section for “InnoDB” and look for the phrase “LATEST DETECTED DEADLOCK”.<\/li>\n
  4. Detailed information about the deadlock will be listed below, including the transaction ID, locks being waited for and held, and the deadlock chain.<\/li>\n
  5. Based on the information in the deadlock chain, the involved tables can be identified. Each transaction will display the locked resources it holds and is waiting for, allowing for the relevant tables to be found.<\/li>\n
  6. You can use the following query statement to find the specific operation of a deadlock transaction based on its transaction ID.<\/li>\n
  7. Retrieve all data from the table “innodb_trx” in the information schema where the transaction ID is equal to ‘deadlock_transaction_id’.<\/li>\n
  8. Replace “deadlock_transaction_id” with the actual transaction ID.<\/li>\n<\/ol>\n

    By following the above steps, you can query the tables and transaction information related to deadlocks.<\/p>\n","protected":false},"excerpt":{"rendered":"

    To investigate deadlock in a table, you can follow these steps: Execute the following command to check the current deadlock situation: Display the InnoDB storage engine status. In the results, locate the section for “InnoDB” and look for the phrase “LATEST DETECTED DEADLOCK”. Detailed information about the deadlock will be listed below, including the transaction […]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[17987,17988,17986,17978,1773],"class_list":["post-13485","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database-deadlock","tag-deadlock-detection","tag-innodb-deadlocks","tag-mysql-deadlock","tag-mysql-query"],"yoast_head":"\nMySQL Deadlock Check: Query for InnoDB Deadlocks - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to detect MySQL deadlocks by querying InnoDB status logs and analyzing deadlock chains.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Deadlock Check: Query for InnoDB Deadlocks\" \/>\n<meta property=\"og:description\" content=\"Learn how to detect MySQL deadlocks by querying InnoDB status logs and analyzing deadlock chains.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T07:13:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-05T19:04:35+00:00\" \/>\n<meta name=\"author\" content=\"Benjamin Taylor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin Taylor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/\"},\"author\":{\"name\":\"Benjamin Taylor\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9\"},\"headline\":\"MySQL Deadlock Check: Query for InnoDB Deadlocks\",\"datePublished\":\"2024-03-15T07:13:01+00:00\",\"dateModified\":\"2025-08-05T19:04:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/\"},\"wordCount\":176,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"database deadlock\",\"deadlock detection\",\"InnoDB deadlocks\",\"MySQL deadlock\",\"MySQL query\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/\",\"name\":\"MySQL Deadlock Check: Query for InnoDB Deadlocks - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T07:13:01+00:00\",\"dateModified\":\"2025-08-05T19:04:35+00:00\",\"description\":\"Learn how to detect MySQL deadlocks by querying InnoDB status logs and analyzing deadlock chains.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Deadlock Check: Query for InnoDB Deadlocks\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9\",\"name\":\"Benjamin Taylor\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g\",\"caption\":\"Benjamin Taylor\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/benjamintaylor\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MySQL Deadlock Check: Query for InnoDB Deadlocks - Blog - Silicon Cloud","description":"Learn how to detect MySQL deadlocks by querying InnoDB status logs and analyzing deadlock chains.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/","og_locale":"en_US","og_type":"article","og_title":"MySQL Deadlock Check: Query for InnoDB Deadlocks","og_description":"Learn how to detect MySQL deadlocks by querying InnoDB status logs and analyzing deadlock chains.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T07:13:01+00:00","article_modified_time":"2025-08-05T19:04:35+00:00","author":"Benjamin Taylor","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Benjamin Taylor","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/"},"author":{"name":"Benjamin Taylor","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9"},"headline":"MySQL Deadlock Check: Query for InnoDB Deadlocks","datePublished":"2024-03-15T07:13:01+00:00","dateModified":"2025-08-05T19:04:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/"},"wordCount":176,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["database deadlock","deadlock detection","InnoDB deadlocks","MySQL deadlock","MySQL query"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/","name":"MySQL Deadlock Check: Query for InnoDB Deadlocks - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T07:13:01+00:00","dateModified":"2025-08-05T19:04:35+00:00","description":"Learn how to detect MySQL deadlocks by querying InnoDB status logs and analyzing deadlock chains.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-the-table-for-deadlocks-in-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL Deadlock Check: Query for InnoDB Deadlocks"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9","name":"Benjamin Taylor","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g","caption":"Benjamin Taylor"},"url":"https:\/\/www.silicloud.com\/blog\/author\/benjamintaylor\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13485","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=13485"}],"version-history":[{"count":3,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13485\/revisions"}],"predecessor-version":[{"id":157474,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13485\/revisions\/157474"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=13485"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=13485"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=13485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}