Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 10.0.14
-
Fix Version/s: 10.1.6
-
Component/s: Replication
-
Labels:None
Description
I noticed MariaDB does not have corresponding MySQL system variables:
log_bin_basename and log_bin_index
Without log_bin_basename, there is no way to tell the location and name of the binary log.
This is easily identifiable in MySQL:
mysql> show global variables like 'log_bin%'; +---------------------------------+---------------------------------------------------------------------+ | Variable_name | Value | +---------------------------------+---------------------------------------------------------------------+ | log_bin | ON | | log_bin_basename | C:\Program Files\MySQL\MySQL Server 5.6\Data\chris-laptop-bin | | log_bin_index | C:\Program Files\MySQL\MySQL Server 5.6\Data\chris-laptop-bin.index |
Without these, you can only conform whether binlogging is enabled or not.
Gliffy Diagrams
Attachments
Issue Links
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
log-bin-basename is actually listed in MDEV-5277, in the last section "NO_CMD_LINE options", which are said not to be added.
Assigning to Sergey Vojtovich who can probably remember why it was decided not to add it, and comment on log_bin_index as well.
MDEV-5277 was supposed to add missing command line options. While these options have NO_CMD_LINE flag, which means they're just system variables without corresponding command line.
MySQL revision-id is mats.kindahl@oracle.com-20101104144352-z7dy7e46jlexdfnw
They should probably be added indeed.
Kristian Nielsen, could you take this? Upstream patch is a bit more than just adding log_bin_basename and log_bin_index. I'm not sure if those changes are valuable.
Patch:
https://github.com/MariaDB/server/commit/f965cae5fb04a9fd06a939a8f2b52228a62ce9fa
KB entries:
- https://mariadb.com/kb/en/mariadb/replication-and-binary-log-server-system-variables/#log_bin_basename
- https://mariadb.com/kb/en/mariadb/replication-and-binary-log-server-system-variables/#log_bin_index
- https://mariadb.com/kb/en/mariadb/replication-and-binary-log-server-system-variables/#relay_log_basename
These variables were not listed in the report below, and it is "closed", hence this new bug report:
https://mariadb.atlassian.net/browse/MDEV-5277