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

Document tc.log usage by default and the fact that wsrep in 10.1+ is an XA-capable storage engine

Details

    Description

      According to https://mariadb.com/kb/en/library/changes-improvements-in-mariadb-101/, Galera (wsrep stroage engine in SHOW PLUGINS output, to be more specific) is a standard part of MariaDB 10.1 (and newer version).

      It is not documented anywhere explicitly, but one can conclude from code review and fix for MDEV-9214 that wsrep is XA-capable storage engine. With it we'll have tc.log created in the datadir of 10.1+ and maintained by default, even if wsrep_on is set to OFF and InnoDB is the only XA-capable storage engine listed in SHOW ENGINES:

      MariaDB [test]> \! ls -l data/*.log
      		 
      -rw-rw---- 1 openxs openxs 24576 чер  8 17:25 data/tc.log
      		 
      MariaDB [test]> select @@datadir, @@wsrep_on, @@log_bin;
      		 
      +----------------------------------+------------+-----------+
      		 
      | @@datadir                        | @@wsrep_on | @@log_bin |
      		 
      +----------------------------------+------------+-----------+
      		 
      | /home/openxs/dbs/maria10.1/data/ |          0 |         0 |
      		 
      +----------------------------------+------------+-----------+
      		 
      1 row in set (0.00 sec)
      		 
       
      		 
      MariaDB [test]> show engines;
      		 
      +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
      		 
      | Engine             | Support | Comment                                                                                          | Transactions | XA   | Savepoints |
      		 
      +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
      		 
      | MRG_MyISAM         | YES     | Collection of identical MyISAM tables                                                            | NO           | NO   | NO         |
      		 
      | CSV                | YES     | CSV storage engine                                                                               | NO           | NO   | NO         |
      		 
      | BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears)                                   | NO           | NO   | NO         |
      		 
      | MyISAM             | YES     | MyISAM storage engine                                                                            | NO           | NO   | NO         |
      		 
      | SEQUENCE           | YES     | Generated tables filled with sequential values                                                   | YES          | NO   | YES        |
      		 
      | Aria               | YES     | Crash-safe tables with MyISAM heritage                                                           | NO           | NO   | NO         |
      		 
      | PERFORMANCE_SCHEMA | YES     | Performance Schema                                                                               | NO           | NO   | NO         |
      		 
      | InnoDB             | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables | YES          | YES  | YES        |
      		 
      | MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                                        | NO           | NO   | NO         |
      		 
      +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
      		 
      9 rows in set (0.00 sec)

      I found literally nothing in MariaDB KB about the tc.log file and numerous bug reports mentioning failures to create it etc mean that this information is clearly missing. MySQL's reference here, https://dev.mysql.com/doc/refman/5.6/en/server-options.html#option_mysqld_log-tc, refers to multiple storage engines:

      "... memory-mapped transaction coordinator log file (for XA transactions that affect multiple storage engines when the binary log is disabled)."

      and is not helpful unless we document Galera (wsrep) engine as the one that causes this file to be created in 10.1+.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14339 Different Galera performance behavior regarding to flushing between MySQL and MariaDB

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16509 MariaDB 10.1+ with wsrep_on=ON performs better when log_bin is enabled

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              KennethDyer Kenneth Dyer (Inactive)
              valerii Valerii Kravchuk
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.