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

          Activity

            valerii Valerii Kravchuk created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Component/s Documentation [ 10903 ]
            elenst Elena Stepanova made changes -
            Assignee Russell Dyer [ russell.dyer ]
            julien.fritsch Julien Fritsch made changes -
            Assignee Russell Dyer [ russell.dyer ] Kenneth Dyer [ kennethdyer ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s N/A [ 14700 ]
            julien.fritsch Julien Fritsch made changes -
            Component/s Documentation - Support [ 14512 ]
            julien.fritsch Julien Fritsch made changes -
            Component/s Documentation [ 10903 ]
            KennethDyer Kenneth Dyer (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            KennethDyer Kenneth Dyer (Inactive) made changes -
            Status In Progress [ 3 ] In Review [ 10002 ]
            julien.fritsch Julien Fritsch made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            GeoffMontee Geoff Montee (Inactive) made changes -
            Component/s Plugins [ 10118 ]
            Resolution Fixed [ 1 ]
            Status In Review [ 10002 ] Closed [ 6 ]
            GeoffMontee Geoff Montee (Inactive) made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 87758 ] MariaDB v4 [ 154487 ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 165555

            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.