Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6495

innodb_flush_log_at_trx_commit=0 as suggestion for galera vs =2

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Fixed
        • Affects Version/s: 5.5.38-galera, 10.0.12-galera
        • Fix Version/s: 5.5.39-galera, 10.0.13-galera
        • Component/s: None
        • Labels:

          Description

          =0 is a better value that =2 because it is a background thread where durability is achieved based on isolated galera machines based on this research: openquery.com.au/blog/innodbflushlogsontrxcommit-galeracluster

          upstream pull request for codership documentation: https://github.com/codership/galera/pull/86

          patch:

          === modified file 'debian/additions/my.cnf'
--- debian/additions/my.cnf     2014-07-17 20:22:01 +0000
+++ debian/additions/my.cnf     2014-07-28 07:04:36 +0000
@@ -165,7 +165,7 @@
 #query_cache_size=0
 #
 # Optional setting
-#innodb_flush_log_at_trx_commit=2
+#innodb_flush_log_at_trx_commit=0
 
 [mysqldump]
 quick

=== modified file 'support-files/rpm/server.cnf'
--- support-files/rpm/server.cnf        2014-07-17 20:22:01 +0000
+++ support-files/rpm/server.cnf        2014-07-28 07:04:52 +0000
@@ -25,7 +25,7 @@
 #query_cache_size=0
 #
 # Optional setting
-#innodb_flush_log_at_trx_commit=2
+#innodb_flush_log_at_trx_commit=0
 
 # this is only for embedded server
 [embedded]

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                nirbhay_c Nirbhay Choubey added a comment -

                Thank you for the suggestion. Updated.
                http://bazaar.launchpad.net/~maria-captains/maria/maria-5.5-galera/revision/3515

                Show
                nirbhay_c Nirbhay Choubey added a comment - Thank you for the suggestion. Updated. http://bazaar.launchpad.net/~maria-captains/maria/maria-5.5-galera/revision/3515

                  People

                  • Assignee:
                    nirbhay_c Nirbhay Choubey
                    Reporter:
                    danblack Daniel Black
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: