{"id":13497,"date":"2024-03-15T07:14:14","date_gmt":"2024-03-15T07:14:14","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-query-deadlocks-logs-in-mysql\/"},"modified":"2025-08-05T19:16:49","modified_gmt":"2025-08-05T19:16:49","slug":"how-to-query-deadlocks-logs-in-mysql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-query-deadlocks-logs-in-mysql\/","title":{"rendered":"Query MySQL Deadlock Logs Guide"},"content":{"rendered":"

To check the deadlock log in MySQL, follow these steps:<\/p>\n

    \n
  1. Open the configuration file for MySQL (my.cnf or my.ini) and locate the following configuration items to edit:<\/li>\n
  2. In the configuration for the MySQL server, set the output log to a file by enabling general logging and specifying the path to the log file.<\/li>\n
  3. Set general-log to 1 to enable the general log, and specify general-log-file as the path for the log file.<\/li>\n
  4. Restart the MySQL service for the configuration to take effect.<\/li>\n
  5. Login to the MySQL server from the MySQL client.<\/li>\n
  6. Execute the following command to query the deadlock logs:<\/li>\n
  7. Display all global variables that relate to the general log.<\/li>\n
  8. This command will display the value of general_log to ensure it is set to ON.<\/li>\n
  9. Execute the following command to query the file path of the deadlock log:<\/li>\n
  10. Display all global variables that match the pattern ‘general_log_file’.<\/li>\n
  11. This command will display the value of general_log_file, which is the file path for the deadlock log.<\/li>\n
  12. Open the deadlock log file with a text editor to view the recorded deadlock information.<\/li>\n<\/ol>\n

    Please be aware that enabling general logging in a production environment may have a certain impact on performance and cause log files to quickly grow in size. Therefore, it is recommended to disable general logging after querying deadlock logs and periodically clean up log files.<\/p>\n","protected":false},"excerpt":{"rendered":"

    To check the deadlock log in MySQL, follow these steps: Open the configuration file for MySQL (my.cnf or my.ini) and locate the following configuration items to edit: In the configuration for the MySQL server, set the output log to a file by enabling general logging and specifying the path to the log file. Set general-log […]<\/p>\n","protected":false},"author":10,"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":[4477,18000,4226,17978,1613],"class_list":["post-13497","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database-logs","tag-deadlock-logs","tag-mysql-configuration","tag-mysql-deadlock","tag-mysql-troubleshooting"],"yoast_head":"\nQuery MySQL Deadlock Logs Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn to enable and query MySQL deadlock logs using my.cnf configuration. Quick steps to view deadlock diagnostics.\" \/>\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-deadlocks-logs-in-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Query MySQL Deadlock Logs Guide\" \/>\n<meta property=\"og:description\" content=\"Learn to enable and query MySQL deadlock logs using my.cnf configuration. Quick steps to view deadlock diagnostics.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-query-deadlocks-logs-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:14:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-05T19:16:49+00:00\" \/>\n<meta name=\"author\" content=\"Jackson Davis\" \/>\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=\"Jackson Davis\" \/>\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-deadlocks-logs-in-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-deadlocks-logs-in-mysql\/\"},\"author\":{\"name\":\"Jackson Davis\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\"},\"headline\":\"Query MySQL Deadlock Logs Guide\",\"datePublished\":\"2024-03-15T07:14:14+00:00\",\"dateModified\":\"2025-08-05T19:16:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-deadlocks-logs-in-mysql\/\"},\"wordCount\":235,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"database logs\",\"deadlock logs\",\"MySQL configuration\",\"MySQL deadlock\",\"MySQL troubleshooting\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-deadlocks-logs-in-mysql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-deadlocks-logs-in-mysql\/\",\"name\":\"Query MySQL Deadlock Logs Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T07:14:14+00:00\",\"dateModified\":\"2025-08-05T19:16:49+00:00\",\"description\":\"Learn to enable and query MySQL deadlock logs using my.cnf configuration. Quick steps to view deadlock diagnostics.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-deadlocks-logs-in-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-query-deadlocks-logs-in-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-deadlocks-logs-in-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Query MySQL Deadlock Logs Guide\"}]},{\"@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\/55a10b8b0457c35884c25677889ad350\",\"name\":\"Jackson Davis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"caption\":\"Jackson Davis\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Query MySQL Deadlock Logs Guide - Blog - Silicon Cloud","description":"Learn to enable and query MySQL deadlock logs using my.cnf configuration. Quick steps to view deadlock diagnostics.","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-deadlocks-logs-in-mysql\/","og_locale":"en_US","og_type":"article","og_title":"Query MySQL Deadlock Logs Guide","og_description":"Learn to enable and query MySQL deadlock logs using my.cnf configuration. Quick steps to view deadlock diagnostics.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-query-deadlocks-logs-in-mysql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T07:14:14+00:00","article_modified_time":"2025-08-05T19:16:49+00:00","author":"Jackson Davis","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Jackson Davis","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-deadlocks-logs-in-mysql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-deadlocks-logs-in-mysql\/"},"author":{"name":"Jackson Davis","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350"},"headline":"Query MySQL Deadlock Logs Guide","datePublished":"2024-03-15T07:14:14+00:00","dateModified":"2025-08-05T19:16:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-deadlocks-logs-in-mysql\/"},"wordCount":235,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["database logs","deadlock logs","MySQL configuration","MySQL deadlock","MySQL troubleshooting"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-deadlocks-logs-in-mysql\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-query-deadlocks-logs-in-mysql\/","name":"Query MySQL Deadlock Logs Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T07:14:14+00:00","dateModified":"2025-08-05T19:16:49+00:00","description":"Learn to enable and query MySQL deadlock logs using my.cnf configuration. Quick steps to view deadlock diagnostics.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-deadlocks-logs-in-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-query-deadlocks-logs-in-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-deadlocks-logs-in-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Query MySQL Deadlock Logs Guide"}]},{"@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\/55a10b8b0457c35884c25677889ad350","name":"Jackson Davis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","caption":"Jackson Davis"},"url":"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13497","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\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=13497"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13497\/revisions"}],"predecessor-version":[{"id":157487,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13497\/revisions\/157487"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=13497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=13497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=13497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}