[MDEV-24372] Unable to set aria_block_size on Windows before initializing the data directory Created: 2020-12-08 Updated: 2021-09-08 Resolved: 2020-12-09 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Platform Windows |
| Affects Version/s: | None |
| Fix Version/s: | 10.6.0 |
| Type: | Bug | Priority: | Major |
| Reporter: | Maria M Pflaum | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
mysql_install_db.exe will not read any my.ini when initializing the data director. If a my.ini is present in datadir, it won't run at all; if a my.ini is not present, it runs and passes --no-defaults to mysqld.exe, which assumes hard-coded defaults for all server variables. It always initializes the system tables with default aria_block_size of 8192 (consistent with the docs: https://mariadb.com/kb/en/aria-system-variables/#aria_block_size). Placing a my.ini on some of the common locations on Windows has not worked. None are detected because mysqld.exe is called with --no-defaults. Also, in general, mysql_install_db.exe creates the Windows service with the mysqld option --defaults-file="C:\path\to\datadir\my.ini", which is where its barebones my.ini is created. Changing aria_block_size in my.ini after initialization will result in failure to start mysqld, with the following in the error log:
Removing aria_log_control and aria_log.#### files from the datadir results in the following startup failures:
|