|
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.
|
[MDEV-7507]