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

              People

              • Assignee:
                KennethDyer Kenneth Dyer
                Reporter:
                valerii Valerii Kravchuk
              • Votes:
                0 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: