{"id":4658,"date":"2024-03-14T01:44:41","date_gmt":"2024-03-14T01:44:41","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/"},"modified":"2025-07-31T11:19:41","modified_gmt":"2025-07-31T11:19:41","slug":"what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/","title":{"rendered":"MySQL Autocommit Explained: Control Guide"},"content":{"rendered":"

In MySQL, auto-commit means that after each SQL statement finishes executing, it is immediately committed to the database, even if it’s still within the same transaction. This implies that each SQL statement takes effect immediately and you don’t need to manually execute a COMMIT statement to commit the transaction.<\/p>\n

To control and manage automatic submissions, you can do so in the following ways:<\/p>\n

    \n
  1. With the SET statement, you can temporarily change the setting of auto-commit, for example, you can use the following statement to disable auto-commit.<\/li>\n<\/ol>\n
    SET autocommit = 0;\r\n<\/code><\/pre>\n
    Alternatively, you can enable automatic submission.<\/p>\n
    SET autocommit = 1;\r\n<\/code><\/pre>\n
      \n
    1. You can control the submission of a transaction explicitly by using START TRANSACTION and COMMIT statements at the beginning and end of the transaction.<\/li>\n<\/ol>\n
      START TRANSACTION;\r\n-- \u6267\u884c\u4e00\u7cfb\u5217SQL\u8bed\u53e5\r\nCOMMIT;\r\n<\/code><\/pre>\n
        \n
      1. Edit the MySQL configuration file: You can permanently change the settings for auto commit by editing the MySQL configuration file (such as my.cnf). Locate the following parameters to make changes.<\/li>\n<\/ol>\n
        autocommit = 1;  \/\/ \u6253\u5f00\u81ea\u52a8\u63d0\u4ea4\r\n\u6216\r\nautocommit = 0;  \/\/ \u5173\u95ed\u81ea\u52a8\u63d0\u4ea4\r\n<\/code><\/pre>\n
        The above methods allow for easy control and management of automatic submission behavior in MySQL, allowing for flexible adjustment of transaction submission based on business needs.<\/p>\n","protected":false},"excerpt":{"rendered":"
        In MySQL, auto-commit means that after each SQL statement finishes executing, it is immediately committed to the database, even if it’s still within the same transaction. This implies that each SQL statement takes effect immediately and you don’t need to manually execute a COMMIT statement to commit the transaction. To control and manage automatic submissions, […]<\/p>\n","protected":false},"author":9,"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":[2136,4417,4418,3539,4419],"class_list":["post-4658","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database-transactions","tag-mysql-autocommit","tag-mysql-settings","tag-sql-commit","tag-transaction-control"],"yoast_head":"\nMySQL Autocommit Explained: Control Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how MySQL autocommit works and master its control with SET commands for optimal transaction management.\" \/>\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\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Autocommit Explained: Control Guide\" \/>\n<meta property=\"og:description\" content=\"Learn how MySQL autocommit works and master its control with SET commands for optimal transaction management.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/\" \/>\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-14T01:44:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-31T11:19:41+00:00\" \/>\n<meta name=\"author\" content=\"Ava Mitchell\" \/>\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=\"Ava Mitchell\" \/>\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\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/\"},\"author\":{\"name\":\"Ava Mitchell\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\"},\"headline\":\"MySQL Autocommit Explained: Control Guide\",\"datePublished\":\"2024-03-14T01:44:41+00:00\",\"dateModified\":\"2025-07-31T11:19:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/\"},\"wordCount\":180,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"database transactions\",\"MySQL autocommit\",\"MySQL settings\",\"SQL commit\",\"transaction control\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/\",\"name\":\"MySQL Autocommit Explained: Control Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T01:44:41+00:00\",\"dateModified\":\"2025-07-31T11:19:41+00:00\",\"description\":\"Learn how MySQL autocommit works and master its control with SET commands for optimal transaction management.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Autocommit Explained: Control 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\/a3e2658c2cb9fb2be95ae0a8861f4a64\",\"name\":\"Ava Mitchell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"caption\":\"Ava Mitchell\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MySQL Autocommit Explained: Control Guide - Blog - Silicon Cloud","description":"Learn how MySQL autocommit works and master its control with SET commands for optimal transaction management.","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\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/","og_locale":"en_US","og_type":"article","og_title":"MySQL Autocommit Explained: Control Guide","og_description":"Learn how MySQL autocommit works and master its control with SET commands for optimal transaction management.","og_url":"https:\/\/www.silicloud.com\/blog\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T01:44:41+00:00","article_modified_time":"2025-07-31T11:19:41+00:00","author":"Ava Mitchell","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Ava Mitchell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/"},"author":{"name":"Ava Mitchell","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64"},"headline":"MySQL Autocommit Explained: Control Guide","datePublished":"2024-03-14T01:44:41+00:00","dateModified":"2025-07-31T11:19:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/"},"wordCount":180,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["database transactions","MySQL autocommit","MySQL settings","SQL commit","transaction control"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/","url":"https:\/\/www.silicloud.com\/blog\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/","name":"MySQL Autocommit Explained: Control Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T01:44:41+00:00","dateModified":"2025-07-31T11:19:41+00:00","description":"Learn how MySQL autocommit works and master its control with SET commands for optimal transaction management.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/what-is-automatic-commit-in-mysql-and-how-can-it-be-controlled-and-managed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL Autocommit Explained: Control 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\/a3e2658c2cb9fb2be95ae0a8861f4a64","name":"Ava Mitchell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","caption":"Ava Mitchell"},"url":"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4658","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\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=4658"}],"version-history":[{"count":3,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4658\/revisions"}],"predecessor-version":[{"id":149348,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4658\/revisions\/149348"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=4658"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=4658"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=4658"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}