Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6881 MariaDB Documentation improvements
  3. MDEV-7507

wrong MariaDB 10.0 documentation for init_file variable

    XMLWordPrintable

    Details

    • Type: Technical task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.15-galera, 5.5.39, 10.0.11, 10.0.12, 10.0.13, 10.0.14, 10.0.15
    • Fix Version/s: N/A
    • Component/s: Documentation
    • Labels:
      None

      Description

      At MariaDB documentation here https://mariadb.com/kb/en/mariadb/server-system-variables/#init_file is stated that the in init_file
      each statement should be on a new line with no terminators (such as a semicolon).
      However, tested at 5.5.39-MariaDB-log version, and there the syntax with semicolons is working, along with the one without end line terminators.
      Tested with MariaDB 10.0.13, MariaDB 10.0.15 and MariaDB Galera 10.0.15 , that syntax is not readable anymore, and semicolons are expected , otherwise the statements are no executed, as in the example bellow:
      ===========================

      150127 15:51:50 [Note] Event Scheduler: Loaded 0 events
      ERROR: 1105  Bootstrap file error, return code (0). Nearest query: 'set @old_blocks_pct = @@global.innodb_old_blocks_pct
      set @@global.innodb_old_blocks_pct = 95
      SET SESSION group_concat_max_len=100*1024*1024
      SELECT GROUP_CONCAT(CONCAT('SELECT COUNT(',column_name,') FROM ',table_schema,'.',table_name,' FORCE INDEX (',index_name,')') SEPARATOR ' UNION ALL ') INTO @sql FROM information_schema.statistics WHERE table_schema NOT IN ('information_schema','mysql') AND seq_in_index = 1
      PREPARE stmt FROM @sql
      EXECUTE stmt
      DEALLO
      150127 15:51:50 [Note] /usr/sbin/mysqld: ready for connections.
      Version: '10.0.13-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
      

      MariaDB 10.0.15 Galera:

      150127 14:39:32 [Note] WSREP: wsrep_load(): loading provider library 'none'
      ERROR: 1105  Bootstrap file error, return code (0). Nearest query: 'set @old_blocks_pct = @@global.innodb_old_blocks_pct
      set @@global.innodb_old_blocks_pct = 95
      SET SESSION group_concat_max_len=100*1024*1024
      SELECT GROUP_CONCAT(CONCAT('SELECT COUNT(',column_name,') FROM ',table_schema,'.',table_name,' FORCE INDEX (',index_name,')') SEPARATOR ' UNION ALL ') INTO @sql FROM information_schema.statistics WHERE table_schema NOT IN ('information_sc
      hema','mysql') AND seq_in_index = 1
      PREPARE stmt FROM @sql
      EXECUTE stmt
      DEALLO
      150127 14:39:32 [Note] /usr/sbin/mysqld: ready for connections.
      Version: '10.0.15-MariaDB-wsrep'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server, wsrep_25.10.r4144
      

      ===============
      So the MySQL manual description of the init_file at http://dev.mysql.com/doc/refman/5.6/en/server-options.html#option_mysqld_init-file:

      Read SQL statements from this file at startup. Each statement must be on a single line and should not include comments.
      

      Should be good enough.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              greenman Ian Gilfillan
              Reporter:
              ivan.stoykov@skysql.com Stoykov (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.